Display Month and 12 previous Months

[Former Member]

I am trying to create a report (CRXI) which will display month data for the current month and the 12 previous months. I am going to use subreports (similar to a calendar report) but am having trouble displaying the 12 previous month, year headers.

I get the current month, year from a prompt date and then need to decrease a month for 12 months.

Any help would be appreciated.

[Former Member · Accepted solution]

Hi Martha,

You can create a formula for each month like;;

Month(Dateadd("M",-1,{?ParameterField))

You will get Parameter Inputdate -1 month

Hope this will help you

Thanks,

Sastry

[Former Member]

Hi Martha,

If you want to create a report for last 12 months and don't want to include present month then use the record selection for main report as

(month({DateField}) < month(currentdate)
and 
year({DateField})= year(currentdate))
or
(month({DateField})>=month(currentdate)
and 
year({DateField})=year(currentdate)-1)

and in the subreport use the record selection to get current month date as

(month({DateField}) =month(currentdate)
and 
year({DateField})= year(currentdate))

Regards,

Raghavendra