To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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>