Home » Developer & Programmer » Reports & Discoverer » from 000 to 999 parameter
from 000 to 999 parameter [message #222399] Sat, 03 March 2007 22:22 Go to next message
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.
Re: from 000 to 999 parameter [message #222424 is a reply to message #222399] Sun, 04 March 2007 10:07 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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 ...
Re: from 000 to 999 parameter [message #222432 is a reply to message #222424] Sun, 04 March 2007 13:48 Go to previous messageGo to next message
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.
Re: from 000 to 999 parameter [message #222436 is a reply to message #222432] Sun, 04 March 2007 14:44 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: from 000 to 999 parameter [message #222438 is a reply to message #222436] Sun, 04 March 2007 15:47 Go to previous messageGo to next message
pbills
Messages: 40
Registered: February 2007
Member
What if I wanna create a page break after every goup?
Re: from 000 to 999 parameter [message #222446 is a reply to message #222438] Sun, 04 March 2007 19:26 Go to previous messageGo to next message
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.
Re: from 000 to 999 parameter [message #222483 is a reply to message #222446] Mon, 05 March 2007 02:27 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: from 000 to 999 parameter [message #222887 is a reply to message #222483] Tue, 06 March 2007 19:26 Go to previous messageGo to next message
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.
Re: from 000 to 999 parameter [message #222924 is a reply to message #222887] Wed, 07 March 2007 00:03 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: from 000 to 999 parameter [message #223168 is a reply to message #222924] Wed, 07 March 2007 20:00 Go to previous messageGo to next message
pbills
Messages: 40
Registered: February 2007
Member
Hello,

Thank you for all your help.

Every thing is working and my report is as per the client requirement.

Thank you.
Avi.
Re: from 000 to 999 parameter [message #223196 is a reply to message #223168] Wed, 07 March 2007 23:53 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Great! I'm glad you did it!
Previous Topic: XML publisher/Check printing
Next Topic: proper paging
Goto Forum:
  


Current Time: Sat Dec 03 20:10:20 CST 2016

Total time taken to generate the page: 0.10055 seconds