[Webinar] Streamline your web hosting managementRegister Today

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

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

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
fycert55
Asked:
fycert55
2 Solutions
 
informaniacCommented:
Once reports are deployed on the report server, just call them like this

http://ServerName/ReportFolder/ReportName¶m1=value
0
 
sm394Commented:
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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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