How can I dump the lines of sql generated by a report

rbuser

Please help

How can I dump the lines of sql generated by a report into the on no data
found event of a report - I would like to either display it as a message box
or dump it in a text file.

The reason for this is I am using software to run on of my reports and it
intermitantly shows a No Data Found message - when I expect it to show
results. Would dumping the sql show the Search criteria passed to the
report ?

Thanks

Antony

nardmoseley

1. Simplest solution is to print the autosearch values that were entered by
the user. For an example, see RBuilder\Demos\AutoSearch\Build Description of
AutoSearch Settings

2. The Report.DataPipeline.DataSource.DataSet would provide access to the
sql text. You would need to typecast the DataPipeline as TppDBPipeline and
then typecast the DataSet as a TQuery, TADOQuery or whatever...



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com