Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Embed Excel spreadsheet in SSRS report?

Posted on 2008-06-16
2
Medium Priority
?
1,773 Views
Last Modified: 2011-10-03
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
Comment
Question by:pragmatistMS
[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
2 Comments
 
LVL 18

Accepted Solution

by:
chrismc earned 2000 total points
ID: 21800258
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
 
LVL 3

Author Closing Comment

by:pragmatistMS
ID: 31467654
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

688 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