Can you please help me correct this statement!!
Cast (([Report View].[Eye Charts].[YEAR] -1) ,varchar)
with this i have to conacatenate a text value
Assuming the [YEAR] data item contains something like 2011 to represent a year, and is a numeric field (therefore worthy of subtraction), I'd suggest the following:
Cast ( ([Report View].[Eye Charts].[YEAR] -1) , VARCHAR(4) )
To concatenate:
Cast ( ([Report View].[Eye Charts].[YEAR] -1) , VARCHAR(4) ) + ' was a very good year'