REST Service Accessing Report programmatically

[Carsten Koster]

Hey there,

just a quick Question:
Is it possible to programmatically change a report that is being generated by the Telerik Reporting REST Service?
The ItemDataBinding or needDatasource events to which I can subscribe when resolving the report are unfortunately not fired.

To be more specific, I would need to alter a datasource of a report depending on the passed report parameter values.

I have a DataSource which takes multivalue parameters but it is possible that those Lists are empty. Currently the DataSource will be empty in that case so I'd like to be able to change the SQL and remove the parameters which are empty.

Thank you for your help!

Regards,
Kris

[Peter]

Hi Kris,

Generally the ItemDataBinding and NeedDatasource are fired with the initial document rendering operation. Additionally in order to fire the NeedDataSource the data item DataSource property should not be set to any DataSource components. Still based on the provided information our recommendation is to use the ObjectDataSource component to manage the SQL query according the parameters. Additionally you may find useful the ObjectDataSource Wizard help article.

Regards,
Peter
Telerik