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........
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
What are the Features of Forms 6i over 4.5? What are the Features of Forms 10g? What are the Features of Reports 6i? What are the Features of Reports 10g ?
Name the different triggers associated with oracle forms having a master-detail relationship.
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
how to use buttons,check boxes in paper layout,paper design and paper parameter form in oracle report developer 10g
What is a canvas in oracle forms?
where do u put the report file
What is an oracle report?
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
How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff
Explain how can you use the same lov for 2 columns?
What do you understand by lov and how can it be used?
hiding item in report how like that properly,thats manually but at runtime i want to do
how do u place it in required folder
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
What is an oracle report? List its various types.