Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error In SSRS Expression Expand / Collapse
Author
Message
Posted Thursday, October 24, 2013 8:11 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:34 AM
Points: 593, Visits: 1,083
My SSRS report shows a #Error for the following expression. Is there any problem in the syntax?

= "Quality Assurance" &
First(Fields!Auditor.Value, "DsGLPFindingsData")
Post #1508068
Posted Friday, October 25, 2013 10:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:05 AM
Points: 125, Visits: 267
FYI..the syntax worked in my environment. Could it be a data problem?
Post #1508530
Posted Tuesday, October 29, 2013 6:44 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:50 PM
Points: 532, Visits: 448
Check the Auditor field for missing values.
Post #1509319
Posted Thursday, November 14, 2013 3:53 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 3:34 AM
Points: 593, Visits: 1,083
Thanks for the replies,

I got worked this way:

"<b>" & "Quality Assurance " & "</b>" & VbCrLf &
First(Fields!Auditor.Value, "DsGLPFindingsData")
Post #1514210
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse