Restrict Date Parameter Entry

[c8ltgkue]

Hi All

Using CR XI

I have a parameter called 'Period' which has 'allow range value' option on so one can enter two date value in the period parameter. My question is how can I restrict the user entry so that minimum of perid can't be beyond 01/04/2007 ?

Hope this makes sense.

Many thanks in adv for your help.

C8

 

[CR85user]

Can I assume that you DO want to be able to allow a minimum date LATER than 01/04/07?

You could format the report criteria to not retrieve data if earlier than this date and then add a supressed report header based on the start date which shows an error message.

It would be worth adding the default start date as the start of the fiscal year also and add a note OR alternatively consider using two parameters. One for fiscal year and one for a date range from current date.

There are several approaches, it really depends on how your users tend to select their choice of date range. Ask for feedback and then there would be a better way to gear the parameters to suit.

'J

 

[dgillz]

There is no way to restrict the start date except by the LOWEST date that can be entered.

You can as CR85user suggested build login into your record selection formula to display or suppress a message based on this date.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[lbass]

In XI, after you check "allow range values", you can set a lower limit in the area right below that which says "Start" and an upper limit in the area that says "End". Then when the user refreshes the report, if they will see prompt text telling them to enter within that range and also will get an error message if they enter a value outside the range and click OK.

-LB