Solved

How to call or run sql server reporting services 2005 reports from asp.net web form button

Posted on 2008-10-14
4
755 Views
Last Modified: 2012-05-05
Hi,
I have created SQL SERVER REPORTING SERVICES 2005 reports in my asp.net 2005 application. How can I run these reports from the button click events? Should I use a report viewer control? How can I pass the parameter to the report as a criteria? Thanks
0
Comment
Question by:fycert55
4 Comments
 
LVL 20

Accepted Solution

by:
informaniac earned 250 total points
Comment Utility
Once reports are deployed on the report server, just call them like this

http://ServerName/ReportFolder/ReportName&param1=value
0
 
LVL 13

Assisted Solution

by:sm394
sm394 earned 250 total points
Comment Utility
IN code behind on click event set the ReportViewer properties
 // set processing mode to remote
        ReportViewer1.ProcessingMode = ProcessingMode.Remote;
        // specify report URL
        // replace localhost with server name if needed
        ReportViewer1.ServerReport.ReportServerUrl = new Uri(@"http://localhost/reportserver");
        // specify report path
        ReportViewer1.ServerReport.ReportPath = @"/dir/" + "reportname";

hope that helps
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 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

11 Experts available now in Live!

Get 1:1 Help Now