How to Make a report automatically render to excel

See more:

MS-Excel

SSRS

rendering

reporting

Hello All,

I have a report that I created with multivalue parameters (some which have default values and some which don't). The user selects relevant parameters and subsequently clicks on the format he/she wants to view it which in this case is in Excel format.

My question is how do I make the report render to excel automatically once the user clicks on the View Report button on run time i.e it just defaults to Excel automatically instead of automatically showing the report in the classic HTML format.

Thanks in anticipation.