How to create a report and dataview in code

rbuser

Hi,

I previously used to build all of my reports in code at runtime from config
stored in the database. I'm currently moving towards the end-user
customisation provided by RB.

I can succesfully create the Report layout and save the template to stream.
I can't figure out how to create a dataview for the report and manually
specify the SQL. Can you help?

Using RB10 pro on Delphi 7 (about to upgrade to RB11)

many thanks

Jo Beaven

nicocizik

Hi Jo,

Take a look at the TdaSQLBuilder class. This gives you the ability to
easily create and edit just about every aspect of a dataview/query in DADE.

First see the help topic on TdaSQLBuilder and relating classes for an
introduction and code examples. Then take a look at the SQLBuilder section
of the rbWiki site for more examples and information.

http://www.digital-metaphors.com/rbWiki/DADE/SQLBuilder

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com