How to execute an stored procedure and load the fields and data from it into the report workshop.
how to avoid the use of the report design helper form and also avoid the use of reportDocpProperties.
i mean, i want to load the fields and data not from a table but from a resulset that executes an stored procedure.
Using the Worshop demo
-
Sergey Tkachenko
- Site Admin
- Posts: 17520
- Joined: Sat Aug 27, 2005 10:28 am
- Contact:
Re: Using the Worshop demo
About stored procedures
I never worked with stored procedures myself, sorry... But I believe you can use CALL SQL statement just like SELECT in report data queries.
If it works in TDataQuery, it must work in Report Workshop as well.
About avoiding using UI
User interface is not necessary, you can create reports in code.
We have several demo projects showing how to create reports in code. For example, for FireDAC, all numbered demo projects in Demos\FireDAC\
I do not understand the problem with reportDocpProperties. What do you mean? There is TRVReportDocObject class, it is required to store document-related report properties, for example a data query applied to the whole document. But using this object directly is not required. For example, you can use RVReportSetRootDataQuery function to define the data query to apply to the whole document.
I never worked with stored procedures myself, sorry... But I believe you can use CALL SQL statement just like SELECT in report data queries.
If it works in TDataQuery, it must work in Report Workshop as well.
About avoiding using UI
User interface is not necessary, you can create reports in code.
We have several demo projects showing how to create reports in code. For example, for FireDAC, all numbered demo projects in Demos\FireDAC\
I do not understand the problem with reportDocpProperties. What do you mean? There is TRVReportDocObject class, it is required to store document-related report properties, for example a data query applied to the whole document. But using this object directly is not required. For example, you can use RVReportSetRootDataQuery function to define the data query to apply to the whole document.