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: 990
  • Last Modified:

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

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
canuckconsulting
Asked:
canuckconsulting
  • 2
2 Solutions
 
ValentinoVBI ConsultantCommented:
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
 
planoczCommented:
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
 
canuckconsultingAuthor Commented:
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
 
canuckconsultingAuthor Commented:
Working great thanks!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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