Using the Worshop demo

A reporting tool based on TRichView
Post Reply
makina
Posts: 6
Joined: Wed Sep 13, 2017 8:17 pm

Using the Worshop demo

Post by makina » Wed Nov 08, 2017 2:17 pm

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.

Sergey Tkachenko
Site Admin
Posts: 13637
Joined: Sat Aug 27, 2005 10:28 am
Contact:

Re: Using the Worshop demo

Post by Sergey Tkachenko » Wed Nov 08, 2017 8:56 pm

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.

Post Reply