[RESOLVED] Crystal Report 11 and Visual Basic 6.0 sql query....

[intellogo]

Hi,

I have a report desigend in Crystal Report 11. The report has 2 sections which is divided in between by a simple dark line.
The report's left side has the fields of TABLE A and will be used to show records from TABLE A only.
And the report's right side has the fields of TABLE B and will be used to show records from TABLE B only.

I thought of the following idea:
The best & easiedt thing is to pass 2 different SQL statments in vb code. One for table A and the other for table B, so that i can view information of the records on the left side of the report for TABLE A and records on the rght side of the report for TABLE B.

I am using the ".SQLQueryString" property for processing SQL statements in vb code view to produce an output in teh report at runtime.

Do u know how to do this.. ??

Any good techie help will be gr8tly appreciated.
Awaiting reply A.S.A.P.....

[shakti5385]

Read the crystal report tutorial at my signature.

[intellogo]

I was abt to give a BILLION THANKS!! for ur code bank resources that let me race up to code the CR 11 report. But specific to this post, ur code bank stuff does not state anything abt passing 2 sql statements ...

What should i do.. ??

Agar aap yahooo ke ID dete hai to main aapse abhi onliaaiinee baat kar saktaa hooonnn..Pleeaassee

[intellogo]

Hey everyone....the VBForumers...pls help me out in this post...its urgent
Ur help will be appreciated...

[Mark Gambo]

Take a look at these threads:

http://vbforums.com/showthread.php?t=435258

http://vbforums.com/showthread.php?t=278907

[intellogo]

someone pls solve this issue for me..How do i pass 2 sql statements for retrieving records on a report that is devided by a center line. The 2 sql statements that i want to use is for 2 seperate tables on either side of the report...


Anyone....assist me in this...