NEED HELP UNDERSTANDING LIMITATIONS OF DATABASE EXPERT AND SUBREPORTS 1

[TNN]

I am using the RDC in VB6.0. My datasource is an Access 2000 database using oledbADO as my connection.

As I understand it all the tables and/or command objects in the Databse expert must be linked, and also, in using the RDC I cannot have a subreport of a subreport.

This, as I perceive it, causes limitations in report design.
I am designing a report that uses data from some tables that are not linked to any other table and have no common fields. As an example I have a single table that contains data that needs to be displayed in as many as 3 different areas of the report, different data from the same table. Consequently I will have to create 3 different subreports and place them in the specified areas of the report.

Do multiple subreports affect performance???

Redesign of the database to link more tables is just not a feasible consideration.

Are my assumptions correct or do I have some alternatives??

Any input is greatly appreciated. Thank You.
TNN, Tom






TOM

http://WWW.TNPAYROLL@AOL.COM

 

[checkai]

Multiple sub-reports will affect performance. But it all depends on what's in the sub report and if they're on-demand or visible. I have a report with 2 or 3 sub-reports and haven't had any poor performance shown. However my subs are on-demand.

hope this helps a little.

 

[TNN]

checkai,

I haven't judged performance with and without the subreports as yet. I don't have the option of making them on demand.

My subreports will be visible and NOT on demand. Do the limitations I mention above sound like I'm understanding correctly as regards the Database Expert and having to use multiple subreports because of the limitations???

Thank You for your input.

TNN, Tom


TOM

http://WWW.TNPAYROLL@AOL.COM