Crosstab help with suppress

[fmrock]

Hey Everyone,

I have a cross tab that has Jan-Dec as the column headers and years as the rows.

However, my data comes back with Jan 2011-Mar-2012. But Apr-Dec 2012 still show zeros. I do not want to suppress zeros, because I could have real zero values in my data. I only want to suppress data if the Month and year is greater than my end date in my report (AKA future dates...)

Any ideas or suggestions?

 

[fmrock]

I figured out this will supress the whole row

GridRowColumnValue("@Year") = "2012"

I want to suppress 2012 and everything after March....

 

[fmrock]

This works...

GridRowColumnValue("@Year") = replace(totext(year({SPNAME;1.EndDate}),0),",","")
AND GridRowColumnValue("SPNAME;1.Month_Name") > month({SPNAME;1.EndDate})