Single Input Prompt for multiple objects

building reports webintelligence
1

Hi there,

Can anyone please solve my problem please.

I have the following report data in Web Intelligence.

Type --Count–PM1Date–SU77Date–DR92Date–LF55Date–KR23Date–etc…

Gloves—34—1/1/2014–1/1/2014–1/1/2014–1/1/2014–1/1/2014
Stapes—35—2/1/2014–2/1/2014–2/1/2014–2/1/2014–2/1/2014
Divers----4—3/1/2014–3/1/2014–3/1/2014–3/1/2014–3/1/2014
Fibers—54—4/1/2014–4/1/2014–4/1/2014–4/1/2014–4/1/2014
Screws–31—5/1/2014–5/1/2014–5/1/2014–5/1/2014–5/1/2014

The user selecting all the date field objects as input prompts.

PM1Date between Enter Start Date And Enter End Date
or
SU77Date between Enter Start Date And Enter End Date
or
DR92Date between Enter Start Date And Enter End Date
or
LF55Date between Enter Start Date And Enter End Date
or
KR23Date between Enter Start Date And Enter End Date

The requirement is, the user don’t want to select dates for each object all the time, since the actual report has 55 date fields, is there any way that users select date range for only one object, but the report automatically applies a filter to all the other date field objects??

Can you please provide me some inputs…

Thank you,
Boez.

Boez (BOB member since 2011-12-08)

2

Hi Boes,
One way to manage it is to create a Condition in Designer with @prompt functions. The formula in the Where clause will look like that :

PM1Date between @Prompt(‘Enter Start Date’, ‘D’,{‘2014-01-01’}, mono, free ) And @Prompt(‘Enter End Date’, ‘D’,{‘2014-01-01’}, mono, free )
or
SU77Date between @variable(‘Enter Start Date’) And @Variable(‘Enter End Date’)or
DR92Date between @variable(‘Enter Start Date’) And @Variable(‘Enter End Date’)or
LF55Date between @variable(‘Enter Start Date’) And @Variable(‘Enter End Date’)or
KR23Date between @variable(‘Enter Start Date’) And @Variable(‘Enter End Date’)
…

lvi (BOB member since 2012-02-15)

3

Boez,

I already took the time to answer you here:-
https://bobj-board.org/t/224994

Please don’t cross post

@Ivi, you should @prompt for this, if using a universe solution, not @variable.

Mak 1 :uk: (BOB member since 2005-01-06)

4

Moderator note:
Please do not cross-post. It leads to fragmented discussions and is against our forum rules.

Please continue in the topic linked by Mak 1 above.

Closing this topic.

Marek Chladny :slovakia: (BOB member since 2003-11-27)