Export Dashboard to Excel

other Xcelsius - Crystal Dashboard Design
1

Is it possible to export the Xcelsius dashboard swf to Excel from Infoview to Excel.

I know we can export the underlying data to excel from XLF.
But, a user who uses the dashboard from Infoview would like to export the dashboard to excel or pdf.
I only see the print button…just wondering if there is a export button or some other means the users can export the swf file to excel or pdf or power point

Thanks…

Diana_baker (BOB member since 2005-03-18)

2

There is no user end button that does this. You dont want one anyway, because of sizing issues that are going to happen.

What you could do is export the SWF file to PDF and Excel yourself.
Then make a link to the PDF file.
Then create a URL button that says “Create PDF” or “Create Excel”

You have more files to maintain, but your requirement is still met.

Cairmor :us: (BOB member since 2008-06-05)

3

Thanks Cairmor for the alternate solution.

I have one question though, our dashboard gets refreshed daily with new daily data (using live office).
If there a way to automate the refresh and export of the pdf file everyday?

Thanks…

Diana_baker (BOB member since 2005-03-18)

4

I came across this yesterday while I was googling something else entirely. It’s a bit old but it may help…

Debbie

Debbie :uk: (BOB member since 2005-03-01)

5

Thank you, Debbie for the article. I will take a look.

Diana_baker (BOB member since 2005-03-18)

6

A SWF is a SWF no matter where it lives. I deploy most of my dashboards in PDF (for distribution). The dynmaic part still works. You cannot save data in a SWF no matter where it lives. If you open the PDF, the dashboard refreshes itself. You dont need a separate PDF for the SWF inside to be dynamic.

There is a setting in Adobe Reader that will prevent dynamic queries from firing. You will need to do some heavy testing on PC’s that are not your own to solve the server issues that arise from having PDF’s on remote PC’s try to exchange data with the BOBJ server.

start by just exporting the SWF into a PDF, put the PDF on someone elses computer, and go from there…maybe its all smooth where you work.

When y

Cairmor :us: (BOB member since 2008-06-05)

7

Excellent! I will try this out as you have suggested.

Thanks…

Diana_baker (BOB member since 2005-03-18)