Absence Report with Between Dates
Summary
Report not workingContent
Hi,
I have attached the XML for this absence report, can anyone work out why it won't run?
I've tried different combinations in the criteria page with Prompted data filters as well as Between As, Greater than and less than start and end dates - they all fail for some reason.
I'm using the following date parameter code:
SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}{@{system.currentTime}[YYYY-MM-DD]}';
Thanks,
Andrew
Version
19DCode Snippet
<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <saw:criteria xsi:type="saw:simpleCriteria" subjectArea=""Workforce Management - Absence Real Time"" withinHierarchy="true"> <saw:columns> <saw:column xsi:type="saw:regularColumn" columnID="c1b2673846263e854"> <saw:columnFormula> <sawx:expr xsi:type="sawx:sqlExpression">"Worker"."Person Number"</sawx:expr></saw:columnFormula> <saw:displayFormat> <saw:formatSpec wrapText="true" suppress="suppress"/></saw:displayFormat>
0