SSRS 2008 Parameter

nulad
nulad used Ask the Experts™
on
Is there a way in SSRS 2008 to have a parameter that looks at a report's group total or subtotal?  I have a report with groups, and would like for a parameter to look for groups that have a total of => ###.  Is there a way to do this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
the best way would be to edit your sql to include the subtotals in your results and filter based on that.

You can't filter based on the results of a subtotal.  the report is generated first then the totals are place in later.

Commented:
the best way would be to edit your sql to include the subtotals in your results and filter based on that.

You can't filter based on the results of a subtotal.  the report is generated first then the totals are place in later.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial