| Report builder query [message #305075] |
Sat, 08 March 2008 03:09  |
dillango
Messages: 145
Registered: January 2008
|
Senior Member |
|
|
Hi,
Is it possible to pass a report query itself as a parameter from Form?
I have problem to check "where" condition in the query builder.
Say for example, I have defined the user to choose the parameter like "all company or one company", "all departments or one department" etc..
If the user select "all", I need to iqnore the where condtion in report query builder.
Ilango
|
|
|
|
|
|
| Re: Report builder query [message #305183 is a reply to message #305075] |
Mon, 10 March 2008 01:06  |
irfan.ocp
Messages: 29
Registered: February 2008
Location: Karachi, Pakistan
|
Junior Member |
|
|
Dear Ilango
There is One way that you can Defined on your WHERE CLAUSE;
for example
where comp_code = decode(:PARAMETER.COMPANY_CODE, 0, comp_code, :PARAMETER.COMPANY_CODE);
when you enter the 0 in parameter they will get all company codes.
u can also define in your parameter list.
like :-
SELECT comp_code, comp_name from company
union all
select 0, 'ALL' from company
order by 1;
Best Regards
Muhammad Irfan Bakali
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
