Im working with an app developed in VB6 that produces over 160 different crystal reports.
The app is coded to create a recordset in the app first, pass the results to a holding database, then the crystal report is run from that database.
This seems a very slow an sluggish way to produce reports.
The data is quite extensive, with users able to select from a list of 100's of different codes, and many options they want to report on.
I'm leaning towards passing the record selection formula to the report, however this string would be massive for some reports where a user has selected for example 100 odd codes, along with 250 other codes and 15 different options.
So given all this, Im wondering what others may suggest ?