0
Customer has a Pie chart report but would like to export it to Excel, keeping the pie chart format/image. Any ideas?

Accepted Answer

Monday, August 27 2018, 12:26 PM - #Permalink
0
Unfortunately, those images are constructed dynamically by JavaScript.

Options:

  1. Do a scheduled report. That will send a PDF to the user. You can open the PDF (I used Foxit), select the image then copy and paste it into Excel. It's just an image at that point.
  2. Have Excel connect directly to the database and pull the data used for the pie chart, then build the pie chart in Excel. This is more complex and requires an ODBC connection to the DB. I have done this before but not with the newer Windows 10 versions of Excel.
  3. I haven't tried this but I think Excel VB could use REST services to pull data from SBM. This is just a theory ....

  • Mikaela Nilsson
    more than a month ago
    Thanks, PDF in scheduled report works fine even though it is many steps.
The reply is currently minimized Show
Responses (1)
  • Accepted Answer

    Thursday, September 06 2018, 06:29 PM - #Permalink
    0
    Other suggestions:

    1. Run the same report as tabular, export to Excel, use Excel's built in features to create a pie chart from the data.
    2. As Paul said, Excel can do a URL query to pull in data. Data->Get Data->From Other Sources->From Web.
    3. Ensure the report is tabular.
      Copy the report URL from SBM.
      Paste the report URL into Excel.
      Depending on your authentication mode, you may be able to authenticate, or you might not. If you can't, you can choose Advanced and provide a SSO token via the ALFSSOAuthNToken header.
    The reply is currently minimized Show
Your Reply

Recent Tweets