GREG GREBIN:
Is there a guide document (or best practice) example for the syntax used in Anonymous Block reports? I'm trying to declare a couple variables and then call a stored procedure. I can't get passed the "Create Parameters" error message "The parameters creation failed. Please try again". Is there a log that shows why the parameter creation failied?
Hi Just declare like this in Anonymous Block
CTHH.CallTypeID IN (:Call_Type)
or
@sDateRange AS CHAR(1)
SET @sDateRange = :daterange
Use either Anonymous Block in Query Type while designing
or Use Store Proc.
