Do you have the break set on a variable? If so, that has never worked. It doesn't evaluate variables before hand, just row by row, and for a break it has to know the values before the report loads.
To get around it, create a view that has the IMON as an actual column and set that as the break Karen -----Original Message----- From: Jim Belisle <j...@kaypark.com> To: rbase-l <rbase-l@googlegroups.com> Sent: Thu, May 24, 2018 8:02 am Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only? Since you are talking about DBcalcs, I have a question. I just created a report in which I use DBcalcs in two variable footers, one for the week and one for the month, and one column footer for each day. I am using the COUNT function to count orders each day (this is a column), week (using IWOY) and month (IMON). Each DBCalc is in a separate break footer for the day, week and month. For some reason the first order of the beginning of the week always resets then goes onto the rest of the orders in that week. See below and notice the first order of the first day of each week resets itself. What simple thing am I doing wrong? I will be leaving soon to be on the road two hours so will not be able to respond. James Belisle Making Information Systems People Friendly Since 1990 From: karentellef via RBASE-L [mailto:rbase-l@googlegroups.com] Sent: Thursday, May 24, 2018 7:27 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? Awesome! Glad we both gave you hints. DB Calcs are an awesome addition to reports since the 6.5 days. Whenever I do a conversion, I try to replace all the old report variables with DB Calcs. Especially nice is that they automatically reset themselves on a break level, no more remembering (or rather, forgetting) to specify a "reset" at break levels! Karen -----Original Message----- From: Cathy Grimes <cfgri...@verizon.net> To: rbase-l <rbase-l@googlegroups.com> Sent: Thu, May 24, 2018 3:10 am Subject: RE: [RBASE-L] - How Get Individual Reports to PRINT in Report Head the TOTAL # entries for THAT report only? 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: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com]On Behalf Of Dan Goldberg Sent: Wednesday, May 23, 2018 10:40 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? Try checking the “look ahead”. Right click on it and check it then give it a try. 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 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> To: rbase-l <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 torbase-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 torbase-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 torbase-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 torbase-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 torbase-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 torbase-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. -- 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.
