SSRS Deployment Support

[siddisagar]

Hi Team, I am having SSRS project. I have few doubts 1. How to call my SSRs report on click of button in ASP.NET website. 2. How to give connection string when I deploy my application in Test/ Production Server please guide me

[Abhijit Jana]

Hi Siddisagar,

siddisagar wrote:

1. How to call my SSRs report on click of button in ASP.NET website.

Hope you have already designed the SSRS reports and hosted the same on IIS Server. Now you need to do the following steps . First : Add Microsoft.Reporting.WebForms namespace with your ASP.NET Web application . This contains methods and properties for the ReportViewer Web server control.

<%@ Register Assembly="Microsoft.ReportViewer.WebForms Namespace="Microsoft.Reporting.WebForms" TagPrefix="SSRSWeb" %>

Second : SSRS viewer assembly will add the ReportViewer control with your web application which you can use to featch the data from SSRS to your aspx page.

Third : Add Button Click Code Behind For view the Reports

SSRSViewer.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;
    SSRSViewer.ServerReport.ReportPath = "MyReports"; 
SSRSViewer.ServerReport.ReportServerUrl = new Uri("http://localhost/ssrsreports"); 

You are done !!

siddisagar wrote:

2. How to give connection string when I deploy my application in Test/ Production Server

You are talking for ASP.NET web application connection string or what ? I guess you need to change only in config file. Nothing else.

Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

[sashidhar]

siddisagar wrote:

How to call my SSRs report on click of button in ASP.NET website

Use Report Viewer and display tha report in reportViewer..! here is the sample code which i done previously

         DataView dv = new DataView();            
        //Accessing the Method From Class File            
        dv = dAccess.GetDataView();
       //Calling the Method
        ReportDisplay(dv);

   private void ReportDisplay(DataView dv)
        {
        // Set RDL file
        reportViewer.LocalReport.ReportPath = "Report.rdlc";
        // Supply data corresponding to each report data source.
        reportViewer.LocalReport.DataSources.Add(new      ReportDataSource("AdventureWorksDataSet\_CreditCard", dv));
         // Process and render the report
         reportViewer.LocalReport.Refresh();

}

If You have Any More Doubts in ssrs reports Feel Free to ask me..!

LatestArticle :Log4Net Why Do Some People Forget To Mark as Answer .If It Helps.