ssrs report Export to excel along with parameter filters
I have one report with one table . Added filter to report by using values from parameter. On Report I am able to filter data using parameter filter, after exporting report to excel parameter filter is not exported. Is there any way to export filters available on report ( on top of report ).
August 22nd, 2012 5:58am

Is this report deployed on Report Server or is it integrated in some Application (web or windows) ? can you please provide more details.Thanks Prasoon
Free Windows Admin Tool Kit Click here and download it now
August 22nd, 2012 4:40pm

Hi There Thanks for your posting. If you are trying to export what is your parameter values when you run the report and export it to excel what you could do either in report header or footer you can put a textbox and expression might be =Parameters!ParameterName.Value If you have multivalued parameter please use following expression =Join(Parameters!ParameterName.Value, ",") However if you are trying to export your parameters inside excel and then trying to filter your report in excel by changing the parameters values, as far as I know this is not possible I hope this will help If you have any questions please let me know Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
August 22nd, 2012 5:08pm

Hi There Thanks for your posting. If you are trying to export what is your parameter values when you run the report and export it to excel what you could do either in report header or footer you can put a textbox and expression might be =Parameters!ParameterName.Value If you have multivalued parameter please use following expression =Join(Parameters!ParameterName.Value, ",") However if you are trying to export your parameters inside excel and then trying to filter your report in excel by changing the parameters values, as far as I know this is not possible I hope this will help If you have any questions please let me know Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
Free Windows Admin Tool Kit Click here and download it now
August 22nd, 2012 5:12pm

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

Other recent topics Other recent topics