Counts on Summary page

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • AccessHunter
    New Member
    • Nov 2007
    • 77
    #1

    Counts on Summary page

    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
    Tags: None
    • Stewart Ross
      Recognized Expert Moderator Specialist
      • Feb 2008
      • 2545
      #2
      Originally posted by AccessHunter
      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

        Comment

        Previous template Next
        Working...