473,320 Members | 1,922 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Paramter Form Builder in Oracle Report Builder 6i

2
Hi All,

In Parameter form of Oracle Report Builder 6i, suppose there are two input fields (each showing drop down list) input1 & input2. Can we write a query or rather link these two inputs fields using a query such that the input2 drop down list value changes according to the input1 value given by the user at runtime?

Kindly let me know if this is possible..if yes then what is the procedure to do the same.

I guess its not possible but then too can anybody please confirm this?

Thank you.

Regards,

Divya
Mar 18 '09 #1
3 8140
amitpatel66
2,367 Expert 2GB
YES it is possible. You should have written SELECT query for the List of Values for both the parameters right? For the second parameter, did you try using the previous parameter P_1 in the WHERE Condition?
Mar 19 '09 #2
DivyaV
2
Hi Amit,

Thanks for replying..

Yes i tried using input1 parameter in the where condition of input2 parameter's select query...but since input1 is a bind variable which acquires value only during runtime it dint allow me to do so.

Reg

Divya
Mar 19 '09 #3
amitpatel66
2,367 Expert 2GB
If you are going to register a report in oracle applications then you can add such Filter between input parameters using a VALIDATION SET.
Mar 20 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: AKHTAR ALI | last post by:
Hello all, In oracle Report Builder 6i in the parameter form we want selected value from one parameter list of values to be passed on to the Where condition of the query for the second parameter...
8
by: EddieTH | last post by:
Hello everyone, I am new to this forum so I'll give my greetings to everyone! I am using oracle forms builder and reports builder for 1 year now and I have a problem I cannot seem to be able to...
0
by: sco | last post by:
Hi,i'm usine oracle 10g and im working on form and report on oracle 10g..how pass value from a textbox in form to report?i have already do the link from form to report but i just can;t pass a...
0
by: nirmaljanak | last post by:
Hello Experts, I am using Oracle Report Builder 10g for creating reports. I am saving all reports in JSP format. when I run it withing report builder it works fine. I want to enclose this JSP...
1
by: gowthams123 | last post by:
Dear All, Plz help me with this oracle form builder installation? I have installed SQL *PLUS Release 9.2.0.1.0 and then installed form builder 9.0.2.7.0. When i enter the following username...
3
by: MAHMAD337 | last post by:
Hi all, I want to declare a global variable in my report (build in oracle report builder). can any one tell what is the procedure to declare a global variable in oracle report builder. bye;
4
by: tatipellinaresh | last post by:
Hi, I am using Oracle Reports builder for reports. I have one pie graph in my report. It contains 3 fields like lastmonth, lastweek, today. what I want to do is, when I click on a field it should...
1
by: tatipellinaresh | last post by:
Hi, I am using reports builder for generating report. In my report iam sending parameters from one jsp to other jsp. In the second jsp parameters are coming good, when iam printing ...
0
by: husseinmdehj | last post by:
Hi everyone, can any one help to find solution to the explained below issue we upgrade our database from oracle 9i to 10g with application work in oracle form 5 the menu and everything works fine...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.