Conditionally formatting a date in Crystal

[dgillz]

I have a cross tab report with a paramter for the columns being Monthly or Daily. Depending upon the value of the parameter, I want to conditionally format the date field in the column.

For monthly, I want to see 'Jun-05', for daily I want to see the entire date '06/09/2005'. I fooled around with this for about an hour and got nowhere. Any ideas out there?

Please no totext() answers, I need to keep this as a date, with conditional formatting.



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

http://www.gainfocus.biz

 

[Naith]

Hi dgillz,

Format your date field using the Customise button. On the date tab, enter the following conditional formulas:

Month

If {?date} = "Daily"
Then 1
Else 2

Day

If {?date} = "Daily"
Then 1
Else 2

Year

If {?date} = "Daily"
Then 1
Else 0

First Separator

If {?date} = "Daily"
Then "/"
Else "-"

Second Separator

If {?date} = "Daily"
Then "/"
Else ""

Have a good weekend,

Naith

 

[MisterMo]

Another option is to have 2 cross tabs

one set by date daily and the other set monthly
with the date field formatted accordingly and in the group option in the cross tab expert you can choose to get the data daily or monthly

place them in separeted section and suppress one or the other according to your input.

Naith solution is good but I don't know if it deals with the grouping options in the cross tab expert.



Mo

 

[dgillz]

Naith,

Worked perfectly in v8.5....I guess I had been staring at this too long!

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

http://www.gainfocus.biz