Enforce both ranges in Date Range parameter

[Former Member]

Hi

Please advise if there is a way by which i can hide the option 'No Lower / Upper Value' in Crystal Reports 2008?

Am trying to accept a date range and the report shows values in between the date range.

Is it that i have to create two parameters for start and End date and i cannot use date range to enforce both the ranges?

Also, please let me know, if i use the 'No Lower / Upper Value' in report how does the report handle that in selecting the records? do we need to code this in record selection to manually handle this case ? how do we mention this in the Record selection?

Please advise.

Thanks & Regards

Sujata Singh.

[Former Member]

Hi Suatha,

You can exclude Min and Max values in record selection like :

currentdate > minimum({?date}) and currentdate < Maximum({?date})

This will give you between values.

Thanks,

Sastry

[Former Member]

Thanks Sastry!

But how to maniplate this when i check the 'No Upper Value' ?

Regards

Sujata Singh.

[Former Member]

Hi Sujata,

When you click on No upper Value options, it will remove the upper value for your date and it works like a single selection.

I don't think you can extract the end date for your date range. or if you know the days between your start date and end date that can be hard coded in the record selection like :

Currentdate < {?date}+7

Thanks,

Sastry

[Former Member]

Aw ok ! So we need to set the value to the other value explicitly.

Thanks Sastry. I will manipulate the code.

Thanks & Regards

Sujata Singh.