Bob, Do you need to reset any/all variables to zero between the two prints?
Regards, Alastair. ----- Original Message ----- From: "Thompson Technology Consultants" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Friday, February 20, 2004 12:02 AM Subject: [RBASE-L] - Re: Report problem > 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 > > > > > > > > > --- 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. ================================================
