Last post Jul 20, 2011 03:58 AM by You-Hu Fu
Jul 14, 2011 10:36 PM|cobrasundar|LINK
I need a solution for the below problem in SSRS. I have 2 Area which 2 Points Each point is having different states. I got the group, Points and states as a table. State are the values for the row. So I have implemented the report as a matrix As I am not
sure about the different states for different point.
I need to generate the matrix report like this format by grouping the area. In turn, generating the matrix with different column name for different row. The format is below,
Point Name On Off
Analog P2 Y Y
Analog P1 Y Y
Point Name On Off Mode State
Digital P1 Y N Y N
Digital P2 Y Y Y Y
Please help me the generate the as per the above format.
Jul 20, 2011 03:58 AM|You-Hu Fu|LINK
You should make use of list control, design your tablix like this:
Column Group: Status
Row Group: States
Detail row: Your Data field
Then put this tablix into the list control, then group the list by Area.
If this is not what you need, please feel free to let us know, and also give the struture of your dataset.