Reading parameters lists from a text file

[Former Member]

Hi All,

Using CR XI R2 with VB6 and external .rpt files - - - - -

In a VB6 app I use VB to loop through my tables to create dynamic parameter lists (CR XI is limited to the number of parameters it can create from the table). This works well but each time the user refreshes the report the same code is run to re-create the parameter list which is redundant and slows down the report(s).

Is it possible to manually create a series of text files - say each morning - and then read the parameter lists from the text file(s) at runtime instead of doing it on the fly each time?

Thanks in advance!

Peter Tyler

Geneva - Switzerland

[former_member183750 · Accepted solution]

I find this sentence confusing:

Is it possible to manually create a series of text files - say each morning - and then read the parameter lists from the text file(s) at runtime instead of doing it on the fly each time?

Typically, runtime means on the fly - I think...

So, I'm not sure if you are trying to read a saved data report and filter that saved data so that you do not have to hit the database(?).

Creating a text file is beyond the support of this forum, though that should be a trivial exercise. Reading a text file and passing the results to a parameter is the same thing you are doing already, so I'm not sure where the hang up would be here(?)

Or - rather than creating a text file, why not create a temp table and query it as you do when you loop through the tables to create dynamic parameter lists(?).

I'm pretty lost here...

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]