I have created a two table report, one with pretty formatting, the other a raw view of the same data for exporting to Excel. The two tables are shown/hidden via a boolean report parameter. (While one is shown, the other hidden.) How much pain and suffering would it be to not only have the raw view displayed but the export process started to the file Save As dialog box? I know that it is only an additional two clicks, but anything I could save the users would be helpful. Thanks in advance for any help. Greg Starr Data Analyst El Rio Community Health Center

As far as I know this functionality isn't possible. A workaround would be to export to csv files which would strip out all your formatting and thus eliminate the need for the two tables and boolean parameter. Another more appealing alternative, would be to hide the boolean parameter from users, get them to execute the report with the formatting and include a text box "Click here for Excel version" which has a hyperlink to the report url and passes through the boolean parameter and the excel render format, you could extend this by using an expression for the hyperlink to also include any user selected parameters such as customerID or month etc. your url would look something like: http://<ServerName>/reportserver?/Sales/YearlySalesSummary&rs:Command=Render&rs:Format=EXCEL&ExcelReportBoolean=1&CustomerID=52 Have a read of the link below for details on url parameter passing: http://msdn.microsoft.com/en-us/library/ms152835.aspx My Blog "Karl Beran's BI Mumble"