IT WORKED! Such a simple addition to the DBCalc Karen suggested enabled me to, FINALLY, get all the counts I wanted on my reports – THANK YOU SO MUCH!!
Cathy From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, May 23, 2018 10:40 AM To: [email protected] Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only? Try checking the “look ahead”. Right click on it and check it then give it a try. Dan Goldberg From: [email protected] <mailto:[email protected]> <[email protected] <mailto:[email protected]> > On Behalf Of Cathy Grimes Sent: Wednesday, May 23, 2018 10:36 AM To: [email protected] <mailto:[email protected]> 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:[email protected]] Sent: Wednesday, May 23, 2018 6:59 AM To: [email protected] <mailto:[email protected]> 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 <[email protected] <mailto:[email protected]> > To: rbase-l <[email protected] <mailto:[email protected]> > 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> 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 <mailto:[email protected]> [email protected]. For more options, visit <https://groups.google.com/d/optout> 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] <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] <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] <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.
