Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Displaying Query Text in BIRT Report
Displaying Query Text in BIRT Report [message #719010] Thu, 25 August 2011 15:14 Go to next message
mwagley is currently offline mwagley
Messages: 2
Registered: August 2011
Junior Member
Please bear with me, as I am a newbie Smile

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

Result
08/25/2011

If anyone can help me with this, I'd really appreciate it!
Re: Displaying Query Text in BIRT Report [message #719029 is a reply to message #719010] Thu, 25 August 2011 16:39 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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.

Jason

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
> Result
> 08/25/2011
>
> If anyone can help me with this, I'd really appreciate it!
Re: Displaying Query Text in BIRT Report [message #719038 is a reply to message #719029] Thu, 25 August 2011 17:26 Go to previous messageGo to next message
mwagley is currently offline mwagley
Messages: 2
Registered: August 2011
Junior Member
Awesome help! Thank you so very much! That worked perfectly!
Re: Displaying Query Text in BIRT Report [message #1066291 is a reply to message #719038] Mon, 01 July 2013 21:42 Go to previous message
Beryl Yellow is currently offline Beryl Yellow
Messages: 23
Registered: June 2013
Junior Member
Hi Jason,

If I can put an update sentence in the Query, because I need to update the table before I get the result set as below;

update a set a.column1 = ####;
select * from a;
Previous Topic:BIRT Cross Tab - Columns shrink while exporting to HTML format
Next Topic:Chart labels as computed percentages
Goto Forum:
  


Current Time: Wed Jul 23 12:25:00 EDT 2014

Powered by FUDForum. Page generated in 0.02150 seconds