Report with 87subreport links

[PanosK]

Hi people

I am using Crystal 5, VB6, Access2K.

I put together a report with 87 subreports.
I created the subreport links.
I set location and verified database for each one of the subreports.
Data don't appear for one particular subreport though the links & the parameter fields are there.
Also for some subreports duplicate data appear.
Also when I try to fix links on one subreport then there are new parameters with ??001 added to the end of the parameter name on the first subreport.
Can you help?
Do you know of a best practice in this case?

thanks
Panos

 

[synapsevampire]

Wow... That's pushing Crystal.

First thing to do is make a back up copy of this report often, it will likely become corrupted.

Version 5 is soooooo old that there really aren't any best practices, my suggestion would be to upgrade.

I can't even recall if 5 has this functionality, but select Database->Show SQL Query to see what is being passed to the database if you're using an ODBC connection.

Lots of luck with the project, and consider posting the intent of the report overall as I'm guessing that there's a way to avoid 87 subreports...

-k