I'm trying to put a filter value into a report's .qrp and am having difficulty with the right syntax.
I want to set the filter to take the current date and subtract 120 days from it. The filter is currently set to: Begin Filter FieldName = "[Transaction].Time" FilterOp = reportfilteropbetween FilterLoLim = "" FilterHiLim = "" End Filter
I would like FilterLoLim to be: FilterLoLim = - 120
How can this be accomplished?
It can't. The filter limits are just string tokens that represent special dates - Today, start of month, start of year, a couple of others. You can't perform math on them.
You could use the SelectionCriteria to limit the entire report to the past 120 days:
SelCriteria = " ([Transaction].[Time] >= (dateadd(dd,-120,getdate()))) "
No mater what date range is selected in the filter, the reprot would always be limited to the past 120 days...
Glenn Adams Tiber Creek C> I'm trying to put a filter value into a report's .qrp and am having
Scott,
Modify your filter in the report you memorized to;
Begin Filter FieldName
Have something to add? Share your thoughts — no account required.
Ask the community — no account required