Home Component Writing
New Blog Posts: Merging Reports - Part 1 and Part 2

Custom SQL Text Editor/Visual Query Builder

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.

Comments

  • 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. :smile:


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • 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?
  • Hi Sergey,

    Thanks for the clarification.

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

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
Sign In or Register to comment.