ssrs

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • quadri
    New Member
    • Feb 2008
    • 17

    ssrs

    Hi
    can we pass the parameter from the .aspx page to sql server report 2005??

    and this is server report not a local report.

    TIA.
  • quadri
    New Member
    • Feb 2008
    • 17

    #2
    I found out the solution
    we can pass it by report parameter.

    heres the code:

    ReportViewer1.P rocessingMode = ProcessingMode. Remote;
    ReportViewer1.S erverReport.Rep ortServerUrl = new Uri("http://localhost/ReportServer");
    ReportViewer1.S erverReport.Rep ortPath = "/abc/rptSample";
    List<ReportPara meter> paramList = new List<ReportPara meter>();

    paramList.Add(n ew ReportParameter ("Months",Repor tParameters.Mon ths,false));

    this.ReportView er1.ServerRepor t.SetParameters (paramList);

    cheers!

    Comment

    Working...