Sage 100

I am once again on the Inventory Sales History Report request from an end user: They would like to enter a start/stop date to the report (easy enough to add via parameters). However I'm not exactly sure how to go about this without also duplicating the start/stop year which is part of the report. In essence I think the user would have to enter the date twice - and I wouldn't have any error trapping if they mistakenly enter in conflicting dates. The issue I think that I have (other than this looks like a boatload of if/then): - Sage doesn't seem to exposed any of the parameters from the body of the main report. So therefore I wouldn't be able to read the start/stop year and only prompt the user for start/stop period. Any last thoughts before I tell the user it's a $3,000 report with a requirement to duplicate the date entry and no viable way to error trap for it?

Update: I think I'll sort of work around this by creating a suppress formula for each of the 12 periods. I probably will have to rethink this in terms of totals because suppressed values don't print but they do summarize. Create two parameters: StartDate EndDate For each of the 12 fields on the report I'm either going to suppress them using conditional or create a new formula that reports ""NA"" (or whatever I can stick in there that won't cause an error when summarizing). The user is aware that this won't be a clean cutoff -- meaning your start/end date is defining an entire month. The formula that I tentatively worked out (right now I'm sticking this in a conditional suppression for testing purposes but I suspect I may have to code formulas for each month due to the need to total and suppressed values continue to total which is not what we'd want).: date(toNumber({IM_SalesHistoryWrk.FiscalCalYear}),10,15) < {?StartDate} or date(toNumber({IM_SalesHistoryWrk.FiscalCalYear}),10,15) >{?EndDate} And I'd have to create this formula for each of the 12 columns and change the coded date to advance by one month (so the next column date would use 11 as the month, etc)