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
- 4200 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
How can we expand Parameter Form Canvas on Reports 6i?
What is an oracle report?
What is a matrix report and how many minimum groups are required to prepare the same?
Name the different triggers associated with oracle forms having a master-detail relationship.
Is it possible to execute a dynamic sql from forms?
Explain how can you use the same lov for 2 columns?
difference between global n context sensitive segments?
List the different types of columns in oracle reports.
Name the different triggers supported by oracle reports and their firing order.
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
what are bind variables?
what is difference between group above and group left report
If the valueset if of type –TABLE then how many tables can we attach in the valueset ?
Explain how one can iterate through items and records in a specified block?
what are the oracle forms services components include?
