Default pick list - 50000 records 2

[AMS100]

I'm trying to create a set standard of reports that a user will add their own search criteria to i.e. at run time inserting Report Name, Start date, End date etc... The problem occurs when one of the tables can have 50000+ rows and for Crystal Reports to display all the available values takes 40 minutes, then to add the entire list to the Default Values box (Using the ' >> ') button takes another 40 minutes! This process has to be repeated every time a new value is added to the table. I'm using Version 8 and an Oracle database - Does anyone know of a better way of achieving this?
Thanks.

 

[IlseH]

Can't you just export the values from your database to a textfile and then import this file whith the button "Import pick list"?

 

[kenhamady]

I am surprised that it is moving all of these, since I only thought that CR would only read the first 500 values from the table. At least my CR 8.5 will only take 500.

But, you can always manually type in the new value(s), and add them individually to the list using the single ">".

But, with that many values you probably should bypass the whole pick list and create your own live Pick List in the front end app. You can then pass the selected value (s) to the report. No more updating required in any of the reports. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[AMS100]

Thanks for the advice, I was kinda hoping to avoid any real programming but looks like there’s no way round this one. By the way I managed to get CR to select more than 500 values from the table by fiddling in the Registry :-
Hkey_Current_user\Software\Seagate Software\Crystal Reports\database server - change MaxNBrowseValues to any value (in this case 50000) and BrowseTimeout to 0 (indefinite)

 

[kenhamady]

Well, you got me there. I didn't realize that there was a registry setting that controlled those. I wonder if it can also be changed via the INI file? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kenhamady]

Thanks. It has been in the INI file for who knows how long, and I missed it. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[kenhamady]

Of course, now I have to test which configurations and versions of CR respond to the INI vs. the registry. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/