Ad-Hoc Reports

[Manon]

Hi,

I'm using this tool to generate ad-hoc reports based on selection criteria provided by the user.  I have a series of report templates and each of those are connected to the same SQL adapter - the only thing that changes is the WHERE clause of the select statement.  How can I change the SQL statement on a report via the ReportViewer at run-time?  My code-behind is VB.

Thanks,

Manon

[Svetoslav]

Thank you for your question, Manon.

Both WinForms and Web Report Viewers cannot modify the data source for a report, nor the command text of a data adapter. This is by design. You should handle this scenario with your custom logic outside the report viewer.

We will consider adding this feature in a future version of the product.

Feel free to send us your questions in case you have troubles implementing your logic.
 

Sincerely yours,
Svetoslav
the Telerik team

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

[Manon]

Hi Svetoslav,

Thanks for your reply.

I might have found a way to do it from the report itself that I think will do what I want.

Thanks again,

Manon