BusinessObjects Board

Month in report footer in crystal 2011

building reports crystal reports legacy
#1

Hi All,
we have a monthly report which shows the data for last month. now in report footer we want to place report name month; and run date.
i got how to place report name and run date of report but not month as month should be previous month. we are using crystal reports 2011

Is their any formula filed i can use to show month in report footer?

Thanks in Advance

Regards,
Kumar.

pkkumar (BOB member since 2012-07-06)

#2

I assume that you have some sort of date field in the data. You could try something like this:

ToText(Max(table.DateField), “MMM-yyyy”)

This would give you the month in a format like this: JAN-2013.

-Dell

hilfy :us: (BOB member since 2007-04-16)