SSRS_Report issue
i have one issue
just i run the report it shows that query execution failed for dataset 'Top5Distributors' and parser: the end of the input was reached
like this it is showing but dataset query is executing fine i dont understand y it is showing again like this
this is the query
SELECT
-- NON EMPTY
{[Measures].[Current]} ON COLUMNS
,--NON EMPTY
{
[Date].[Calendar].[Date].ALLMEMBERS*
[Distributor].[Distributor Group].[Branch].ALLMEMBERS
-- [Distributor].[Distributor Group].[Branch].ALLMEMBERS --Need To Test
}
DIMENSION PROPERTIES
MEMBER_CAPTION
,MEMBER_UNIQUE_NAME
ON ROWS
FROM
(
SELECT
StrToSet
(@SaleType
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
-
{[Key Account].[Key Account].&[-7],[Key Account].[Key Account].&[-9] } ON COLUMNS
FROM
(
SELECT
StrToSet
(@KeyAccountKeyAccountSection
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
-
{[Distributor].[Distributor Group].[Branch].&[-7],[Distributor].[Distributor Group].[Branch].&[-9]} ON COLUMNS
FROM
(
SELECT
StrToSet
(@MeasureTypeMeasureType
,CONSTRAINED
) ON COLUMNS
FROM
(
SELECT
{
[Analysis].[Analysis].&[2]
} ON COLUMNS
FROM
(
SELECT
StrToMember(@DateCalendarEnd) ON COLUMNS
FROM [Premium APE]
)
)
)
)
)
)
)
WHERE
(
[Analysis].[Analysis].&[2]
,IIF
(
StrToSet
(@MeasureTypeMeasureType
,CONSTRAINED
).Count
= 1
,StrToSet
(@MeasureTypeMeasureType
,CONSTRAINED
)
, [Measure Type].[Measure Type].CurrentMember
)
,IIF
(
StrToSet
(@KeyAccountKeyAccountSection
,CONSTRAINED
).Count
= 1
,StrToSet
(@KeyAccountKeyAccountSection
,CONSTRAINED
)
,[Key Account].[Key Account Section].CurrentMember
)
,IIF
(
StrToSet
(@SaleType
,CONSTRAINED
).Count
= 1
,StrToSet
(@SaleType
,CONSTRAINED
)
,[Sale Type].[Sale Type].CurrentMember
)
)
CELL PROPERTIES
VALUE
,BACK_COLOR
,FORE_COLOR
,FORMATTED_VALUE
,FORMAT_STRING
,FONT_NAME
,FONT_SIZE
,FONT_FLAGS;
could you please help me thank you
May 26th, 2011 12:18pm
Hi Bandlamudi123,
I am not sure the version of the SSRS that you are running. The error "Parser: The end of the input was reached." means that in parsing, the parser reached the end of chunk of text without encountering a delimiter that it was looking for.
Generally, I would suggest you,
1, Try reducing complexity of your query and see which part is giving your trouble.
2. Tested the query without the parameters.
3. Or tested the query by providing a default value to those parameters.
If you have any question, please ask.
Thanks,
Eileen
Free Windows Admin Tool Kit Click here and download it now
May 30th, 2011 1:34pm
This topic is archived. No further replies will be accepted.
Other recent topics
