Home » Developer & Programmer » Reports & Discoverer » report parameter  () 1 Vote
report parameter [message #350468] Thu, 25 September 2008 02:58 Go to next message
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
Re: report parameter [message #350508 is a reply to message #350468] Thu, 25 September 2008 04:30 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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).
Re: report parameter [message #350513 is a reply to message #350508] Thu, 25 September 2008 04:40 Go to previous messageGo to next message
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

Re: report parameter [message #350681 is a reply to message #350508] Thu, 25 September 2008 21:58 Go to previous message
aisha_shahbaz
Messages: 9
Registered: September 2008
Location: pakistan
Junior Member
bundle of thanks
Previous Topic: Error:Authentication Failed.
Next Topic: please consult the installation guides for how to set up and run this program
Goto Forum:
  


Current Time: Sat Dec 03 06:02:13 CST 2016

Total time taken to generate the page: 0.10427 seconds