Solved

How to wrap SQL Server Reporting Services site into a web application

Posted on 2014-02-17
5
917 Views
Last Modified: 2014-02-24
We are implementing a data warehouse solution using MS SQL Server Analysis Server and MS SQL Server Reporting Services which we are very new to.  We have an existing company web portal we use for report distribution and other tasks.  

We would like to embed our DW solution into this existing webportal allowing users to select a number of high level reports, drill down and specify parameters.  Ideally the parameters would b specified using some forms we have  as opposed to the headers area on SSRS reports.  Is this possible and, if so, links to examples (ideally sample projects) would be very helpful.

We are using MS SQL Server 2008 R2.
0
Comment
Question by:canuckconsulting
  • 2
5 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 400 total points
ID: 39866633
Assuming your web portal is developed using .NET you can use the ReportViewer control to display reports and pass parameters into them.  This MS doc page (incl. example) should help you get started: Using the WebForms ReportViewer Control

Using that control you can use any custom forms to accept input from the user and then pass the values into the report through the SetParameters function on the ServerReport object.
0
 
LVL 27

Assisted Solution

by:planocz
planocz earned 100 total points
ID: 39873633
This may help; it is written in VB.net
this code will produce a pdf from ssrs.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_26665879.html
0
 

Author Comment

by:canuckconsulting
ID: 39882617
I've requested that this question be deleted for the following reason:

Does not appear to be driver for this card at this time
0
 

Author Closing Comment

by:canuckconsulting
ID: 39882619
Working great thanks!
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

911 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now