HI 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.
Answer Posted / sudipta santra
Yes Dinesh, U r perfect but one question is that is there
any necessity to call another report? If I pass the
parameter from a form of the dept no from user selection
then that parameter can be binded up in query data model
then the report will populate the all empnums of that user
chosen particular dept no.
If am I not wrong, then is it not a easiest method?
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
List the different types of columns in oracle reports.
a text item is there what r the different types of triggers associated with it
What is a canvas in oracle forms?
Why oracle forms required?
how report can be generated if we have the database designed in oracle 10g?
what is tripstop report?
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?
What do you understand by lov and how can it be used?
difference between global n context sensitive segments?
if some data is not transfered where it will get stored
where do u put the report file
what is the difference between call_form, new_form and open_form?
Is it possible to execute a dynamic sql from forms?