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.

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!)