I have a report based on a command, where I need to create a parameter which allows a user to enter a month and the report will then use the corresponding period number.
I have added a case statement to the where clause as follows:
WHERE `Results`.`Period` =
CASE {?Month}
where 'Apr' then 1
Where 'May' then 2
where 'Jun' then 3
where 'Jul' then 4
where 'Aug' then 5
Where 'Sep' then 6
where 'Oct' then 7
where 'Nov' then 8
where 'Dec' then 9
where 'Jan' then 10
where 'Feb' then 11
else 12
END
BUT - I keep getting the error "Syntax error (missing operator) in query expression"
I have no idea why - can anyone help???
IP Logged
