Take a look at the attached example. One expression shows how to get
the query definition and the other shows a script in the afterOpen to
get the executed query.
On 8/25/2011 3:14 PM, mwagley wrote:
> Please bear with me, as I am a newbie :)
> Is there an easy way of displaying the Query Text along side the results
> in a BIRT report?
> For example, I have a Dataset called "A1". For example, I am using the
> following SQL Query to create the data set:
> "select trunc(sydate) from dual"
> In the final report, I want to see something like this in a GRID:
> Query Text select trunc(sysdate) from dual
> If anyone can help me with this, I'd really appreciate it!