I am using the following Query in reporting services with sp1 installed .

="SELECT {[Measures].[Calls Handled],[Measures].[Transfer In
Calls],[Measures].[Transfer Out Calls]} on Columns,
NONEMPTYCrossjoin([DestinationDim].[Destination Site
Desc].members,[DestinationTetraGraph].[Destination Tetra Graph Desc].members)
on rows
from

ICMDestinationService where "+Parameters!period.value+""

When i give the parameter it is executing correctly.

When I pass the parameter the resulting

The error i am getting is

An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Query execution failed for data set 'Site_Dim'. (rsErrorExecutingCommand)
Get Online Help
Syntax error, expecting FROM, near: 'ICMDestinationService where
[TimeDim].[All TimeDim]

when i pass the same string without parameters i am getting the results.

Any Idea's or help will be Appreciated.

Thanks
yalaman