So having been through
1)the ringmoral of converting most of our reports to run from views so that the SQL Server does most of the hard work of calculations and record selection
2) The LOV "Max Rowset" Registry tweak
3) The HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports\ReportView "PromptingLOVBatchSize" Tweak to match decimal value to above
The prompts on my machine and almost every other now fire off fine.
However 2 Specific machines still see a trunkated set of records for 1 particular report we have found so far.
The Prompt is structured as follows
Product Group => Works Order Status => Works Order Number (Described by Item Code)
The 2nd level is missing 3 statuses.
If I Just set the dynamic prompt up to ask which status it works fine. The minute I try to add multiple levels to the cascade it truncates right away. I've checked my view and it seems fine, I've run the report on 7 other PC's and it works fine, it's just these two and I don't see why.
If I extract the view in Excell on these machines all the data is there, if I run SQL management studio and edit the view all the data appears.
If I browse data in CR2008 the statuses are all there.
I'm at my wits end with this one! It's probably the simplest report of all and it still won't work.
IP Logged
