By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,501 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,501 IT Pros & Developers. It's quick & easy.

condtional display of a page in Oracle Reports

P: n/a
I have a Oracle report which displays a front page every time when a
certain query is run. Now, is there a way to display the front page
only and only when a ceratin parameter say :param='all' is inserted by
the user Otherwise whenever the user enters :param='any other number'
then the front page doesn't get displayed
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Rohit Dhawan" <ro**********@yahoo.com> wrote in message
news:c7************************@posting.google.com ...
| I have a Oracle report which displays a front page every time when a
| certain query is run. Now, is there a way to display the front page
| only and only when a ceratin parameter say :param='all' is inserted by
| the user Otherwise whenever the user enters :param='any other number'
| then the front page doesn't get displayed

are you actually writing a report, or are you studying for an exam?

what have you tried to accomplish this?

;-{ mcs
Jul 19 '05 #2

P: n/a
I am actually working on the Oracle Reports.

When the user enters 'all' than a certain Object is displayed on the
front page Otherwise for other data entered that first Object remain
hidden but all the related data gets displayed from the next page
other then the first page where that hidden Object Exists.

I just want don't want my first page to go blank when someother data
is entered other then 'all' . Can two or more objects be over lapped
such that even if one object remains hidden the object object gets
displayed OR when the object is not supposed to be hidden the data is
still displayed correctly
Jul 19 '05 #3

P: n/a

"Rohit Dhawan" <ro**********@yahoo.com> wrote in message
news:c7*************************@posting.google.co m...
| I am actually working on the Oracle Reports.
|
| When the user enters 'all' than a certain Object is displayed on the
| front page Otherwise for other data entered that first Object remain
| hidden but all the related data gets displayed from the next page
| other then the first page where that hidden Object Exists.
|
| I just want don't want my first page to go blank when someother data
| is entered other then 'all' . Can two or more objects be over lapped
| such that even if one object remains hidden the object object gets
| displayed OR when the object is not supposed to be hidden the data is
| still displayed correctly

you can accomplish this with a format trigger

go to the property palette for the object you want conditionally hidden,
under 'Advanced Layout', click the big fat button next to 'Format Trigger'
in and if/then/else statement, enter a condition under which the object
should be hidden and return false
remember to return true for all other conditions

;-{ mcs
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.