none
Summary Table in a Report Footer. RRS feed

  • Question

  • Is it possible to insert a summary table in a report footer section?

    I have a report with a detail section showing the results of a cross tab query.

    I would then like to have a summary of that detail sections rows appear in the Report Footer section.

    for example:

    Header section:

    Number               Name                 Status             Team 1             Team 2             Team 3             Team 4

    Detail Section (Cross Tab Query results)

    1                          Bob                   Present               3                       2                      1                     3        

    2                          Nath                  Absent                1                       3                      2                     2

    3                          Dave                 Present               3                       2                      3                     2

    In the Report Footer section I would like:

     Summary

    Present       2

    Absent        1


    Nath

    Wednesday, March 29, 2017 2:12 PM

Answers

  • Try using unbound textboxes in footer with these as source --

      =Sum(IIF([Status] = "Present", 1, 0))

      =Sum(IIF([Status] = "Absent", 1, 0))


    Build a little, test a little

    • Marked as answer by NaPazz Monday, October 30, 2017 1:04 PM
    Wednesday, March 29, 2017 5:23 PM

All replies

  • Hmm, a quick one to try is to create a subreport based on a query summarizing the crosstab query.

    Just a thought...

    Wednesday, March 29, 2017 2:33 PM
  • Try using unbound textboxes in footer with these as source --

      =Sum(IIF([Status] = "Present", 1, 0))

      =Sum(IIF([Status] = "Absent", 1, 0))


    Build a little, test a little

    • Marked as answer by NaPazz Monday, October 30, 2017 1:04 PM
    Wednesday, March 29, 2017 5:23 PM