D2K - How will you pass whole query from Form builder to Report?

GeekInterview.com > Interview Questions > Oracle > D2K

Go To First | Previous Question | Next Question

D2K | Question 28 of 69

How will you pass whole query from Form builder to Report?

Total Answers and Comments: 4

Last Update: September 09, 2008 Asked by: nitin kumat

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 15, 2006 04:20:00

Shantaram D. Ingale

RE: How will you pass whole query from Form builder to...

u can use

get_block_property('blk_name',last_query)

it will return the query executed last in varchar

use instr function to get query from 'where' clause to lexical parameter to report

u can use lexical parameter to listen the where clause from report

Is this answer useful? Yes | No

September 27, 2007 01:14:33

Mital Mehta

RE: How will you pass whole query from Form builder to...

Shantaram, By this you can get Only the Last recent query from the Perticular block ,

But hte here thing is How to Pass Over there ? You can Pass through Parameter and use the lexical paramter andÂ use into the report query

Is this answer useful? Yes | No

May 29, 2008 23:50:21

prasant0661

Member Since: May 2008 Contribution: 4

RE: How will you pass whole query from Form builder to Report?

You can put the query result in temprary table then use it in report

Is this answer useful? Yes | No

September 09, 2008 01:45:18

rajnish2008

Member Since: September 2008 Contribution: 1

RE: How will you pass whole query from Form builder to Report?

You can create a record group using your query in the form. Then you can pass record group as data_parameter to the report. This way query in the report will get replaced by the record group query passed from forms.

Is this answer useful? Yes | No

Go To Top