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
#yiv8846594907 #yiv8846594907 -- _filtered #yiv8846594907
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv8846594907
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8846594907
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv8846594907
#yiv8846594907 p.yiv8846594907MsoNormal, #yiv8846594907
li.yiv8846594907MsoNormal, #yiv8846594907 div.yiv8846594907MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv8846594907
a:link, #yiv8846594907 span.yiv8846594907MsoHyperlink
{color:blue;text-decoration:underline;}#yiv8846594907 a:visited, #yiv8846594907
span.yiv8846594907MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv8846594907
p.yiv8846594907MsoListParagraph, #yiv8846594907
li.yiv8846594907MsoListParagraph, #yiv8846594907
div.yiv8846594907MsoListParagraph
{margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv8846594907
p.yiv8846594907msonormal0, #yiv8846594907 li.yiv8846594907msonormal0,
#yiv8846594907 div.yiv8846594907msonormal0
{margin-right:0cm;margin-left:0cm;font-size:11.0pt;font-family:sans-serif;}#yiv8846594907
span.yiv8846594907EmailStyle19
{font-family:sans-serif;color:#1F497D;font-weight:normal;font-style:normal;text-decoration:none
none;}#yiv8846594907 .yiv8846594907MsoChpDefault {font-size:10.0pt;} _filtered
#yiv8846594907 {margin:72.0pt 72.0pt 72.0pt 72.0pt;}#yiv8846594907
div.yiv8846594907WordSection1 {}#yiv8846594907 _filtered #yiv8846594907 {}
_filtered #yiv8846594907 {} _filtered #yiv8846594907 {} _filtered
#yiv8846594907 {} _filtered #yiv8846594907 {} _filtered #yiv8846594907 {}
_filtered #yiv8846594907 {} _filtered #yiv8846594907 {} _filtered
#yiv8846594907 {} _filtered #yiv8846594907 {}#yiv8846594907 ol
{margin-bottom:0cm;}#yiv8846594907 ul {margin-bottom:0cm;}#yiv8846594907 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.
