I am designing a RDLC report fore sale detail data. I have Shop name, Terminal Number, Invoice number and sold item detail.
ShopName TerminalNO InvoiceNo SoldDate ItemCode ItemName Price
UMT 001 UMT001001 01-Mar-2016 C1 ABCD 100
UMT 001 UMT001001 01-Mar-2016 C1 ABCD 100
UMT 002 UMT002001 02-Mar-2016 C1 ABCD 100
UMT 003 UMT002001 03-Mar-2016 C1 ABCD 100
BNN 001 BNN001001 01-Mar-2016 C1 ABCD 100
BNN 002 BNN002001 01-Mar-2016 C1 ABCD 100
I want to group the data in the report as follow-
ShopName-UMT TerminalNo-001
SoldDate-01-Mar-2016
InvoiceNo-UMT001001
ItemCode ItemName Price
C1 ABCD 100
C1 ABCD 100
SoldDate-02-Mar-2016
InvoiceNo-UMT002001
ItemCode ItemName Price
C1 ABCD 100
ShopName-BNN TerminalNo-001
SoldDate-01-Mar-2016
InvoiceNo-BNN001001
ItemCode ItemName Price
C1 ABCD 100
I mean I want each group name as a row header not as a column name.
Any help?
What I have tried:
I can group as a column but I don't want it as column, I want group name as a row header and the table data should display under the group header.
Is it possible???