OraFAQ Forum: Reports & Discoverer » from 000 to 999 parameter

Home » Developer & Programmer » Reports & Discoverer » from 000 to 999 parameter

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

from 000 to 999 parameter [message #222399]

Sat, 03 March 2007 22:22

pbills
Messages: 40
Registered: February 2007

Member

Hello I created a custom-gl report with department and period as parameters.but user want to selet not onlu one department but in a range of departments. for example from department numbet 000 to 999 depatment.

What should i do for this.
Can some one plz send some exaple.

Thanks in advance

Avi.

Report message to a moderator

Re: from 000 to 999 parameter [message #222424 is a reply to message #222399]

Sun, 04 March 2007 10:07

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

Senior Member
Account Moderator

Create two parameters: PAR_DEPT_FROM and PAR_DEPT_TO (whose value should be larger than the first parameter's value) and use them in query as

... WHERE deptno between PAR_DEPT_FROM and PAR_DEPT_TO
      AND ...

Report message to a moderator

Re: from 000 to 999 parameter [message #222432 is a reply to message #222424]

Sun, 04 March 2007 13:48

pbills
Messages: 40
Registered: February 2007

Member

hey,

It worked.Thank you
I have one more question regarding this.

I want report out to be as follows.

deptnum name account
122 x 123
etc

deptnum name account
123 y 123
etc

each department should have heading...

thanks

Avi.

Report message to a moderator

Re: from 000 to 999 parameter [message #222436 is a reply to message #222432]

Sun, 04 March 2007 14:44

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

Senior Member
Account Moderator

Create a break group on department and put all column labels into a department heading section.

Report message to a moderator

Re: from 000 to 999 parameter [message #222438 is a reply to message #222436]

Sun, 04 March 2007 15:47

pbills
Messages: 40
Registered: February 2007

Member

What if I wanna create a page break after every goup?

Report message to a moderator

Re: from 000 to 999 parameter [message #222446 is a reply to message #222438]

Sun, 04 March 2007 19:26

pbills
Messages: 40
Registered: February 2007

Member

hey I am trying to do this....

I created repeating group with dept number and also trying to put the old repeating frame also in this.

But don't know wt setting i have to do to make old repeting fame sit in the new repeating from..i.e when i see in datamodel i am unable to see old repeating from in the new one.
I am trying to play with send to front... move to back and all..

Avi.

Report message to a moderator

Re: from 000 to 999 parameter [message #222483 is a reply to message #222446]

Mon, 05 March 2007 02:27

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

Senior Member
Account Moderator

Make sure you've made a good model in Data Model. Then delete all you have in Paper Layout and, using Report Wizard, draw a new layout. Let Oracle do the job. It will look ugly, but will place every object into its place.

If you start to mess up with frames moving them back and forth, you're about to, well, mess things up.

Report message to a moderator

Re: from 000 to 999 parameter [message #222887 is a reply to message #222483]

Tue, 06 March 2007 19:26

pbills
Messages: 40
Registered: February 2007

Member

Hello,

In the report I have dept_from and dept_to user parameters.

But it should be always dept_from< dept_to

Where should I write this condition ,in report or should I write in APPs

Avi.

Report message to a moderator

Re: from 000 to 999 parameter [message #222924 is a reply to message #222887]

Wed, 07 March 2007 00:03

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

Senior Member
Account Moderator

As far as I can tell, it is not possible to lookup one parameter's value regarding to another ones. For example, you can't put something like this into the SELECT statement of the List of Values for 'dept_to' parameter:

SELECT dept_number
FROM some_table
WHERE dept_number > :dept_from

It could be checked in the AFTER-PARAMETER-FORM trigger (but that's kind of too late, isn't it?).

That's why people develop their own "parameter forms" (using Forms Builder, for example) where they have better control of parameter values.

Report message to a moderator