dynamic where clause in reports

I am talking about all parameters user and system.
User can pass some (not all) user parameters, but Report accept ALL PARAMETERS.
------------------------------------------
In user parameter property palette type for each parameter default
(initial) value. then in after_parameter_form trigger u can check this
(default) value with value in :USER_PARAMETER and make desigion,
what u can do in &WHERE lexical variable.

This is way in ur situation.
Methods how u can write ur code in after_parameter_form trigger may be copmpletely defferent.

Sarita,
Please check post No. 6
Thanks

I am doing same thig.
You just constuct sql stament , storing in variable in PL/SQL
e.g.
sql = 'select x, y,z from tab1 where'

if p1 = 'xyz' then
p1cond = 'x = '''|| p1 ||'''
elsif
......

endif;

if p2 = 'p2x' then
p2cond= 'z = '''|| p2 ||'''
end if;

where_clause = p1 || ' and ' || p2

sql_stmt = sql || where_caluse

thanks for the help. I understood to set the dyanamic where clause but for some reasons it is giving me "Invalid column name Ora-00904 . This happens only when I enter value for particular parameter.
Any idea?


Thanks
saritha