How do you set parameters in an SSRS report on a report server from values in a web page?

Last post 11-07-2009 1:22 PM by craigbtx. 4 replies.

Sort Posts:

  • How do you set parameters in an SSRS report on a report server from values in a web page?

    11-07-2009, 12:26 PM
    • Participant
      1,567 point Participant
    • craigbtx
    • Member since 10-01-2004, 12:50 PM
    • Posts 675

    Without using a URLor the parameters dialog box at the top of a report,
    how do you set parameters in an SSRS report on a report server from values in a web page?

    If I have a report that show employees by state. A user picks a state from a state dropdownlist on a web page. I want to pass the state value as a parameter to the report. Again without passing the parameter on the URL or the dialog box.

    Thanks

  • Re: How do you set parameters in an SSRS report on a report server from values in a web page?

    11-07-2009, 12:48 PM
    Answer
    • All-Star
      60,493 point All-Star
    • anas
    • Member since 09-21-2006, 4:31 AM
    • Palestinian Territory, Occupied
    • Posts 6,839
    • Moderator

    Use the SetParamters method:

    Example

    ReportParameter[] Params = new ReportParameter[1];
    Params[0] = new ReportParameter("ParamName", DropDownList1.SelectedValue);
    ReportViewer1.ServerReport.SetParameters(Params);





    Regards,

    Anas Ghanem | Blog

  • Re: How do you set parameters in an SSRS report on a report server from values in a web page?

    11-07-2009, 1:03 PM
    • Participant
      1,567 point Participant
    • craigbtx
    • Member since 10-01-2004, 12:50 PM
    • Posts 675

    I get an error on line
    ReportViewer1.ServerReport.ReportServerCredentials = New ReportServerNetworkCredentials

    ReportServerNetworkCredentials are undefined??

    What am i doing wrong?

    Thanks

     

  • Re: How do you set parameters in an SSRS report on a report server from values in a web page?

    11-07-2009, 1:04 PM
    • All-Star
      60,493 point All-Star
    • anas
    • Member since 09-21-2006, 4:31 AM
    • Palestinian Territory, Occupied
    • Posts 6,839
    • Moderator

    craigbtx:

    I get an error on line
    ReportViewer1.ServerReport.ReportServerCredentials = New ReportServerNetworkCredentials


    ReportServerNetworkCredentials are undefined??

    What am i doing wrong?

    Thanks

    sorry that line is not required , i already edited my previous post and removed it.



    Regards,

    Anas Ghanem | Blog

  • Re: How do you set parameters in an SSRS report on a report server from values in a web page?

    11-07-2009, 1:22 PM
    • Participant
      1,567 point Participant
    • craigbtx
    • Member since 10-01-2004, 12:50 PM
    • Posts 675

    Thanks alot. That works!!! 

Page 1 of 1 (5 items)
Microsoft Communities