Date Presentation Variable
Summary
Date Presentation VariableContent
Hi,
Can we have Date Presentation Variable passed to a report for a filer of date range. I dont want to use the between in parameter.
Currently I am trying to run this report from Dash Board and getting below error :
View Display Error | |
Error getting drill information: SELECT "Worker"."Person Number" saw_0, "Worker"."Employee First Name" saw_1, "Worker"."Employee Last Name" saw_2, "Absence Type"."Absence Type Name" saw_3, "Assignment Absences Details"."Approval Status" saw_4, CAST ("Assignment Absences Details"."Date Start" as DATE) saw_5, CAST ("Assignment Absences Details"."Date End" as DATE) saw_6, "Assignment Absences Details"."Duration" saw_7, "Absence Reason"."Absence Reason Name" saw_8, "Assignment Absences"."# Of Absences" saw_9, "Worker"."Employee Name" saw_10, DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Assignment Absences Details"."Approval Status") saw_11 FROM "Workforce Management - Absence Real Time" WHERE ("Absence Type"."Absence Type Name" = 'Sick Leave') AND (("Assignment Absences Details"."Duration" >= '28') OR ("Assignment Absences"."# Of Absences" = 3 AND "Assignment Absences |
Tagged:
1