Solved

Export to Excel Chart in SSRS

Posted on 2009-07-02
3
1,238 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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

839 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