<div>
<div class="content wysiwyg-content">
I HAVE A TABLE which has following columns<br />
<br />
Location &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Unit &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Amount<br />
L1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100<br />
L1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;200<br />
L1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;300<br />
L2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1000<br />
L2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2000<br />
<br />
I would like to have matrix report as follows.<br />
<br />
Location &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B3<br />
L1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;100 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;200 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;300<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Location &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
L2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
How can I achieve using matrix in SSRS. ANy help is appreciated.
</div>
</div>


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.

SQL SERVER REPORTING SERVICES

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.