Hiding columns on a trend report

Hello, I'm new to this community and was hoping to find somebody that can answer a quick question.  I have written a couple of Sage Intelligence trend reports using Sage 100 database and I can't seem to be able to figure out how to not print months that are past the month in the parameter that I set up. For example, if I'm asking for a Feb 2017 report, my columns for the rest of the calendar year will still show and I don't want to show those. I was able to figure out how to make those columns zero but I also want to suppress them based on my parameter. Any ideas? Any help would be greatly appreciated.

Parents Reply Children
No Data