End of statement expected - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

End of statement expected

Author

Topic

stewart1127
Starting Member

8 Posts

Posted - 2008-11-04 : 14:29:42

The Value expression for the textrun ‘Text13.Paragraphs[0].TextRuns[0]’ contains an error: [BC30205] End of statement expected.

Does anyone know how to tell where this error is actually occuring in the report?

stewart1127
Starting Member

8 Posts

Posted - 2008-11-04 : 15:09:21

figured that out. Pretty obvious. Thanks anyway

eshwar401
Starting Member

7 Posts

Posted - 2008-11-18 : 23:21:35

Hi Stewart,

I am also getting the same error.

when I am trying to parameterise it is giving me an error as
[rsCompilerErrorInExpression] The CommandText expression for the query ‘GridData’ contains an error: [BC30205] End of statement expected.

can you please suggest me how to resolve this error.

Regards,
Ram

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-19 : 00:24:33

what was the expression you gave for commandtext?

eshwar401
Starting Member

7 Posts

Posted - 2008-11-19 : 02:01:05

Thanks for your reply.

This is the query

="with
member [Measures].[MATGCT] as ([Measures].[Scan VOL MAT],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591])
member [Measures].[MATMET] as ([Measures].[Scan VOL MAT],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[214211])
member [Measures].[MATGGT] as ([Measures].[Scan VOL MAT],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[214219])
member [Measures].[GCT_MAT_SHARE] as ([PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591],[Measures].[Scan VOL MAT Share])
member [Measures].[GCT_MAT_SHARE_LY] as ([Measures].[Scan VOL MAT SHARE LY],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591])
member [Measures].[+/- MAT] as (([Measures].[GCT_MAT_SHARE])-([Measures].[GCT_MAT_SHARE_LY]))
member [Measures].[GCT_QTR_SHARE] as ([Measures].[Scan VOL QTR Share],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591])
member [Measures].[GCT_QTR_SHARE_LY] as ([Measures].[Scan VOL QTR SHARE LY],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591])
member [Measures].[+/- QTR] as ([Measures].[GCT_QTR_SHARE]-[Measures].[GCT_QTR_SHARE_LY])
member [Measures].[ShareIssues] as iif([Measures].[+/- MAT]<=-0.5 OR [Measures].[+/- QTR]<=-1.0,"Major",iif(([Measures].[+/- MAT]>-0.5 AND [Measures].[+/- MAT]<0.0) OR ([Measures].[+/- QTR]>-1.0 AND [Measures].[+/- QTR]<0.0),"Attention","No Issues"))
member [Measures].[MATGCTVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[MATGCT],bdesc))
member [Measures].[MATMETVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[MATMET],bdesc))
member [Measures].[MATGGTVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[MATGGT],bdesc))
member [Measures].[MATTotalVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[Scan Vol MAT],bdesc))
member [Measures].[MATGCTShareRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[GCT_MAT_SHARE],bdesc))
member [Measures].[QTRGCTShareRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[GCT_QTR_SHARE],bdesc))

member [Measures].[ShareIssues] as iif([Measures].[+/- MAT]<=-0.5 OR [Measures].[+/- QTR]<=-1.0,"Major",iif(([Measures].[+/- MAT]>-0.5 AND [Measures].[+/- MAT]<0.0) OR ([Measures].[+/- QTR]>-1.0 AND [Measures].[+/- QTR]<0.0),"Attention","No Issues"))

