January 11, 2010 at 1:14 pm
Hi all,
I created a simple report using SSRS in SQL Server 2005. I sent the .rdl to a guy who deployed it to the server were SQL runs. I now want to open the report from am asp.net web page. Can someone help get me started here? Also, the guy who deployed the report I sent him, told me the url for the reeport was like: http://localhost/reportserver/reportserver/
But I need the server name instead of "localhost" correct?
These are probably dumb questions but I'm not too strong in the networking / server area.
Thanks,
Bob
January 13, 2010 at 12:43 am
Hi Bob,
the way to embed Reports in yaour ASP.NEt app dependes on the type of usage.
If you want to display a report in some kind of 'frame' on your page, giving the user the ability to choose parameters and so on, you could use the Reporting Services Web Control. A short introduction is found here: http://forums.asp.net/t/1281716.aspx and here: http://msdn.microsoft.com/en-us/library/ms251671(VS.80).aspx
If you want to parameterize the report in code or display the Report as an PDF (which is preferable sometimes as the rendering is guaranteed to be as it prints), you could use the SOAP protocol from within .NET, which is not too difficult, but it involves some classes and configurations.
For me a good entry point for understanding how it works was here: http://msdn.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice(SQL.90).aspx
Just some quick links; hope it helps a bit...
Guenter
January 13, 2010 at 8:50 am
Yes you need the server name.
YOu have the options Guenter provided you can also use URL Access to display the report.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply