SSRS 2008 Conditional Grouping

Question

This is my first post. I'll try and be as detailed as possible. 

I have an SSRS 2008 report that displays project transactions with amounts, dates, names, and account categories. I want the details group of the report to group conditionally on the account when account = "Burden". In other words. I want every detail row report except those rows that have "burden" as the account. I still want the Burden displayed, I just want all the transactions combined into one row and summed when they meet the conditions.

I went in to table1_details_group properties and put in two group expressions that I want.

=iif(fields!acct.Value = "BURDEN", Fields!name.Value, "")   -- This should group all the BURDEN fields that have the same name

=iif(fields!acct.Value = "BURDEN", Fields!trans_date.Value, "") -- This should group all BURDEN fields that have the same date

When I run the report, it does SUM correctly, but it also groups ALL my other data with other account categories when I don't want it to.

Does this make sense?

Answer 1

A little modification in your query is required. Use SQL Row Number function to generate the sequential row number returned by your query then in SSRS report group use below mentioned group expression.

=IIF(fields!acct.Value = "BURDEN", Fields!name.Value, CSTR(Fields!RowNumber.Value))

In text box expression use the field name that you want to display on the report.

I hope with little modifications you will be able to get your desired output.

---

Thanks
Salman
http://muhammadsalmanx.wordpress.com

Answer 2

Thank you. That's exactly what I needed.