Creating reports and dashboards | Stimulsoft community forum

I have a report to Informix which must be run in two steps: first create a temporary table with data from a previous query and then the report must collect the temporary table for use in the same report.
Any idea as i can do this in stimulsoft?

Thank you
Milton

Hello, Milton.

I see only one way how your report could be created.
1) You create a stored procedure and prepare the temporary table there as you need. This procedure must return all necessary columns.
2) There are limitations on using of stored procedures in Stimulsoft Reports.
- Number of Columns is fixed.
- For the stored procedures with variable number of columns 'Retrieve Columns' button will not work and you have to add columns for such a procedure 'by hand' in the DataSource Editor.

Thank you.

Edward, thank you for your help.

Milton

Please let us know if any help is required.

Thank you.