Passing Parameter via Mark-Up or Code Behind Ignored

[Mark]

<telerik:ReportViewer
          ID="reportViewer1"
          Width="90%"
          EnableAccessibility="true"
          PageMode="SinglePage"
          ScaleMode="FitPageWidth"
          runat="server">
          <ReportSource Identifier="Report1.trdp" IdentifierType="UriReportSource">
              <Parameters>
                  <telerik:Parameter Name="AccountId" Value="25585" />
              </Parameters>
          </ReportSource>
      </telerik:ReportViewer>

 

I tried pass the Parameter via the html and code behind and it seems to be ignored. My Report1.trdp file reads a Stored Procedure passing in the AccountId. I am using a SQL Data source as part of the Report1.trdp file.

protected void Page_Load(object sender, EventArgs e)
      {
          if (!IsPostBack)
          {
              this.reportViewer1.ReportSource.Parameters.Add("AccountId", 25585);
          }
      }

[Nasko]

Hello Mark,

Both of the provided code snippets for setting the parameter value are correct. The process of passing a parameter value from the HTML/code behind to the SQL stored procedure has multiple steps. Please make sure that all of the steps are completed and test again:

1. Pass the parameter values from the viewer to the report via HTML or code behind (this is correctly implemented).
2. Make sure that a report parameter exists in the report with the same name (AccountId) and correct type (String or Integer might be suitable for "25585"). The report parameters are present in the Report.ReportParameters property.
   You can test if the value is passed correctly to the report parameter by adding a TextBox somewhere in the report and setting the TextBox.Value to the report parameter's value.
3. Make sure that a data source parameter exists that is the link between the report parameter and the stored procedure. The data source parameter value should be set to an expression like the following:
   
   = ReportParameters.AccountId.Value
   
   You can test that the value is passed correctly to the stored procedure by starting the SQL Server Profiler and examining the sp call.
   

Regards,
Nasko
Progress Telerik

[Mark]

Thanks so much. This was the piece I was missing 

 

Make sure that a data source parameter exists that is the link between the report parameter and the stored procedure. The data source parameter value should be set to an expression like the following:

= ReportParameters.AccountId.Value