ReportServer Forum

nutanc

Member

Registered: 2014-04-02

Support for stroed procedures

How do I create a report based on a stored procedure in MySQL instead of a query?
Thanks.

tomharney

Member

Registered: 2014-03-11

Re: Support for stroed procedures

The end of this post may be of assistance:  http://forum.reportserver.net/viewtopic.php?id=120

Thorsten J. Krause

datenwerke

Registered: 2012-02-15

Website

Re: Support for stroed procedures

If you can (with little effort) use stored procedures with ReportServer depends on the report format you'd like to use. If you are using Birt or Jasper Reports, just follow the respective vendors instructions.

To use a stored procedure as the data source for a dynamic list, on the other hand, is a little bit tricky. The reason behind this is, that the dynamic lists features (sorting, filtering, aggregating...) all rely on the execution of sql-select queries, which usually can not use a procedure (with some databases (e.g. oracle) procedures can return table objects, that can be used in select statements - but with mysql this in not possible).

We can emulate this, by temporarily storing the data in a table (see Toms post), but this is only feasible for rather small datasets.

Cheers,
Thorsten

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Support for stroed procedures

For completeness:

if you create a view containing the stored procedure, you could use this view in reportserver directly: select * from myview

Regards,
Eduardo