I had the DB Calc placed in the Report Header (so I can see the total for each report on the first page of the printout). I did try copying and placing the DB Calc also on the Report Footer, but I couldn’t find any footer at all, so I must have done something wrong.
BUT, YOUR first suggestion how to use DBCalc, ALONG with DAN’s suggestion to ADD ‘Look Forward’ WORKS!! I now have counts for each title on the Report Header, along with another entry showing the counts for the entire table. THANK YOU BOTH SO MUCH! Cathy From: karentellef via RBASE-L [mailto:[email protected]] Sent: Wednesday, May 23, 2018 11:01 AM To: [email protected] Subject: Re: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only? Where did you place the DB Calc? Put it in the Report Footer to be the most effective, or in the Break Footer if the calculation resets on a break level Karen -----Original Message----- From: Cathy Grimes <[email protected] <mailto:[email protected]> > To: rbase-l <[email protected] <mailto:[email protected]> > Sent: Wed, May 23, 2018 12:36 pm 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] <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 --- 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] <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] <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.
