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.....