3

I have a simple bar chart in an SSRS 2008 R2 report which is rendered using the VS2008 ReportViewer control in my ASP.NET AJAX application. By default, when the report is exported to Excel, the chart is represented in Excel as an image. Is it possible to have the chart rendered as an actual Excel chart, not an image?

My ultimate goal here is to get the chart into Excel in an editable format. I'm trying to avoid building the Excel sheet programmatically, if possible.

Any possible approaches or info would be greatly appreciated.

Thanks, Tom

temarsden
  • 332
  • 5
  • 16

1 Answers1

3

It is not currently possible. You'll need to look at a third-party option.

Take a look at Office Writer as a third-party possibility. Unfortunately, it is not cheap.

You might be able to look at a possibility where you export the actual data instead of a chart. The user would export only the data (which isn't really desired) and then they would need to create the chart themselves. With more time and effort, you could write an Office VSTO Add-In that could automate the process for your endusers.

Ultimately, if you're looking for a quick and easy and cheap solution then you're out of luck with using only the native SSRS export.

NakedBrunch
  • 48,713
  • 13
  • 73
  • 98
  • Thank you Alison. The users have actually requested both an editable chart and the raw data in Excel, you're suggestion is spot-on. If a third party solution can't fit in our budget I'll most likey go with the VSTO Add-in route. Thank you for your time! – temarsden Apr 06 '11 at 19:32
  • 1
    @tmarsden: Cool. I often add an additional tab of raw data in my reports so that "power Excel users" can take it upon themselves to slice and dice the data as they see fit. The uneditable chart image is for those that just want a quick view and nothing more. – NakedBrunch Apr 06 '11 at 20:23