Home » Developer & Programmer » Reports & Discoverer » Please Help Its Urgent......
Please Help Its Urgent...... [message #88720] Sun, 16 February 2003 23:27 Go to next message
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 Go to previous message
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
Previous Topic: How do I edit the rtf doc created using the oracle reports???
Next Topic: How to print a CHARECTER report in LANDSCAPE format ...?
Goto Forum:
  


Current Time: Fri Mar 29 07:00:21 CDT 2024