SSRS Excel Export - Detail Data Options

I have a SSRS report that is currently being rendered in Excel for the end user. The report is organized by month in the columns and sales group in the rows. The data fields are the sum of transactions ($) for each month/sales group.

The end user would like the option to select a data field and have the underlying detail data open in a new excel tab (essentially how a standard pivot table would work in Excel). The typical drill down and drill through reports are not ideal as there are hundreds of underlying transactions, thus the main report would be difficult to visualize. Is this functionality available in SSRS excel exports?

Thanks in advance.

Answers


Unfortunately the answer is "no, this functionality is not available". It's possible to have cells in report tables that contain a link to another report, these are exported to Excel as hyperlinks, but the link is to a report not another Excel worksheet.

It might be possible to to do something like this if you had a data region in the report for each possible drillthrough and then set these up so they exported to Excel as different worksheets in the same workbook. You might then be able to use the Go to Bookmark action to link to the workbooks (I haven't tested this). However this is unlikely to be a good solution as it sounds like you would have dozens of possible drillthrough datasets.

It sounds to me like a better option for you would be to build a SSAS cube of the data, your users could then connect directly to the data from Excel and use SSAS/Excel drillthrough and pivot functionality.


Need Your Help

how to upload file to OpenStack Swift in .net / Windows phone

.net c#-4.0 windows-phone-8.1 windows-applications openstack-swift

I have established openstack swift connection with .net/ windows 8.1 app but i am unable to find any method to upload file or create object to openstack swift using windows 8.1 app / .net

How to create native C++ library on Android?

java c++ android java-native-interface nativelibrary

I need to write a dynamic link library in C++ that is used by Java on Android.