Solved

Export to Excel Chart in SSRS

Posted on 2009-07-02
3
1,239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

762 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