I am back with another RDLC issue.
I have a dataset containing these fields
CustomerID, Section, Code, Title, Active
Lets say the data looks like this:
001, Section1, NP234, Title1, True
001, Section1, IMO-100, Title2, False
002, DIGITAL UPDATES, DIG85, Lorem, True
I want to group on CustomerID and Section so that for the above 3 rows the tablix looks like:
Customer 001
Section Code Title Active
Section1 NP234 Title1 True
IMO-100 Title2 False
Customer 002
Section Code Title Active
DIGITAL UPDATES DIG85 Lorem True
So basically group by CustomerId and Section, however when I try this the tablix seems to have a mind of its own, putting in rows/columns all over the shop.
Any advice is welcome.
Thanks,
Andrew
Loading
AndrewPosted Jan 19, 2011, 3:47 PM
However the data retrieved from database is in the correct format. It is just formatting the report that is the problem.
When I group on CustomerID that whole column becomes "as one", I cannot put Section underneath it so it means for the whole report there is a large blank area under the heading "CustomerID"
All I want is to list group by CustomerID and repeat the headings for each different CustomerID.
Suthish NairPosted Jan 19, 2011, 3:41 PM