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
- 4176 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Explain the various types of oracle report?
How many Flexfields are there in AR and what are they ?
what exactly u write in when_new_form_instance
what is tripstop report?
What built-in is used for showing the alert during run-time?
How can a break order be created on a column in an existing group?
BY SELECT * FROM EMP QUERY ,I GENERATED ONE REPORT.AND SUPPOSE THAT I HAVE 10 PAGES OF OUTPUT. WHAT I WANT IS ,I WANT TOTAL PER EACH PAGE.OK I GOT THAT AND THAT SHOULD BE FORWARDED TO NEXT PAGE AND NEXT PAGES TOTAL SHOULD BE DISPLAYED
How many pages you can in a single form ?
What is a radio Group?
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
suppose u have been seven tables based on that u have to create a report u don't have access to db. then how do u find the relation between tables
What is pop list?
Oracle General 
