suppress subreport based on date

[yolly12]

hello,

I am writing a report in CR8.5 dev and i have a bunch of subreports in the group footer. These reports display sums of row counts based on the creation date

I would like to be able to suppress the months (subreports) that have not occurred yet.

so for my September07 subreport, my supress formula would be if CurrentDate <= '09/01/2007'then ???? else display.

(I need the help on the second part of the formula or am I in the right place to do this?)

thanks

 

[Turkbear]

Hi,
Right click on the subreport and choose format subreport..
In the supress formula tab ( for Sept. as an example) enter

CurrentDate < Date(2007,09,01)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[yolly12]

you are too cool! thanks a bunch!