Solved

Export to Excel Chart in SSRS

Posted on 2009-07-02
3
1,235 Views
Last Modified: 2012-05-07
I have a  Sql reporting service that create a chart on report server, there is a build-in functional  on SSRS that export to excel, but what i'm going to do is, to let user able edit the chart after it has already converted in excel. Would it possible?  The current method of SSRS is convert the chart to picture format. User no longer able to edit the figure.. Thanks in advance
ExcelPic.jpg
0
Comment
Question by:mycacha
3 Comments
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 50 total points
ID: 24770281
I am afraid you will get image only and that will not be editable.
0
 
LVL 26

Assisted Solution

by:Chris Luttrell
Chris Luttrell earned 100 total points
ID: 24778503
Unfortunately Ritesh is correct.  You would have to go to 3rd party tools like Office Writer to generate a working graph in Excel but even those are not easy or straight forward.  We have been researching tools for a bit to do some things like this without much success.  We have some users that have thier graphs and pivot tables set up in their spread sheet, then just run a report to get the current data exported to Excel and then copy the data into thier preset spread sheet.  Not the prettiest setup but it gets the job done with what we have to work with for now.
0
 

Accepted Solution

by:
mycacha earned 0 total points
ID: 24875360
I'll decided to use traditional method compile data to excel and generate graph by using the data. It solve my problem . thanks
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question