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?
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?