| Please Help Its Urgent...... [message #88720] |
Sun, 16 February 2003 23:27  |
Muzzammil
Messages: 99
Registered: February 2003
|
Member |
|
|
Hi,
I have a report which depends upon parameter form.
I have given LOV which contains all branches name, the report will come for the selected branch only. But I want to put a selection 'ALL branches' and One Selected branch in a LOV and preview report accordingly.
When I have selected one branch it is giving report for only one branch, how to put all branches option through one parameter form.
The statement is
SELECT ITEMCODE,DESCRIPTION,SALE
FROM SALES
WHERE BRANCH=:V_BRANCH;
Kindly Help....
Syed Muzzammil
|
|
|
|
| Re: Please Help Its Urgent...... [message #88721 is a reply to message #88720] |
Sun, 16 February 2003 23:52  |
Ravi
Messages: 251
Registered: June 1998
|
Senior Member |
|
|
Hi Muzzammil,
I think you can do something like this....
in your LOV in report you can write Query some thing like this
select Branch from Sale
union all
select 'ALL branches' From dual;
this will return you in LOV 'ALL branches' Option also.
now inside report query you write.....
SELECT ITEMCODE,DESCRIPTION,SALE
FROM SALES
WHERE BRANCH=Decode(:V_BRANCH,'ALL branches',BRANCH,:V_BRANCH);
Best regards,
Ravi
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
