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
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.