select
{[Measures].[Scan VOL],[Measures].[Scan VOL MAT],[Measures].[MATGCT],[Measures].[MATMET],[Measures].[MATGGT],[Measures].[GCT_MAT_SHARE],[Measures].[GCT_MAT_SHARE_LY],[Measures].[GCT_QTR_SHARE],[Measures].[GCT_QTR_SHARE_LY],[Measures].[+/- MAT],[Measures].[+/- QTR],[Measures].[MATGCTVolRank],[Measures].[ShareIssues],[[Measures].[MATMETVolRank],[Measures].[MATGGTVolRank],[Measures].[MATTotalVolRank],[Measures].[MATGCTShareRank],[Measures].[QTRGCTShareRank]} on columns,({[CUSTOMER].[SALES].[CUSTOMER].members},{[TIME].[CYCLE CALENDAR].[DATE].&[75283]}) on rows from [GCT_SSAS]"

Without parameterisation it is working fine but when i am trying to parameterise it is saying

[rsCompilerErrorInExpression] The CommandText expression for the query ‘GridData’ contains an error: [BC30205] End of statement expected.

And one more thing if I remove the calculated member “Share Issues” and parameterize it is working but when I include this measure it is giving the error as mentioned above.

Thanks in Advance

Regards,

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-19 : 02:20:20

Have you tried running this in MDX editor of SQl management studio and checked if it works?

eshwar401
Starting Member

7 Posts

Posted - 2008-11-19 : 03:12:01

Thanks for your reply

This is query which is working:

with member [Measures].[MATGCT] as ([Measures].[Scan VOL MAT],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591]) member [Measures].[MATMET] as ([Measures].[Scan VOL MAT],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[214211]) member [Measures].[MATGGT] as ([Measures].[Scan VOL MAT],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[214219]) member [Measures].[GCT_MAT_SHARE] as ([PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591],[Measures].[Scan VOL MAT Share]) member [Measures].[GCT_MAT_SHARE_LY] as ([Measures].[Scan VOL MAT SHARE LY],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591]) member [Measures].[+/- MAT] as (([Measures].[GCT_MAT_SHARE])-([Measures].[GCT_MAT_SHARE_LY])) member [Measures].[GCT_QTR_SHARE] as ([Measures].[Scan VOL QTR Share],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591]) member [Measures].[GCT_QTR_SHARE_LY] as ([Measures].[Scan VOL QTR SHARE LY],[PRODUCT].[MARKET OWNER_MATERIAL SECTOR].[MARKET OWNER NAME].&[37591]) member [Measures].[+/- QTR] as ([Measures].[GCT_QTR_SHARE]-[Measures].[GCT_QTR_SHARE_LY])

member [Measures].[MATGCTVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[MATGCT],bdesc)) member [Measures].[MATMETVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[MATMET],bdesc)) member [Measures].[MATGGTVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[MATGGT],bdesc)) member [Measures].[MATTotalVolRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[Scan Vol MAT],bdesc)) member [Measures].[MATGCTShareRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[GCT_MAT_SHARE],bdesc)) member [Measures].[QTRGCTShareRank] as RANK([CUSTOMER].[SALES].currentmember,order([CUSTOMER].[SALES].[CUSTOMER].members,[Measures].[GCT_QTR_SHARE],bdesc))

member [Measures].[ShareIssues] as case when (([Measures].[+/- MAT]<=-0.5) OR ([Measures].[+/- QTR]<=-1.0)) then "Major" when ((([Measures].[+/- MAT]>-0.5) AND ([Measures].[+/- MAT]<0.0)) OR (([Measures].[+/- QTR]>-1.0) AND ([Measures].[+/- QTR]<0.0))) then "Attention" else "No Issues" end

select
{[Measures].[Scan VOL],[Measures].[Scan VOL MAT],[Measures].[MATGCT],[Measures].[MATMET],[Measures].[MATGGT],[Measures].[GCT_MAT_SHARE],[Measures].[GCT_MAT_SHARE_LY],[Measures].[GCT_QTR_SHARE],[Measures].[GCT_QTR_SHARE_LY],[Measures].[+/- MAT],[Measures].[+/- QTR],[Measures].[MATGCTVolRank],[Measures].[MATMETVolRank],[Measures].[MATGGTVolRank],[Measures].[MATTotalVolRank],[Measures].[MATGCTShareRank],[Measures].[QTRGCTShareRank],[Measures].[ShareIssues]} on columns,({[CUSTOMER].[SALES].[CUSTOMER].members},{[TIME].[CYCLE CALENDAR].[DATE].&[75283]}) on rows from [GCT_SSAS]

when i am parameterizing the query as ="query" then it is giving an error as mentioned in previous reply

and it is not giving any error when calculated member "Share issues" it is giving error with parameterization without parameterization its working...

Regards,
Ram

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-19 : 04:37:10

are you sure you're running this in MDX editor of ssrs?

eshwar401
Starting Member

7 Posts

Posted - 2008-11-19 : 04:54:22

Thanks for your reply.

let me add 1 more thing to it

I developed a calculated member Share issues in the cube and used it in the report and parameterized then it worked

but when i am trying it in the report its not working

But the calc member cannot be done in the cube so i have to do in the query.

Regards,
Ram

eshwar401
Starting Member

7 Posts

Posted - 2008-11-19 : 07:09:50

Thanks for your reply Visakh

here is the query which is working:

member [measures].[share issues1] as iif([Measures].[+/- MAT]<=-0.5 OR [Measures].[+/- QTR]<=-1.0,""Major"",iif(([Measures].[+/- MAT]>-0.5 AND [Measures].[+/- MAT]<0.0) OR ([Measures].[+/- QTR]>-1.0 AND [Measures].[+/- QTR]<0.0),""Attention"",""No Issues""))

Regards,
Ram

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources