OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » report parameter (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

report parameter [message #350468]

Thu, 25 September 2008 02:58

aisha_shahbaz
Messages: 9
Registered: September 2008
Location: pakistan

Junior Member

hi
i want to make the report that i give the deprtment number then report create only that department report .
i know that we use the user parameter but i do not know how .
please tell me the steps.now i will make report without wizard ?or with wizard ;
thx

Report message to a moderator

Re: report parameter [message #350508 is a reply to message #350468]

Thu, 25 September 2008 04:30

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Wizard can do the job.

When it comes to the "Query" part of the job, type the SELECT statement and - in the WHERE clause - name a parameter using a colon sign in front of it, such as

SELECT ename 
FROM emp
WHERE deptno = :parameter_deptno

Wizard will automatically create a parameter (you can revise its properties later).

Report message to a moderator

Re: report parameter [message #350513 is a reply to message #350508]

Thu, 25 September 2008 04:40

namakkalsenthil
Messages: 4
Registered: September 2008

Junior Member

First create a parameter in the name you want.

then go to the build parameter

select the created parameter

then write the query as

select * from emp where deptno=:parmater_name;

then you will get the report in such a style you want

Report message to a moderator

Re: report parameter [message #350681 is a reply to message #350508]

Thu, 25 September 2008 21:58

aisha_shahbaz
Messages: 9
Registered: September 2008
Location: pakistan

Junior Member

bundle of thanks

Report message to a moderator

Previous Topic:	Error:Authentication Failed.
Next Topic:	please consult the installation guides for how to set up and run this program

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 15:37:20 CST 2025