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, PE > > O: 913-829-0888 > > C: 913-915-3137 > > > > > > > > *From:* [email protected] <javascript:> [mailto: > [email protected] <javascript:>] *On Behalf Of *Stephen Markson > *Sent:* Wednesday, February 13, 2019 10:48 AM > *To:* '[email protected] <javascript:>' > *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] <javascript:> <[email protected] > <javascript:>> *On Behalf Of *Jim Belisle > *Sent:* February 11, 2019 4:24 PM > *To:* [email protected] <javascript:> > *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* > > [image: cid:[email protected]] > > > > *From:* [email protected] <javascript:> [mailto:[email protected] > <javascript:>] *On Behalf Of *Stephen Markson > *Sent:* Monday, February 11, 2019 3:20 PM > *To:* '[email protected] <javascript:>' > *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 *D*etail, 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] <javascript:>> > > *Sent:* February 11, 2019 12:45 PM > *To:* [email protected] <javascript:> <[email protected] > <javascript:>>; RBASE-L <[email protected] <javascript:>>; RBASE-L < > [email protected] <javascript:>> > *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] <javascript:>. > 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] <javascript:>. > 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] <javascript:>. > 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.
