Click here to Skip to main content
15,887,821 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
XML
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???
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900