Two SqlDataSource with same stored procedure causes issues in Telerik Report

[Devesh]

Hi,

I am observing an error when there is a report file having one chart and a tabular grid. Both of these controls are using different SqlDataSource but they call common stored procedure with different parameters.When opened in Standalone Designer application, both of the datasources show same Result(attached snapshot: Sqldatasource1, Sqldatasource2). However, in reality if different values are passed in a stored procedure, it produces different result.

Any help will be appreciated.

 

Thanks

Devesh

 

[Devesh]

I am using Reporting R2 2016

[Devesh]

Hi,

I am using Telerik Reporting R2 2016

[Katia]

Hi Devesh,

The error in the attached screenshot indicates that some properties of Graph item cannot be evaluated as the expression contains object.

Check the settings of Graph item and make sure the expressions use only the data fields that exist in Graph's data source. More details can be found in Using Expressions help article.

If you want to access the data fields from a different data scope you can use data functions.

Also verify that the stored procedure returns properly the same data schema each time it is called.


If the above information does not help, please attach a problematic report in a support ticket so we can check the settings.

Regards,
Katia
Telerik