PivotTable report in SSRS 2008 R2

Hi

What is the best approach for turning the report below into a PivotTable report in SSRS 2008 R2?

The PivotTable has the following characsteristics:

Filters:     None
Columns: Mat_Month
Rows:      Level1, Level2
Values:    MaturingBalances

We have an SSAS Cube with the same data (in a dimensional schema)

The report (currently sourced via SQL from our data warehouse):

The Pivot Table - currently in Excel but needs to be ported to SSRS

June 17th, 2015 8:07am

Hi Amir, 

According to your description, you want to export the Pivot table to Reporting Services, right? 

In Reporting Services, its not supported to export a excel pivot table data into a report. Even we can use Excel file as data source, we can only get the unstructured data without any hierarchy relationship. In this scenario, since the data is from a SSAS cube, it much better to make the Reporting Services directly connect the SSAS cube.  So I suggest you use Microsoft SQL Server Analysis Services as data source and load directly load the structured data from the cube.  

Reference: 
Data Sources Supported by Reporting Services (SSRS)

If you have any question, please feel free to ask. 
Regards, 
Shrek Li

Free Windows Admin Tool Kit Click here and download it now
June 18th, 2015 3:53am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics