Jim, In 6.5 you're going to have to base the report on a temporary table. Load the temp table then delete rows that meet your criteria of assy. Pieces > needed.
Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. [EMAIL PROTECTED] [EMAIL PROTECTED] (203) 643-8022 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Belisle Sent: Thursday, January 17, 2008 4:57 PM To: RBASE-L Mailing List Subject: [RBASE-L] - REPORT I have a report that shows assemblies in the header and the parts associated with the assemblies in the detail section. I calculate a sum based on the assy. inventory on hand and the assy. pieces needed for the orders on hand. What I want to do is make it so the detail section does not show if the assy. inventory amount is greater than the assy. pieces needed to fill the orders. This is a calculated figure in the header section and I am not sure how to go about this. Any suggestions? Jim I still use 6.5 at this time since I have not converted my reports over to 7.5 or higher.
