I have to make a report in SSRS 2008 such that when the report is run the UserId and the System date will be passed as parameters and the report should directly render in excel. WE have Sharepoint 3.0 integrated with SSRS 2008 and the reports are deployed on this Sharepoint server. Can someone please suggest how we can achieve this? Thanks Sweta

Hi Sweta, The requirement you describe is only be possible through URL. It means you need to call your report using the URL. Please go through the below link. http://www.ehow.com/how_6364430_change-default-rendering-ssrs.html Thanks Nishant

Thats the first thing I tried but it doesnt seem to work. The basic Link that i have given is: ="javascript:void(window.open('Server Name/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=Report Name.rdl&rp:ID=" & Parameters!ID.Value & "&rp:FROMDATE=" & Parameters!FROMDATE.Value & "&rp:LOGINID=" & Parameters!LOGINID.Value & ','_self'))" This opens the report in normal Report Viewer. Now I have added " &rs:Command=Render&rs:Format=Excel" in my url. New link: ="javascript:void(window.open('Server Name/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=Report Name.rdl&rp:ID=" & Parameters!ID.Value & "&rp:FROMDATE=" & Parameters!FROMDATE.Value & "&rp:LOGINID=" & Parameters!LOGINID.Value & "&rs:Command=Render&rs:Format=Excel','_self'))" But still it opens the report in the Report Viewer itself. Im confused as wherever I have searched,this is the solution that they have provided. Where am i going wrong? Thanks