Hi folks,
I have a NetWebForm that I use to capture a FromDate and a Todate.
I have a button on that same Netwebform that calls a Report.
This is my Report filter.
ORD1:ClientID=LOC:Client_ID and ORD1:OrderDate >= LOC:FROMDate AND ORD1:OrderDate <= LOC:ToDate
I've checked that I have valid Clarion dates in both LOC:FROMDate and LOC:ToDate after capturing it in code at the following embed point:
Prime Report Options When run in Web mode:
Loc:FromDate = p_web.dformat(p_web.GetValue('FromDate'),p_web.site.DatePicture) !Set Date variables
Loc:ToDate = p_web.dformat(p_web.GetValue('ToDate'),p_web.site.DatePicture)
This filter fails the first time I run the report. If I cancel the pop up Report viewer window, and re-run the report without changing the two date range fields on the Initial NetWebForm, the filter works fine.
Why would this report filter work the second time, and not the first?
ORD1:ClientID=LOC:Client_ID and ORD1:OrderDate >= LOC:FROMDate AND ORD1:OrderDate <= LOC:ToDate
Suggestions
Brian
NT5 PR26
6.3 9055