Home » Developer & Programmer » Reports & Discoverer » Multiple Parameter Handling
Multiple Parameter Handling [message #117270] Tue, 26 April 2005 03:33 Go to next message
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

(Let’s consider my problem with known damobld (scott/tiger) database)

A report having following User Parameter:-

P_1 (to select department #)
P_2 (to select job)

I wish when I select P_1 and then move to P_2.
P_2 only shows jobs which are in selected department of P_1.

i.e. If I select 10 in P_1. P_2 will only shows (MANAGER, PRESIDENT, CLERK)

I code following in P_2 (Parameter List Of Values)
Select all EMP.JOB from EMP
where
EMP.DEPTNO = nvl(P_1, EMP.DEPTNO)

But code won’t compile and give following error give following error in (Parameter List Of Values)

REP-0781: Bind variables are not allowed in the Select statement.

Please advice how to do as if it won’t work it will be foolish to offer other job to user in P_2 + I will not give any report if some one select other jobs.

Wishes
Jawad
Re: Multiple Parameter Handling [message #117286 is a reply to message #117270] Tue, 26 April 2005 05:28 Go to previous messageGo to next message
hsinghalmrt
Messages: 51
Registered: March 2005
Member
use forms as parameter form for report
create parameter list for passing parameters and use run product for calling the report then u can achieve ur goal.

regds,
Himanshu
Re: Multiple Parameter Handling [message #117306 is a reply to message #117270] Tue, 26 April 2005 07:07 Go to previous messageGo to next message
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

Dear Himanshu

Thanks for reply. I am impressed from your broad thinking.
I have done this in this form with help of sequential vols. But even then I don’t prefer such complexities.

Can you or someone else give me a simple solution?

Wishes
Jawad

Re: Multiple Parameter Handling [message #117330 is a reply to message #117270] Tue, 26 April 2005 09:53 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Reports does not really allow (at least to my knowledge) this type of flexibility within its parameter form. The use of a simple custom form in this specific case is probably your best bet assuming that you will be running it in client/server mode (as opposed to WebForms and the internet Application Suite). If you will be registering the form for use on the web, there is another approach you can use that works similarly to the form approach but without the design of a custom form (using descriptive flex field manipulation). But since you haven't stated what you will be doing with the form, I won't assume that this is your environment.

Also, it is important that the end-user understands the application and what they are doing. As a developer you have only so much control with the tools you are given. You (or your boss) has to decide if it is worth the investment of time and resources to filter the second parameter. I have come to find that if the end-user can't use the application or doesn't understand it, it won't matter how well its designed, they will still find a way to screw up the information they are trying to get. I think it is imperative that the user be well-versed (either through documentation or training) in how to get meaningful output from a complex system. You only provide the means to do it.

HTH,
Steve

[Updated on: Tue, 26 April 2005 09:56]

Report message to a moderator

Re: Multiple Parameter Handling [message #117409 is a reply to message #117270] Wed, 27 April 2005 02:19 Go to previous messageGo to next message
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

Dear Steve Corey

Thanks for your advise and for that much time.

My goal was not to restrictions/securities. It is just to make it bug free.
But I am convinced despite spending time on a parameter form. It is easy to teach/literate end user.

Wishes
Jawad

Re: Multiple Parameter Handling [message #117670 is a reply to message #117270] Thu, 28 April 2005 16:05 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Jawad -

I know what you mean about wanting to make the form as simple as possible for the end-user. There are some cases however (this may be one of them) where the resources spent on accomplishing something is just not worth it when you can tell the end user 'Make sure to use VALID combinations. If you combine two values that don't make sense, you won't get the information you are looking for.' That decision is up to either you or your supervisor, I am just offerring an opinion on the situation. If you do need a custom form to do this, I do have examples, so let me know what you want to do.

HTH,
Steve
Re: Multiple Parameter Handling [message #117701 is a reply to message #117270] Fri, 29 April 2005 01:11 Go to previous messageGo to next message
weekend79
Messages: 188
Registered: April 2005
Location: Islamabad
Senior Member

Dear Steve Corey

Thanks for your advise and for that much time once again.

You are right on this occasion doing this is just not worth.

No supervisor. I am beginner work individually & always look for guidance/advice of experts on forums.

Please send me examples as I might get same situation latter on other projects where I can’t afford any half measures.

Wishes
Jawad
Re: Multiple Parameter Handling [message #117799 is a reply to message #117270] Fri, 29 April 2005 11:54 Go to previous messageGo to next message
Steve Corey
Messages: 336
Registered: February 2005
Location: RI
Senior Member
Jawad -

Before I give you the custom form example of how to call a report from forms, I'll need to know a couple of things, so please private message me with the following information:

 1.  Oracle Database Version (10g, 9i, 8i, etc.)
 2.  Developer Suite Version (6i, 9i, etc)
 3.  Whether or not you are using the ERP modules (aka WebForms
     user-interface)


Steve
Re: Multiple Parameter Handling [message #122423 is a reply to message #117270] Mon, 06 June 2005 08:19 Go to previous messageGo to next message
rockysh
Messages: 4
Registered: June 2005
Junior Member
Hello,
Thanks for the input. It was very usefull to me.

I would like to know is it possible to pass a dynamically created select statement to replace the query of the report ?. I tried DATA_PARAMETER in RUN_PRODUCT, but this requires the column/data match with the report query and the record_group query.

I am trying to build a form where the user will be able to select the columns he wants from the displayed data and print using reports.

All help will be greately appreciated.

Cheers
Re: Multiple Parameter Handling [message #243222 is a reply to message #117270] Wed, 06 June 2007 08:47 Go to previous messageGo to next message
winnie_e
Messages: 2
Registered: April 2007
Junior Member
hello i know that this topic is so old but do you now a solution for this problem.
i am having the same trouble in my reports too.
how can i solve it.
i don't want my end user to use a form for it.
Re: Multiple Parameter Handling [message #337498 is a reply to message #243222] Thu, 31 July 2008 01:51 Go to previous messageGo to next message
rakhatmis
Messages: 25
Registered: March 2008
Junior Member
hello all

i know this message is very old but can anyone tell me the solution for this problem as i am also facing the same problem of multiple parameter handling. if anyone knows the solution, please help me
Re: Multiple Parameter Handling [message #337508 is a reply to message #337498] Thu, 31 July 2008 02:13 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
A working solution has been suggested by Hsinghalmrt - create your own parameter form using Forms Builder; it will allow you to create List of Values which can be dependent on a previously selected value.

However, one of our members (not very active one, though) has said that he/she managed to do that in Reports Builder, using Java code. As he/she never bothered to post the whole solution (although people did request it), along with me being unable to produce any kind of Java code - sorry.
Previous Topic: Calling a procedure from Oracle Discoverer
Next Topic: unexcepted: java.lang.runtime execption error in Discoverer
Goto Forum:
  


Current Time: Wed Dec 07 22:34:10 CST 2016

Total time taken to generate the page: 6.24155 seconds