Ha! I have something worse than Set Pointer to complain about. I inherited a bunch of old DOS programs where the programmer took advantage of the days when "set var" wasn't even required! Yeah, needless to say that code does NOT work anymore. It actually took me a while to figure out what something like this even was and there could have been dozens or a hundred of them in one program: v = 100x = "hello"
Karen -----Original Message----- From: Michael Byerley <[email protected]> To: RBASE-L <[email protected]> Sent: Wed, Feb 13, 2019 3:30 pm Subject: Re: [RBASE-L] - Problem with a summary report SET POINTER anyone? On Wednesday, February 13, 2019 at 1:34:06 PM UTC-5, javier.valencia wrote: 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, PEO: 913-829-0888C: 913-915-3137 From: [email protected] [mailto:rba...@googlegroups. com] 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 MarksonThe Pharmacy Examining Board of Canada416.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 From: [email protected] [mailto:...@googlegroups. com] 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 F04. You don’t need vcount Regards, Stephen MarksonThe Pharmacy Examining Board of Canada416.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 <rbase-l...@googlegroups. com> 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 = 0set v vsubtot INT = 0print 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 rbase-l+u...@ googlegroups.com. 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 rbase-l+u...@ googlegroups.com. 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 rbase-l+u...@ googlegroups.com. 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.
