Try checking the “look ahead”. Right click on it and check it then give it a try.
[cid:image001.png@01D3F282.72476C30] Dan Goldberg From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Cathy Grimes Sent: Wednesday, May 23, 2018 10:36 AM To: rbase-l@googlegroups.com Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only? Thanks so much for taking the time to respond, Karen. I got through your steps to the end, so very clear explanation. Unfortunately, all I get is “1” as a response no matter what where clauses I use in testing the report. It sounds like this is the right method, so I don’t know why it’s not working. Cathy From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Wednesday, May 23, 2018 6:59 AM To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Subject: Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only? Since you upgraded from an earlier version, I'm guessing you might have an "old style" variable. You should instead locate a "DB Calc". Find that control in the database controls list and locate it on the report (delete the location for your variable). Above it, you'll see a "data field" area where you select the column you are counting. Then right-click on the control, select Calculations, and select "count". Now it will operate on whatever where clause you print the report for. Hope that made sense! Karen -----Original Message----- From: Cathy Grimes <cfgri...@verizon.net<mailto:cfgri...@verizon.net>> To: rbase-l <rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>> Sent: Wed, May 23, 2018 8:43 am Subject: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only? I still haven’t been able to fix some of the R:Base upgrade differences that negated a few of my previous entries/variables that worked before. It’s been decades since I did any database/form/report/table designing with my database except add rows using my previous forms and print existing reports. I have R:Base Extreme 9 (C:\RBTI\RBG95_32\RBG95_32.exe). I have one report that I frequently use and just change the ‘where’ clauses to suit each report. I cannot find a way in this R:Base for the report to simply count the total of each main entry (i.e., ‘title’) SPECIFIC to EACH REPORT’s ‘where’ clause that I give the report when I ask it to print. The only way I’ve managed to get the count is to go to DESIGN, variables and CHANGE the variable to the same ‘where’ clause as the particular report I’m printing. But it would be so much easier if I could just add a variable where R:Base can just use the where clause I give it each time I print the report. (Hope that makes sense). If anyone knows how I could do this, I would really appreciate it. Thank you. Cathy -- 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+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@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+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@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+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
