How to add a button in SSRS report and on click of button pass the tablix dataset to local server which will export the data set in excel

2
votes

when we export the data to excel it contain lot of raw material like gauge and other unwanted things, but we need to export only the tablix data to excel. How to export data in SSRS report and on click of button pass the tablix dataset to local server which will export the data set in excel.

1
sqlreporting-servicesssrs-2008ssrs-2012ssrs-tablix

1 Answers

1
votes

There is no need for a complicated approach. You can simply set the visibility of an object depending on the renderer.

So for your charts for example, setting the hidden property to something like

=IIF(Globals!RenderFormat.Name = "EXCEL", true, false)