Default date ranges vs parameter date ranges 3

[ABerkowicz]

Hello.

I am using Crystal 8 - the web component. I had a request from one of my co-workers that I need some help solving. I have a report that prompts the user to enter starting and ending dates in a report. Is there a way to keep this option but have a default value = to the last 8 weeks (based on current date) appear if nothing is entered for the date parameter?


Thanks for any insight that you can provide.

 

[kenhamady]

You could have an additional parameter field that says "select last eight weeks?" that offers yes or no.

Then your selection formula could be an if-then-else:

If {?8wks} = 'YES'
then {date} in CurrentDate - 56 to CurrentDate
else {date} in {?Start} to {?End}

Or you could have the Start date be an unused date (like 1/1/1) and use the same logic:

If {?Start} = Date(1,1,1)
then {date} in CurrentDate - 56 to CurrentDate
else {date} in {?Start} to {?End}

Warning, using if then else in the selection formula will usually slow performance. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[ABerkowicz]

Thank you. This worked!