in report builder am creating paramters.for that i have
taken emp table from scott user .
in deptnum am displaying distinct deptno.if i select dept
10 ,empnum drop down should display empno's of deptno 10.
.if i select dept 20 ,empnum drop down should display
empno's of deptno 20.for this wat i have to do.
Answers were Sorted based on User's Feedback
Answer / raghav
first create a sql query in the data model like below
select empno from emp no where deptno=:p_deptno.run the
|Is This Answer Correct ?||0 Yes||0 No|
What is the use of Printer Definition file (PRT) in Reports ?
What are built-ins associated with timers?
what is integrity n how many integrity rules r there?
Can a formula column refered to columns in higher group?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
What is difference between open_form and call_form?
How can you format a character field in a report Layout editor ?
why the Ctl file u put only in bin folder why not in other folder
I want to learn the Oracle configurator(OracleApps)can any one tell best institutes in Hyderbad
What is the use of break group?
i have a repeating frame that prints on every page for a product code. But when on page ends the info associated with that product code is truncated and not overflowed to the next page.On the next page data with the new product code is displayed. I want the data for one product code to be continued on the next page if it does not fit on a single page. The values are as: repeating frame vertical = variable horizontal = variable page protect = 0 print object on = first page base printing on = enclosing object for the outermost frame which encloses the repeating frame: print object on = last page base printing on = anchoring object end of layout section = yes rest all the values are same as the repeating frame
List out the oracle forms configuration files?