SQL SERVER REPORTING SERVICES

SURESH0518
SURESH0518 used Ask the Experts™
on
I HAVE A TABLE which has following columns

Location      Unit      Amount
L1      B1      100
L1      B2      200
L1      B3      300
L2      B4      1000
L2      B5      2000

I would like to have matrix report as follows.

Location      B1      B2      B3
L1       100      200      300
                  
Location      B4      B5      
L2      1000      2000      

How can I achieve using matrix in SSRS. ANy help is appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Right Click and insert the matrix in the report.

Create a dataset for getting the values as you have.
Location      Unit      Amount
L1      B1      100
L1      B2      200
L1      B3      300
L2      B4      1000
L2      B5      2000

Drag and drop the location in the Rows of the matrix
Drag and drop the Unit in the Columns of the matrix
Drag and drop the Amount in the data of the matrix

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial