By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,317 Members | 1,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,317 IT Pros & Developers. It's quick & easy.

Counts on Summary page

P: 77
Hi,

I have a report for Judges and their cases Numbers, grouped by Judge Name,the detail starts on a new page every time a judge changes. On the Judge footer I am displaying Count of Total no of cases for that judge and Count of Total no of Unique Cases for that Judge.I have a text box for each Count and using DCount display the counts.
Now the same counts for every judge needs to be displayed on the Report Footer as a summary page like,

No of Cases for Judge1 -
No of Unique cases for Judge1 -

No of Cases for Judge2 -
No of Unique cases for Judge2 -

No of Cases for Judge3 -
No of Unique cases for Judge3 -

No of Cases for Judge4 -
No of Unique cases for Judge4 -


Please help,

Thanks
Feb 14 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hi,

I have a report for Judges and their cases Numbers, grouped by Judge Name,the detail starts on a new page every time a judge changes. On the Judge footer I am displaying Count of Total no of cases for that judge and Count of Total no of Unique Cases for that Judge.I have a text box for each Count and using DCount display the counts.
Now the same counts for every judge needs to be displayed on the Report Footer as a summary page like,

No of Cases for Judge1 -
No of Unique cases for Judge1 -

No of Cases for Judge2 -
No of Unique cases for Judge2 -

No of Cases for Judge3 -
No of Unique cases for Judge3 -

No of Cases for Judge4 -
No of Unique cases for Judge4 -


Please help,

Thanks
Hi. I think this would be a bit difficult to achieve by trying to code it in the report itself. Although you could use a global array as a form of list, add values within the report sections, then list the array contents at the end of the report this or similar approaches get very messy - and error-prone.

I would use a sub-report instead, taking the results from a linked summary query which could do the counting for you.

Use the data from the base query that feeds the main report to feed a summarising totals query that counts the unique cases and the overall case load, then add a sub-report to the end of your report to display the counts you require from this linked query. You can then ensure that the counts are correct much more easily than you could hard-coding it!

Regards

Stewart
Feb 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.