R:Base has been really good about supporting Legacy commands when new ones were introduced. I remember going over code when the DECLARE CURSOR replaced the old construct and updating lots of code, In fact, I have now done away with a lot of old code that used cursors and switched to using SQL commands to do it with one line of code where it took many before. I have mostly done away with the “SUM OF…” construct and replaced it with DB Calc, like you did. I am sure I have some old reports that still have the old construct and whenever I run into one I try to immediately replace it with the newer commands. Javier, Javier Valencia, PE O: 913-829-0888 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Markson Sent: Wednesday, February 13, 2019 10:48 AM To: '[email protected]' Subject: RE: [RBASE-L] - Problem with a summary report Hi, I wrote I’m not sure if “sum of” is supported any longer because if I search for “sum of” in RBase help, nothing comes up about using sum of in reports. I too have tons of old reports with sum of, but I’m not using that construct in new reports. If I just need the sum (count, min, max or average), I use a DB Calc object. If I need to use the value from the calculation, I create my own sum, count, min, max or average variables. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] <[email protected]> On Behalf Of Jim Belisle Sent: February 11, 2019 4:24 PM To: [email protected] Subject: RE: [RBASE-L] - Problem with a summary report 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]. 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.
