Shantaram D. Ingale

• Jul 15th, 2006

 

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

Mital Mehta

• Sep 27th, 2007

 

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

prasant0661

 Profile Answers by prasant0661 Questions by prasant0661

• May 29th, 2008

 

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

rajnish2008

 Profile Answers by rajnish2008 

• Sep 9th, 2008

 

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.