Hi,
What is the best way to publish reports to a dashboard in SharePoint 2007 site and refresh the data?
At this moment i make the next steps:
1. place an excel document with jetreports functions in a SharePoint library with the publish function (Excel Sevices)
2. make a scheduler task for all documents in the library to run the reports, make the output location a other SharePoint library (this can't be same location)
3. make a SharePoint page with excel webparts that refers to the library descripted in point 2
When i run the jetreports scheduler all the reports are refreshed on the SharePoint site.
I'm looking forward what other people do!
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello,
Can yu please provide more details? For example regarding data source settings..
Thank you. -
Jet Reports Historic Posts Hi,
I don't think a lot of this is actually possible. Excel services does not allow any kind of add-ins so you cannot run a report within Excel services. You could put +Values on the report so that there are no Jet functions on it and then upload it and view it in Excel services, but to re-run it you would have to download it to a machine with Jet installed. This is unfortunately a limitation of Excel services itself since it doesn't support add-ins.
SharePoint integration for Jet and specifically the scheduler is definitely a feature that's been discussed in the past, but currently I don't believe that the Jet Scheduler has the ability to save to a SharePoint library. Maybe someone out there has figured out how to do it and can correct me, but I don't think that's possible either.
Regards,
Hughes
Please sign in to leave a comment.