Parameters: can't perform '=' on String and Int

[Digital Man]

I'm finally playing with Telerik Reporting. I have a WinForm with the ReportViewer control. I have a report setup. I added a int type parameter called UserID to the parameter collection of the report. I created a filter expression of UserID_FK = the UserID parameter (from the dropdown). In the code I set the param using

reportViewer1.Report.ReportParameters.Add("UserId", Telerik.Reporting.ReportParameterType.Integer, value.ToString());

It only accepted a string as a parameter.

Not clear on the best way to do this.

[Milen | Product Manager @DX]

Hi Dan Duda,

In the current implementation of the expression engine, if both values of the operands in the comparison are of different types , false is returned. So you need to provide a value in the appropriate type.

The Add method you are using is intended to add a parameter with an expression as value. Actually, in previous versions of the product only expressions could be used as value for the parameters. This method is left in the API for backwards compatibility reasons.

Now if you need to add a report parameter programmatically, you can use the same code as the generated from the report designer. Something like:

            Telerik.Reporting.ReportParameter parameter = new Telerik.Reporting.ReportParameter();
            parameter.Name = "UserID";
            parameter.Type = Telerik.Reporting.ReportParameterType.Integer;
            parameter.Value = value;

             reportViewer1.Report.ReportParameters.Add(parameter);

Or even more simpler, to use the other constructor of the report parameter:

            Telerik.Reporting.ReportParameter parameter = new Telerik.Reporting.ReportParameter(
                    "UserID",
                    Telerik.Reporting.ReportParameterType.Integer,
                    value);

             reportViewer1.Report.ReportParameters.Add(parameter);

However, in your case you have defined and used (in the filter) the parameter at design time. So all you need to do in the win application is to access the parameter and set it's value. Something like:

            reportViewer1.Report.ReportParameters["UserID"].Value = value;

For more information on report parameters, please review the help article Report Parameters.

Let us know if you need any further assistance.
 
Kind regards,
Milen
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[Digital Man]

Ah, thank you!