Tuesday, July 30, 2013

Handy Crystal Report Snippets

For Formatting Month Name
if ToText({%Month}) = 'Dec' then 'December'
else if ToText({%Month}) = 'Jan' then 'January'
else if ToText({%Month}) = 'Feb' then 'February'
else if ToText({%Month}) = 'Mar' then 'March'
else if ToText({%Month}) = 'Apr' then 'April'
else if ToText({%Month}) = 'May' then 'May'
else if ToText({%Month}) = 'Jun' then 'June'
else if ToText({%Month}) = 'Jul' then 'July'
else if ToText({%Month}) = 'Aug' then 'August'
else if ToText({%Month}) = 'Sep' then 'September'
else if ToText({%Month}) = 'Oct' then 'October'
else if ToText({%Month}) = 'Nov' then 'November'

No comments:

Post a Comment