Anonymous Block - Validating Parameters

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode
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.
 

Attachments

    Outcomes