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
where do u put the report file
What do you understand by lov?
What are the various configuration files that are used by oracle forms?
what is a package n what r the packages availbla in report
What is the difference between flex mode and confined mode?
i am having a report Jan to Dec are the columns if the present month is Mar only Mar to Dec columns should appear in report output
In what situation u create the BPA.
if some data is not transfered where it will get stored
Name the different triggers supported by oracle reports and their firing order.
what are the oracle forms services components include?
Can we invoke one form from another in a multi-forms application?
in after report trigger if you don't write Srw.user_exit(Fnd_user exit) what it will do it will stop report execution or it will just not free the memory
can you convert or reverse engineer a fmx back to a fmb file?
What is an SQL FORMS ?
What is the difference between bind and lexical parameter?