I am using ReportBuilder as the report tool in my application. On many Report Filter screens, the user can set a variety of parameters that they want to limit the report by. In the TOracleDataSet I have several variable set up and in the code I use the .SetVariable method to set the variable.

If I step through the app I can get the SQL statement (using Debug - Evaluate/Modify) but it has not translated the variables. For example what I see is
Select * from mytable
where mycol = :VAR_MYCOL

What I would like to be able to do is see the SQL statement after the translation has occured so what I would see is
Select * from mytable
where mycol = 'CAT'

I am trying to debug a complex report that was written by a person no longer at the company and they are using 6 Substitution variables along with 8 standard string or number variables.

Thanks for any help you can provide

Richard Anderson