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 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
