Range Parameter Values

[csunix]

Hi,

I am creating a report to specify details between two dates. To do this I am using one parameter field with a range. The dates the user selects I want to insert into the report title.

In crystal 11 there is a formula to extract the lower bound of the parameter and the upper bound. However in Crystal 10 i am struggling to report the lower and upper bound. Does anyone know the formula, or even know whether the function exists in Crystal 10.

Many thanks

 

[lbass]

If you are just trying to show the selected range in the title, you can use:

totext(minimum({?daterange}),"MM/dd/yyyy") + " to "+
totext(maximum({?daterange}),"MM/dd/yyyy")

CR10 also has the functions "Has lower (or upper) bound" and
"Include lower (or upper) bound", so I'm not sure what you mean.

-LB

 

[dgillz]

Here is a sample formula I recently used:

if not haslowerbound({?Date}) and not hasupperbound({?Date}) then "all dates" else
if not haslowerbound({?Date}) then "All dates thru "&totext(maximum({?Date})) else
totext(minimum({?Date}))&" to "&totext(maximum({?Date}))

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry