Parameter Value - Date Range Query 1

[ChrisBelzona]

Hi

I've just noticed that in Crystal 8.5 you can create a parameter with date format and select a range values - when I run the report a parameter prompt appears asking for the Start and End Date.

My question is how do I refer to these two values from the 1 parameter?

I'm looking to to create a formula where the a field Date is between Parameter Start and End range.

Any help would be great thanks?

 

[GJParker]

You need to use the IN operator i.e.

{Table.Date} IN {?DateRange}

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[ChrisBelzona]

Thanks Gary

Very prompt

 

[GJParker]

Glad to help

Gary Parker
MIS Data Analyst
Manchester, England

 

[ChrisBelzona]

Gary

The next step for this is of course puting the range in a report title field - can you assist here also.

Thanks

Chris

 

[GJParker]

Create yourself 2 formulas

Minimum({?DateRange})

and

Maximum({?DateRange})

There's a very good FAQ on this topic FAQ767-1206.


Gary Parker
MIS Data Analyst
Manchester, England

 

[fallsr]

http://support.businessobjects.com/library/kbase/articles/c2002512.asp

shows a couple of ways to get your parameter with both of its values to display.