Formula for Suppressing a Section by a Date Range

[hgraybill]

I have a report that calculates inventory that was on hand at a certain time. To do this, when selecting a date range the user has to select no lower bound (i.e. "No Lower Bound" to March 1, 2007).

I was looking for a formula to suppress a section in the report by the upper bound that is selected + 11 months. I don't want all the dates to print, I just want it to go back 11 months from the upper bound date the user selects.

I haven't found a way to do this, yet, so I'm just using the following formula that goes back 12 months from the current date.

{INVENTORY_TRANS.TRANSACTION_DATE} <= LastYearMTD

Any help is appreciated or if any clarification of my problem is needed, please let me know.

Thanks!

 

[lbass]

Try:

{INVENTORY_TRANS.TRANSACTION_DATE} <= dateadd("m",11, maximum({?range}))

I'm unclear on exactly what dates you are trying to suppress. This formula would suppress any dates less than 11 months after the end date of your range parameter. You can adjust it to whatever you really mean, if I'm misinterpreting.

-LB

 

[hgraybill]

That is exactly what I'm looking for. Thank you for the help.