Dynamic Reports from Stored Procedures

[Pete]

Hi, I hope you can help.

We are currently using SQL Server Reporting which runs a stored procedure, which depending on supplied parameters it will then dynamically alter the fields of the output and return it to SQL server Reporting. Is there a way to do this in Telerik Reporting with a stored procedure and input parameters ?

Basically the fields on the output report will alter depending on what the input parameters where? Can this be done in Telerik and if so, is there an example of this.

Thanks a lot,

Pete Walker.

[Steve]

Hello Pete,

You can review the following KB article for more info on stored procedures: Using data source with parameters in Telerik Reporting.

Sincerely yours,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Pete]

Thanks Steve, I'm fine with setting up the stored procedures, but is it possible to change the layout of the report depending on what fields come back from the stored procedure, ie, they could be different returned fields depending on the values passed into the stored proc.

How can I design and format the layout if I don't know what fields are coming back until the stored procedure has been executed ? Is this possible ?

[Steve]

Hello Pete,

Your idea is a bit too complicated. It can probably be done, but it would have to be entirely programmatically and probably the logic behind this would be quite complex. A better idea would be to simply create several reports based on the returned fields.

All the best,
Steve
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.