Do you run with ZERO ON or ZERO OFF? Not sure if that would affect this, but if you're running OFF, try changing your setting to ON (I always have it set ON)
Karen -----Original Message----- From: 'Patti Jakusz' via RBASE-L <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Feb 11, 2019 4:31 pm Subject: Re: [RBASE-L] - Problem with a summary report The problem seems to be that when it is supposed to reset the variables on a break change, it sets them to null instead. I tried printing out the detail lines and plotted different variables on the detail lines. The variables all disappear after the first break footer. When I show variables after the report prints, they are defined but null. I thought resetting them on a break would reset them to zero. Patti From: 'Patti Jakusz' via RBASE-L <[email protected]> To: "[email protected]" <[email protected]> Sent: Monday, February 11, 2019 4:42 PM Subject: Re: [RBASE-L] - Problem with a summary report Nope, it made it worse. Now it didn't even calculate the first vsubtot correctly. I'm attaching the resulting report. When I set it back to calculating on the detail line, the results were the same as the original report I attached before.Patti From: Stephen Markson <[email protected]> To: "'[email protected]'" <[email protected]> Sent: Monday, February 11, 2019 4:20 PM Subject: RE: [RBASE-L] - Problem with a summary report #yiv5234876117 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} #yiv5234876117 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;} #yiv5234876117 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #yiv5234876117 p.yiv5234876117MsoNormal, #yiv5234876117 li.yiv5234876117MsoNormal, #yiv5234876117 div.yiv5234876117MsoNormal {margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv5234876117 a:link, #yiv5234876117 span.yiv5234876117MsoHyperlink {color:blue;text-decoration:underline;} #yiv5234876117 a:visited, #yiv5234876117 span.yiv5234876117MsoHyperlinkFollowed {color:purple;text-decoration:underline;} #yiv5234876117 p.yiv5234876117MsoListParagraph, #yiv5234876117 li.yiv5234876117MsoListParagraph, #yiv5234876117 div.yiv5234876117MsoListParagraph {margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;} #yiv5234876117 p.yiv5234876117msonormal0, #yiv5234876117 li.yiv5234876117msonormal0, #yiv5234876117 div.yiv5234876117msonormal0 {margin-right:0cm;margin-left:0cm;font-size:11.0pt;font-family:sans-serif;} #yiv5234876117 span.yiv5234876117EmailStyle19 {font-family:sans-serif;color:#1F497D;font-weight:normal;font-style:normal;text-decoration:none none;} #yiv5234876117 .yiv5234876117MsoChpDefault {font-size:10.0pt;} #yiv5234876117 filtered {margin:72.0pt 72.0pt 72.0pt 72.0pt;} #yiv5234876117 div.yiv5234876117WordSection1 {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 filtered {} #yiv5234876117 ol {margin-bottom:0cm;} #yiv5234876117 ul {margin-bottom:0cm;} #yiv5234876117 Hello Patti, I believe your variable setup is incorrect. I’m not sure if “sum of” is supported any longer. I have been using the following successfully for a long time: - Make sure vSubTot is initialized to zero prior to running the report. - vSubTot=(.vSubTot+1) - calculated onDetail, reset on F0 (break footer 0) - vPercentage=what you had - calculated onF0 - You don’t needvcount Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: 'Patti Jakusz' via RBASE-L <[email protected]> Sent: February 11, 2019 12:45 PM To: [email protected] <[email protected]>; RBASE-L <[email protected]>; RBASE-L <[email protected]> Subject: [RBASE-L] - Problem with a summary report Hello, Can someone help me? I can't imagine what my problem is. I have many reports that do this sort of thing and I have examined them and can't see what I must be missing. This is a report that prints no detail, but just a summary line on the break footer. I calculate the grand total (vtotal) ahead of time in the command file, so I can print a percentage along with the subtotal on each break footer. But the subtotal only shows up on the first break footer, and not the subsequent ones. I took a screen shot of the variable definitions, the report layout, the report break definition and stuck them all on one page of a word doc. I took a screen shot of the report results. In my command file: set v vcount INT = 0 set v vsubtot INT = 0 print DemogActiv order by AgeCatM Thank you for your time. Patti -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
