Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crystal Report heading showing 2,001.00 instead of 2001?
Message
From
14/02/2002 13:15:15
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Third party products
Miscellaneous
Thread ID:
00620118
Message ID:
00620187
Views:
14
Hi steve,

Are you talking about an object on the report or an item in the group tree ?

For the object on the report, you can format it (rightclick the object, select format field and select the proper format.

For the group tree, you can change the format with file - options, the fields tab and the number button.

Good luck,

Walter,

>Here's my formula in Crystal. It's the last line of the formula that is in question. I have tried Int() and Truncate() and no help. I still get 2,001.00 as the year in my heading. The parameter ?s_date is a Date value that gets entered as a parameter value such as 10/01/2001. Seems simple enough to me. Do you know what's wrong? Thanks for your help.
>
>StringVar HeadingDate;
>
>If Month({?s_date}) = 01 Then
>    HeadingDate := "1st Quarter"
>else
>If Month({?s_date}) = 04 Then
>    HeadingDate := "2nd Quarter"
>else
>If Month({?s_date}) = 07 Then
>    HeadingDate := "3rd Quarter"
>else
>If Month({?s_date}) = 10 Then
>    HeadingDate := "4th Quarter";
>
>HeadingDate + " " + ToText(Year({?s_date}))
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform