Introducing SQL Server Reporting Services
Subject:   Problems with groupings on Reporting Services 2005
Date:   2007-09-18 09:16:48
From:   pablops
Dear people,
I have a problem with a report where users want to see transacctions grouped by Account number and type(e.g: incomes and payments).

And so I use a table object where I put 2 groups:
1) Group by Account Number: Field!Account.Value
2) Group by Transaction Type: Field!Type.Value
I put in the detaill row group by: Field!Type.Value and Field!Account.Value.

When I execute the report only show the first row per transaction type, but the dataset has some rows per transaction type.

Please help me with this problem, thanks...