Interested to Buy Any Domain ? << Click Here >> for more details...
in reports 1og.if we enter a query in list of values then
parameter form displays a dropdown.in that if any ething is
selected then that will display in the report.supp if i am
not selected any value then it should display all the
values.how it is possible?can any one help me........
- 1 Answers
- 4295 Views
- I also Faced
- E-Mail Answers
Answer Posted / tech knit
first in the main query add to parameter...
supp :deptnum is parameter
then
query...............where :deptnum or :deptnum is null
and in parameter lovs write query
after writing the query in lovs ..uncheck the check box --
'the restrict list to predetermined values'
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In workflow how can we send a notification to the Supplier giving the Corresponding report Details.
what are bind variables?
what is tripstop report?
In what sequence do triggers get fired by oracle forms?
what is oracle forms?
What is an SQL FORMS ?
why the Ctl file u put only in bin folder why not in other folder
In what situation u create the BPA.
what exactly u write in when_new_form_instance
What is an oracle report? List its various types.
What is a user exit program in oracle reports?
I have a frame that contains headings. This frame is enclosed in side a repeating frame. However the headings are not displayed on all pages it is displayed only on the last page. Please let me know why is this happening. print object on = All pages base printing on = enclosing object
I need a query to list out "Subinventory Transfer" record from Oct 2016 to Oct 2017 for few users
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
What do you understand by oracle forms?
