Anonymous Block - Validating Parameters

Version 1
    This document was generated from CDN thread

    Created by: GREG GREBIN on 19-09-2012 03:30:37 PM
    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?

    Subject: RE: Anonymous Block - Validating Parameters
    Replied by: VARUN Gaur on 13-02-2013 05:52:13 AM
    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.