You made a mistake, double check your work.

Is it possible that you have more than 1000 items in your drop down lists? There is a registry entry to allow Crystal to load more.

Yes, there are more than 50K items in inventory distributed amongst a couple dozen or so segments (and growing). I will check the registry entry. Thanks

If that is the case and you tweak the registry, don't be surprised at how slow the report loads.

Dynamic parameters do not work well with a large number of records.

A couple of thoughts... (1) If you have your inventory segment values defined in IC Item Segment Codes you could add the ICSEGV to the Crystal and use it for the parameter / lookup. You do not need to link to the other tables & it will provide you with a shorter list for your lookup value. You would then add a Record Selection where the appropriate Item Segment = your parameter. (2) You may also need to set your table links from ICITEM to ICILOC & ICREORD to a Left Outer Join in case someone does not add the item to either of those tables. An inner join on either of them would require the Item to exisit in that table for it to appear on your report. (3) you could also use Sage Intelligence to create the report as it does not seem to have a problem creating lookups with large tables.

Thank you VickyB that is a suggestion worth pursuing.

Thanks to all for your replies.

I also found out that my report is doing exactly what it was designed to do - certain records were not showing up because they were being filtered according to the design criterion!!

I had forgotten my own design ! (and my documentation was below par!)