Reports How To Show Detail and Summary -- Dynamic reporting

[Laura Grimes]

My client has a requirement where she wants to select filters based upon dynamic criteria.  She wants to have the detail records displayed that meet the criteria. (regular report function)  Then she wants to see a count distinct of the number of applications/households somewhere on the report.

For example, filter = men, over 65, gift ind = 'Y'   results in 520 detail rows but the report total is 500 distinct applications.

Another filter may be kids, who ask for a bike, who qualify for sponsorship.

How can I get the total based upon the selected filter?

[ParaSQL Support]

Try a roll up report. Create the report as normal (with 1 or more group by columns and 1 or more aggregate columns) then designate it as a Roll Up style report (option next to Group By). This will provide totals, sub totals, grand totals, counts or whatever your aggregate columns are for each group, sub group and the entire filter set.