What is the datatype of
Quote:
Job_Status
.
Check it and then modify the value according to that. Also
Quote:
'Workshop'
can be replaced with
Quote:
"Workshop"
Pls try and let me know.
and also modify THEN text = "{Sp_Get_DailyReport;1.Department_Name}" to
THEN text := "{Sp_Get_DailyReport;1.Department_Name}" and try