Query Help

building reports desktopintelligence
2

I would not create a UDO.
Instead I would create my condition in the data provider as:

Date Between Prompt1 and Prompt2
OR
Date Betweeen Prompt3 and Prompt4

At the report level I would create local report variables using UserResponse to capture the prompt, convert them into data type Dates using ToDate, and then create new measures using the WHERE clause.

For example (pseudocode):

= <Price> WHERE (Date = Prompt1)

For more details on how to use WHERE clauses for measures within Business Objects Reporter (pitfalls and work arounds) see this entry in the Reporter FAQ.

Andreas :de: (BOB member since 2002-06-20)