Ask a questionAsk a question
 

QuestionExportSSRSReportToExcelReportViewerWebPart

  • Monday, October 19, 2009 12:48 PMjab62307 Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    We are using SSRS 2005 and have it integrated with MOSS 2007.   We are using the SSRS Web Part Report Viewer.  The users want to be able to export the report they are viewing directly to excel.  The built in export to excel selection exports more information in the report than they want.  If they could have it export the data as the csv export does it would work ok, for them.  I know they can go to csv then into excel but that is not an option for these users.  Are there some configuration settings somewhere where the export options from the viewer can be set? 
    Is there an add-on or other web part that would alow the users to select the fields the fields they want to export to excel, from the report viewer?

    Thanks