Stephen. I still have reports where I use SUM OF and I am using the RBASEXE. However I will look into your code to see if that is a better way.
James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Markson Sent: Monday, February 11, 2019 3:20 PM To: '[email protected]' Subject: RE: [RBASE-L] - Problem with a summary report 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: 1. Make sure vSubTot is initialized to zero prior to running the report. 2. vSubTot=(.vSubTot+1) - calculated on Detail, reset on F0 (break footer 0) 3. vPercentage=what you had - calculated on F0 4. You don’t need vcount 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 to [email protected]<mailto:[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.
