Filtering report in Excel after exporting from SSRS

Question

Hi All,

   I have created a basic report which has 3 groupings Region,Country and Cities. I have the measures as Total Amount and Total Quantity. I have also added Subtotals to all the 3 groupings. The users now want to export the report to excel and then filter on country or state or city. Say for example if i select the country as Region as East and Country as India and I select few cities, i need to get the subtotals and other details dynamically. The report needs to behave similar to the pivot tables created in excel.

Please let me know how to achieve this.

Thanks,

Ram

Answer 1

Hi,

As far as understand from your Query, you can apply filters in the Reports based on Region , Country and City.

Send these filters to your Query and accordingly the report will show up with New Subtotals.

Check the link below if you are not sure of parameters.

http://sql-bi-dev.blogspot.com/2010/07/report-parameters-in-ssrs-2008.html

 

---

Regards, PS

Answer 2

Hi Pritam,

 

  Thanks a lot for the reply. However the client does not want this functionality in the SSRs level. Thye want this once they export it to Excel. Is this possible?

 

Regards,

Ram

Answer 3

Hi Ram,

So Sorry but SQL Server Reporting Service(SSRS) only exports static data to a specified format(Excel in this case). This means dymanic filter or dynamic functionality is not enabled in exported Excel file by design.

The Only Possible approach seems like export into a excel the data create Pivots in Excel with the details data.

 

---

Regards, PS

Answer 4

Did u found any solution for applying filters while exporting to Excel

If Yes, please help.

---

Abhinav