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
#yiv5380080720 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2
4;}#yiv5380080720 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv5380080720
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv5380080720
p.yiv5380080720MsoNormal, #yiv5380080720 li.yiv5380080720MsoNormal,
#yiv5380080720 div.yiv5380080720MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv5380080720
a:link, #yiv5380080720 span.yiv5380080720MsoHyperlink
{color:blue;text-decoration:underline;}#yiv5380080720 a:visited, #yiv5380080720
span.yiv5380080720MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv5380080720
p.yiv5380080720MsoListParagraph, #yiv5380080720
li.yiv5380080720MsoListParagraph, #yiv5380080720
div.yiv5380080720MsoListParagraph
{margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv5380080720
p.yiv5380080720msonormal0, #yiv5380080720 li.yiv5380080720msonormal0,
#yiv5380080720 div.yiv5380080720msonormal0
{margin-right:0cm;margin-left:0cm;font-size:11.0pt;font-family:sans-serif;}#yiv5380080720
span.yiv5380080720EmailStyle19
{font-family:sans-serif;color:#1F497D;font-weight:normal;font-style:normal;text-decoration:none
none;}#yiv5380080720 .yiv5380080720MsoChpDefault
{font-size:10.0pt;}#yiv5380080720 filtered {margin:72.0pt 72.0pt 72.0pt
72.0pt;}#yiv5380080720 div.yiv5380080720WordSection1 {}#yiv5380080720 filtered
{}#yiv5380080720 filtered {}#yiv5380080720 filtered {}#yiv5380080720 filtered
{}#yiv5380080720 filtered {}#yiv5380080720 filtered {}#yiv5380080720 filtered
{}#yiv5380080720 filtered {}#yiv5380080720 filtered {}#yiv5380080720 filtered
{}#yiv5380080720 ol {margin-bottom:0cm;}#yiv5380080720 ul
{margin-bottom:0cm;}#yiv5380080720 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.
