Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    May 2010
    Location
    Glasgow, Scotland
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hey all,
    Looking for a bit of help with getting multiple counts in a single report, i.e. just now if I run reports for say 4 regimes with 5 areas in each I would have to run 20 diffrent reports but what I'm looking to have is 1 report that has a count for each regime/area combination on it instead. Is there anyway to have thison reports or am I going to have to stick with running a bunch of diffrent ones?

    Cheers.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Without more details, it is difficult to judge the complexity of trying to create a single report with counts as you describe. One thing you might look at is using some sort of Crosstab (or Pivot) query to produce the counts you are after. Another trick that might help is to create subreports that give you the counts for each combination. If you can provide a sample of the sort of report you are currently producing, we may be able to give you more concrete suggestions.
    Wendell

  3. #3
    Lounger
    Join Date
    May 2010
    Location
    Glasgow, Scotland
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for the quick reply, I've attached a sample report that will hopefully give you an idea of what I'm looking for, pretty much in the report the records are grouped by regime and then customer so I'm looking to get a count of the records in each group on the same report. For example if Region 1 and customer 1 had 15 records and region 1 customer 2 had 30 records I would like the report to have both of those counts on it if that makes any sense?

    Thanks again.
    Attached Files Attached Files

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    You can have multiple counts by adding Group footers to each of the Groupings.
    At the moment the report is grouped by Project and Customer, and each of them has a Header, but no Footer.
    If you repeat the Count(*) within a Group Footer it will count within that Group.
    Regards
    John



  5. #5
    Lounger
    Join Date
    May 2010
    Location
    Glasgow, Scotland
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks, that's exactly what I was after, your a Star!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •