Bob: I use the same approach when designing detail/summary reports; it is a very efficient method to creating reports. When you say you make the detail invisible, by this you mean you delete the entire detail section or just the variables? Make sure that you have not changed the breaks. Also, make sure that you run the reports from a command file and not from the designer. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thompson Technology Consultants Sent: Thursday, February 19, 2004 8:45 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Report problem Would someone please verify my logic in regards to a report problem I have created a detail report and a summary report. The detail report lists individual transactions by department and grouped by type. The summary report shows only the department totals. To create the summary report, I simply took the detail report and made the detail lines invisible. When running the report it looks fine, just the way I want it to. However, using the exact same where / order by clause, the detail report will occasionally give a different department total than the summary report. For example, the reports show department totals for 15 departments. On the detail report, 3 departments show a different total than on the summary report. Again the only difference between the two reports is making the detail lines invisible. Has any one experienced this and is it not a valid method to produce a summary report by making detail lines invisible? Thank you, -Bob Thompson Technology Consultants 276 Chippewa LaPorte, IN 46350 219-324-2605 (Phone & Fax) 219-363-7441 (Cell) http://ttc.inc.home.comcast.net
