Create a New Special Field

[madcrystal]

Is it possible? Alternatively, a formula field that's persistant throughout the main and sub reports? I'm looking to calculate the previous month from the current date and not have to re-create again and again. The formula is not reliant on query data.

 

[fisheromacse]

create a formula using a shared variable (#1) to pass the value to a subreport or you could be rid of the variable and just create the same formula in both main and sub-reports (#2):

#1
//{@currmonthsvar}
shared numbervar cmo := (month(currentdate))-1;

#2
//{@currmonth}
(month(currentdate))-1;

 

[lbass]

You could use:

month(dateadd("m",-1,currentdate))

"month(currentdate)-1" would fail for January dates.

-LB

 

[fisheromacse]

doh! thanks for the correction lbass!