?
Solved

Export all webparts to excel

Posted on 2013-11-17
3
Medium Priority
?
494 Views
Last Modified: 2013-12-10
Hi,

Please let Me know if there is way of exporting all the webparts into a excel a single click.
Has anyone implement this please share with me the method?
My users required to export all the reports and graph are in the sharepoint to excel at once.

Webparts are calling SSRS reports

Thanks in advance
0
Comment
Question by:keplan
[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 1

Expert Comment

by:FriedTyGuy
ID: 39663826
Not sure I completely understand the question but based on assumption; you have an SSRS report you want the end user to be able to run and export directly to excel with out having to use the report viewer??

Is the report parameterized?  Whether it is or not make a little difference but in a nut shell, get the link to the report and add "&rs:Format=Excel" (or "&rs:Format=XLS" or depending on your SSRS version) to the end of the link.
0
 
LVL 37

Accepted Solution

by:
ValentinoV earned 2000 total points
ID: 39665593
I was hoping that one of the SharePoint experts would jump in here, but alas so I'll go for it myself...  I don't think that this is possible.  The web part which you're referring to is probably the "SQL Server Reporting Services Report Viewer" web part?  So basically each web part has got its own report viewer and the Export to Excel functionality is provided by that report viewer.  What you're asking would require SharePoint functionality that provides a "export web parts to Excel" function or something similar.  Out-of-the-box I don't think this exists, perhaps it's possible through some custom code though even that wouldn't be very straightforward I think.

The best workaround I can think of is that you build a new report that contains all reports as currently used by those web parts in Subreport controls.  Then add a link to one of the web parts that reads "Export to Excel" and use report server URL parameters to have the report exported to Excel.  The URL would be something like this:

http://myspsite/subsite/_vti_bin/reportserver?http://myspsite/subsite/YourNewReport.rdl&RS:Format=EXCEL

Ref. Pass a Report Parameter Within a URL
0
 

Author Closing Comment

by:keplan
ID: 39710589
ex...
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses

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