Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1845
  • Last Modified:

Embed Excel spreadsheet in SSRS report?

Is it possible, using the box Reporting Services functionality, possible to embed an Excel spreadsheet in a report, such that the embedded output is really just a URL to an Excel file sitting on a web server?
0
pragmatistMS
Asked:
pragmatistMS
1 Solution
 
chrismcCommented:
Out of the box no. You can't embed HTML into the report itself unfortunately.
I think SQL 2008 will have more options to do this sort of thing.

But for now, you could tackle this the opposite way round.
Probably SharePoint is the easiest way to avoid coding if you have it.
Create a page that contains the Report and also the spreadsheet. There are various ways to link them if necessary but that get's more complex.
Alternatively you can write your own web page using the ReportViewer control to show the report and the Office Web Component (OWC) control to show the spreadsheet.

You could also try using an OLEDB data provider as a datasource and read the excel spreadsheet in as data and get the report to render the data from the spreadsheet onto the report.
0
 
pragmatistMSAuthor Commented:
I may end up just developing a relational structure to hold this data, and displaying it in the report as a subreport.  I was hoping to leverage Excel for this, as it would give the user an easy way to edit what is essentially a spreadsheet, but I think including it in a report (which may be repeating, i.e. one summary + spreadsheet per page) will be more trouble that it's worth.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now