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