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

"Rohit Dhawan" <rohit_reborn@yahoo.com> wrote in message
news:c76d1c78.0404201054.c9c9f9@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

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

"Rohit Dhawan" <rohit_reborn@yahoo.com> wrote in message
news:c76d1c78.0404210433.504a577@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