Contact Center Reporting

« Back to Contact Center Reporting

RE: Anonymous Block - Validating Parameters

Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
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?

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.