Hi,
I'm using forms and reports 6i.
I'm trying to call a report through form.
Right now the report query is
Select tt1,tt2,tt3,tt4 from table1
The where clause which i should apply in the query is generated at the runtime from the forms.
Like i've a tree in the form , based on the selected node i'll form a where clause and that is to be passed to the report and applied.
Say based on the node, the where clause i form before calling report is
(tt1='1' and tt2='x') or (tt2='y' and tt4='any')
This i should apply in report query and the report should now run for the query
Select tt1,tt2,tt3,tt4 from table1
Where (tt1='1' and tt2='x') or (tt2='y' and tt4='any')
Please help
Thanks