Sweet! But it was your research and your ability to notice what the actual
problem was -- that's what gave me the clue!!
Karen
-----Original Message-----
From: 'Patti Jakusz' via RBASE-L <[email protected]>
To: [email protected] <[email protected]>
Sent: Mon, Feb 11, 2019 4:36 pm
Subject: Karen is a GENIUS!!!!! Re: [RBASE-L] - Problem with a summary report
Thank you so much. It was the zero setting. I had it off. Now it works!
Thank you everyone!!
Patti
From: 'Karen Tellef' via RBASE-L <[email protected]>
To: [email protected]
Sent: Monday, February 11, 2019 5:33 PM
Subject: Re: [RBASE-L] - Problem with a summary report
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
#yiv4115771166 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2
4;}#yiv4115771166 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv4115771166
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv4115771166
p.yiv4115771166MsoNormal, #yiv4115771166 li.yiv4115771166MsoNormal,
#yiv4115771166 div.yiv4115771166MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv4115771166
a:link, #yiv4115771166 span.yiv4115771166MsoHyperlink
{color:blue;text-decoration:underline;}#yiv4115771166 a:visited, #yiv4115771166
span.yiv4115771166MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv4115771166
p.yiv4115771166MsoListParagraph, #yiv4115771166
li.yiv4115771166MsoListParagraph, #yiv4115771166
div.yiv4115771166MsoListParagraph
{margin-top:0cm;margin-right:0cm;margin-bottom:0cm;margin-left:36.0pt;margin-bottom:.0001pt;font-size:11.0pt;font-family:sans-serif;}#yiv4115771166
p.yiv4115771166msonormal0, #yiv4115771166 li.yiv4115771166msonormal0,
#yiv4115771166 div.yiv4115771166msonormal0
{margin-right:0cm;margin-left:0cm;font-size:11.0pt;font-family:sans-serif;}#yiv4115771166
span.yiv4115771166EmailStyle19
{font-family:sans-serif;color:#1F497D;font-weight:normal;font-style:normal;text-decoration:none
none;}#yiv4115771166 .yiv4115771166MsoChpDefault
{font-size:10.0pt;}#yiv4115771166 filtered {margin:72.0pt 72.0pt 72.0pt
72.0pt;}#yiv4115771166 div.yiv4115771166WordSection1 {}#yiv4115771166 filtered
{}#yiv4115771166 filtered {}#yiv4115771166 filtered {}#yiv4115771166 filtered
{}#yiv4115771166 filtered {}#yiv4115771166 filtered {}#yiv4115771166 filtered
{}#yiv4115771166 filtered {}#yiv4115771166 filtered {}#yiv4115771166 filtered
{}#yiv4115771166 ol {margin-bottom:0cm;}#yiv4115771166 ul
{margin-bottom:0cm;}#yiv4115771166 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.
--
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.
