SSRS Mircosoft Reporting: Conditional grouping

Question

Is it possible to make a group and sort conditional? If so, is it possible to somehow do this based on the value of a textbox item?

I thought I could just set the Expression of the group and sort to something like =IIF(ReportItems!TheTextBox.Value = 0, 0, Fields!FieldName.Value), which would be perfect, but it doesn't allow me to use ReportItems in group or sort expressions =(

Really don't want to make two reports whenever I need that feature... hope someone can shed some light on this!

Using:

• Microsoft reporting services
• Report viewer with local processing

Answer 1

edit

It is a sub-report, so I can't use report parameters.

you can. see How to: Add a Subreport and Parameters (Reporting Services)
/edit

Try to check this report parameter collection in grouping expression. Something like:

=IIF(Parameters!<ParameterName>.Count = 0, 0, Fields!FieldName.Value)

See Using Parameters Collection References in Expressions (Reporting Services)