I am trying to add a filter criteria for relative dates on the downloadable CUIC8SummaryTemplates20110311.zip. I have successfully created a SQL query that pull the data that I deem interesting, but when I import this query into CUIC I receive the following error 'Error [10601] The formatting of the grid was not successful"
 
I believe my problem occurs after the copy of the sql query into an anonymous block, create parameters and then create fields. I have a field defined as @RelativeDate and it is not importing as a decimal (interger), rather it imports with next "Select" statement in the data clause for this field.
 
I have attached the sample report. You will need to have CUIC Value List for Relative dates with a value list query:
SELECT 1 AS , 'Today' AS UNION
SELECT 2 AS , 'Yesterday' AS UNION
SELECT 3 AS , 'This Week' AS UNION
SELECT 4 AS , 'Last Week' AS UNION
SELECT 5 AS , 'This Month' AS UNION
SELECT 6 AS , 'Last Month' AS UNION
SELECT 7 AS , 'Year-to-Date' AS UNION
SELECT 8 AS , 'Last Year' AS
ORDER BY ID
Any help with troubleshooting this "grid formatting" error is much appreciated!

Attachments:

With the help of TAC, a solution has been found. From the attached sql query change the following local variable definitions from
SELECT @AbsBegin = :start,
 @AbsEnd = :end,
 @RelativeDate =:RelativeDate

to

SET @AbsBegin = :start;
SET @AbsEnd = :end;
SET @RelativeDate =:RelativeDate;