Multiple input parameter selection in the report

[Anu1284]

Hi,

My requirement is to run a report through 2 input parameters.

Parameter 1: Begin Date
Parameter 2: Either Department ID or Dept Level 2 ID.

I'm working on BO full client ver 5.1.7.

When I try to run the report given this condition, I get the input parameters dialog box. If I enter the begin date and the department ID, the "OK" button is not enabled. Only if I enter the dept level 2 ID, the "OK" button is enabled.

How can the following be achieved?

i.e., 1) Begin Date or Department ID or
2) Begin Date or Dept Level 2 ID.

Please let me know the approach?

 

[skrandel]

You cannot do optional prompts in BO. You have to fill them in.

However, you can do some clever things using pre-defined conditions. I'm not sure how you would do this with dates, but it can't be much different.

Here is an example:
-------------------------
This is a sample of the SQL that can be used in a pre-defined condition
to accomplish "1, many or all" functionality. You don't need to do this
if it's 1 or all. You can simply use the "matches pattern" operator.
Unfortunately, matches pattern doesn't work if the user wants to enter
several items.

(PER_JOBS.ATTRIBUTE3 IN @Prompt('Enter Employee Survey Code(s) ("ALL" for
all)','A','Job Information\Add. Job Details Survey Code',multi,free) OR
'ALL' IN @Prompt('Enter Employee Survey Code(s) ("ALL" for all)','A','Job
Information\Add. Job Details Survey Code',multi,free) OR
'All' IN @Prompt('Enter Employee Survey Code(s) ("ALL" for all)','A','Job
Information\Add. Job Details Survey Code',multi,free) OR
'all' IN @Prompt('Enter Employee Survey Code(s) ("ALL" for all)','A','Job
Information\Add. Job Details Survey Code',multi,free) OR
'*' IN @Prompt('Enter Employee Survey Code(s) ("ALL" for all)','A','Job
Information\Add. Job Details Survey Code',multi,free) OR
'%' IN @Prompt('Enter Employee Survey Code(s) ("ALL" for all)','A','Job
Information\Add. Job Details Survey Code',multi,free))


Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com