Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Export to Excel Chart in SSRS

Posted on 2009-07-02
3
Medium Priority
?
1,301 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 200 total points
ID: 24770281
I am afraid you will get image only and that will not be editable.
0
 
LVL 27

Assisted Solution

by:Chris Luttrell
Chris Luttrell earned 400 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

824 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