February 6, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Odd calculated field errorOdd calculated field error
Previous Previous
 
Next Next
New Post
 9/14/2007 5:52 AM
 

I am receiving an odd error in SSRS when I try to perform a function on an existing field, to make a calculated field:

An unexpected error occurred while compiling expressions. Native compiler returned value: ‘[BC32017] Comma, ‘)’

, or a valid expression continuation expected.’

What does that mean?

These formulas should work, even simple things break.

New Post
 9/14/2007 1:09 PM
 
Hi,
Though your problem doesn't seem to be connected to Enesys RS Data Extension, I would be pleased to try to help if you can provide me with some more detailed material.

Regards,

Frederic LATOUR
ENESYS
New Post
 9/14/2007 9:08 PM
 
Hello - Thank you.

Here is a full description of my problem.  I am using Enesys Data Extension to pull data from a Sharepoint site.  One of the columns included in the data is a multiple value name field (e.g. George Bush;#DickCheney).  I would like to create a new column that contains only the first name of that expression.  However, even when I attempt simple expressions on the returned data, I receive the following error:

An unexpected error occurred while compiling expressions.  Native compiler return value: '[BC32017] Comma, ')', or  a valid expression continuation expected.'

This occurs when I employ a simple formula as follows:
=left(Fields!Responsible_Party__Who_.Value,10)

or a slightly more complex formula:
=left(Fields!Responsible_Party__Who_.Value,instr(Fields!Responsible_Party__Who_.Value,";#"))

I have tried to reformat the data to make sure it is in strong format or control for nulls with the "IsNothing" command, to no avail. 

I receive the error when I attempt to generate the report. 

New Post
 9/17/2007 2:37 PM
 
 Modified By Frédéric LATOUR  on 9/17/2007 1:38:10 PM
Hi,
I wonder what is going wrong as I tested your scenario and didn't encounter any error.

I have added a calculated field (named FirstSkill) within the report designer using the following expression :
=Left(Fields!Skills.Value, instr(Fields!Skills.Value,";#")-1)

I then designed a basic report as the following :

Title
Skills
First Skill
Buchanan
Asp.Net;#1;#C#
Asp.Net
Callahan
Moss 2007;#5;#Wss V3
Moss 2007
Davolio
Asp.Net;#1;#C#;#2;#SQL Server 2005
Asp.Net
Dodsworth
Asp.Net;#1;#C#;#4;#Moss 2007;#2;#SQL Server 2005;#5;#Wss V3
Asp.Net

Could it be a problem related to the field name?
Be sure to use the expression designer when setting the expression for the calculated field.
Let me know how it goes.
Regards,

Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Odd calculated field errorOdd calculated field error

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement