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 & easiest thing is to pass 2 different SQL statments in vb code on the form_load event. 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, when the report is displayed.

I am using the ".SQLQueryString" property for processing SQL statements in vb code view to produce an output in the report at runtime...which has worked perfectly for my other reports.

OBJECT SUMMARY: Displaying records from two seperate tables on either side of the report.
Do any of u guys know how to do this.. ??

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

Edited by intellogo - 07 Apr 2007 at 4:44am

Gooday and Thanks a lot to get me rocketted at the
correct direction in this strange issue.
Are u trying to say that I would need to make use of the conecpt of a database "view" (which is a virtual sort of third table in buffer), to pull this thing correctly ???

I am using Visual Basic 6.0 and Microsoft ACCESS 2000. So, according to ur reply, I will have to query records from table A and table B (which are unrelated) and write them / transfer them to a thrid table called C. All this I will be doing through VB6 code.And then simply query all TABLE C's records with use of the ".SQLQyeryString" property which I was using normally to show records finally onto the crystal report.

Is the above conclusion correct as per what you are trying to explain to me ???

Awaiting your experienced reply....

Hi..buddy Bischof,

Firstly, i gr8tly appreciate ur interest and consistency in helping me...THANX
I have changed it and will need ur asistance more now..
I have deleted that old report.

I made a new blank report and placed 2 sub-reports on the blank report.Each of these 2 sub-reports display records of the 2 unrelated tables..as I wanted it to work...but this is in crystal report 11 product only.

Now how do I do it in VB6 code ?
For my other reports that were being generated, I had a VB Form having a "View Report" button which would at runtime generate the reports.

But now I am tackling the issue of sub-reports and have no knowledge of the vb6 code that is required with sub-reports.
Normally, for the other reports, I was using the ".SQLQueryString" prop to feed-in the SQL statement in VB6 code. But how do I do it now. I mean to say there's a new way I guess to work it out with sub-reports..Can someone throw light on this..

Awaiting the crystally replies...

Hi Brian,
I don't know the Crystal or Basic syntax needed to code the CR 11 reports within the CR 11 product, so I do it in VB6.I am now only stuck in this subreport thing.

QUESTION 1:
===========
I want to know what is the different code that I'll have to write for these new subreports. ???

QUESTION 2:
===========
In which of the sections of the main report (Report Header, Repor Footer, Page Header, Page Footer, Details)do I place the sub-report in, so that it will display properly at runtime in my vb6 s/w via the CrystalActiveXReportViewer control ???

I have currently placed it in the "Report Header" section and I can see the preview of a detailed subreport in CR 11 product/IDE ..but in VB6, its smiply 2 blank boxes (at runtime)....

Please help me out...

Edited by intellogo - 07 Apr 2007 at 1:00am