Parameter Limitations

[Khanson82]

I think I have a good one..
I have a report with 150,000 total records plus...It contains 281 unique CSR names..
When I make a parameter for the CSR, it only chooses about 50 CSR's out of the 281 top choose from. Keep in mind its searching through the 150K records.
If I change the report to only pull distinct csrs, it pulls 281 csr names. If I then do a parameter on that, it lets you choose from the whole list of 281 csr's..

Does Crystal have some sort of limit on how many records it will look through and pull unique values?

The import .txt file won't work becauase it won't update automatically from the database when new hires come on.
Already messed with the reg hack and that didnt work either.

Any Ideas?

 

[pgmr777]

There's a max record fetch setting somewhere in the registry under BO, I had to up mine to 100,000 to get some stuff like this to work.