having hard time solving this simple Query.
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,
yalamanFinally I fot the solution. hope no one will wonder 2 days for getting sytax
error.
The answer -- there should be even spaces within the Query(I dont know
why?It is with interpreter )
Copy the query in notepad and adjust all the spaces between the Query and
Past it works.
Its is silly
SQL reporting team should address this type of errors.
|
No comments:
Post a Comment