Custom SQL Text Editor/Visual Query Builder

ssmagin

Hello,

Can you point me to the documentation how can I add a custom facility to let end-users edit SQL queries in the report designer? Basically, all I need is an event handler that will be fired when customer requests to edit a query. In this handler, I must get the current SQL text, display a dialog in which my query will be edited and pass the new/modified SQL query back to the report builder. Is it possible to do in Report Builder or is there a better way of integrating my text/visual SQL editor into the report designer?

Delphi: RAD Studio 10.2.3, Report Builder version: the latest, OS: Windows, Printer: doesn't matter.

Thank you in advance for prompt response.

nardmoseley

HI Sergey,

RB includes built-in query tools.

RB cannot be used to build a query tool or a reporting tool. That is a violation of the license.

ssmagin

Thank you, Nard.
Possibly I explained my question not very well.

I don't want to use RB to build a query tool, I don't have an intention to violate RB license.

I just I don't like the built-in "query tools" and I want to replace them with my custom SQL query builder. Is it possible?

nardmoseley

Hi Sergey,

Thanks for the clarification.

The RB Data workspace is tightly coupled and is not open to integration.