Crystal Report XI R2 Validate Start Date - End Date

[Former Member]

Hi All,

I want to validate that Start Date is not greater than End Date.

Thanks,

Rick

[Former Member · Accepted solution]

Try to create a date parameter and select the option Allow Range Values as true then it will automatically validates the start date and end date. So if you have two different parameters for start and end dates then try to create only one using this option.

Regards,

Raghavendra

[Former Member · Accepted solution]

Hello Raghavendra,

It's good to setup one parameter if take Range method.

But when we use any parament as range, then the parameter value can't be displayed in the report? (Blank)

Wonder if you can solve the printout of parameter value problem, then it's wonderful to use this kind of parameter, .... because the parameter input window will get shorten than the from-to parameters

Best regards,

Michelle

[Former Member · Accepted solution]

If you want to display the parameter values then try creating formula like

@StartDate:

minimum({?Parameter})

@EndDate:

maximum({?Parameter})

Regards,

Raghavendra

[Former Member · Accepted solution]

Hi, Raghavendra,

Good to know. Very appreciate.

~Michelle

[Former Member]

I and using another approach

[Former Member]

Hi, Rick,

Wonder if your method will get default like "10/1/08" (first day of current month) ~ "10/20/08" (today) ??

That will be better if useful for Store Procedure or Crystal Report , either one.