Sami - My summary report is an exact copy of the detail. In the explorer menu, I selected my detail report and copied it to a new "summary" name. I then went into the report designer and simply "un-clicked" visible in all the fields in the detail section. The detail section properties are set to dynamic height. This in effect, "hides" the detail lines and condenses the report into a summary, only printing the header and footer sections
I then have one print statement in my .rba application that passes three variables. One is the report name, (ProdDetail or ProdSummary) one is a date value and the third is option value. (Screen or Printer) print &VReportName where InvoiceDate > .Vdate1 order by ITDept, Shift, ItemNumber Option .Voption As you can see, this code will print the detail and the summary report with the exact same conditions. The reports look exactly like I want them too, except that the department and shift totals (printed on the F1 and F0 sections) do not match on (3) of the (15) departments. I am now becoming convinced that the page break problem on summed variables that was found several months ago has sneaked back in. I have now also noticed that when viewed to screen the first department total is correct, but if you print the report from the screen view icon, the printed value for the first department total now has the second page department total added to it. Printing the same report direct to the printer does not do this. Attending the advanced class tomorrow, will bring the database with me, so I hope to have some big time help! 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 -----Original Message----- From: Sami Aaron [SMTP:[EMAIL PROTECTED] Sent: Thursday, February 19, 2004 10:13 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report problem Bob - Also check the fields listed in your break levels and compare them to the list of columns after the ORDER BY clause. If they are different, then that could be causing it to sort differently than the break levels - and might have some affect on the results. If the columns in the break grouping are the same as in the order by grouping, omit the order by when you print the reports - it's just redundant and may slow down printing. The breakpoints force the sort order. If you need to sort by a DESC sequence or by additional columns at the detail level on the detail report, you can either add those columns in as additional break levels (without placing those sections on the report) or you can add them to an ORDER BY clause - as long as your ORDER BY clause begins with the same breakpoint columns first listed in the same relative order as in the breakpoint list. Sami ----------------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 mailto:[EMAIL PROTECTED] 913-915-1971 ----- Original Message ----- From: "Thompson Technology Consultants" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 19, 2004 8:45 AM 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 > > > >
