Newbie Question

Hi Guys,

I am new to this Reporting Service world. May be its very simple question.

I have create a report in SQL Server 2005 reporting services and want to link this report with aspx page. How I do this. Just want to link report with default.aspx page so when this page open report also open automatically.

Please let me guide how could I do this.

Regards

I would recommend using the ASP.net ReportViewer control. It will make the web app appear much more polished than just linking to the reportmanager.|||If you don not want anything to change programmtically you can also just display the appropiate report in your frame targeting to the URL of you report on the ReportServer interface. (The one that you see if you navigate through the webservice http://Server/reportserver, e.g. http://server/reportserver?Somefolder/Report&Parameter=SomeValue)

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de|||

Greate!! Thanks for your reply.

I pasted a report control on my aspx page but how I link my report with this page. I used the below code but it giving me error message

ReportViewer1.LocalReport.ReportEmbeddedResource = @.\\Business\Business\RPT825.rdl; (This is my local machine path)

and the Error message is

An error occurred during local report processing.|||

Hi Guys,

Please ignore my previous email. I have fixed the above issue. Now I don't know how to pass a parameter value to a report.

I wrote the below line in my aspx page and when I ran this application it gives me a error message

"The rDate parameter is missing a value"

Below is the code that I wrote in my page_load event

ReportViewer1.LocalReport.ReportPath = @."C:\Business\RPT825.rdl";

Could you please let me know how to pass parameter value to a report.

Regards

|||

ReportViewer1.LocalReport.SetParameters( );

Juran

sql