Error in SSRS "Aggregate expression without scope

I am trying to concatenate 3 columns in a textbox in SSRS and get the following error:
The Value expression for the textbox Name uses an aggregate expression without a scope.  A scope is required for all aggregates used outside of a data region unless the report contains exactly one data set.  Below is the expression I am using for the textbox.      
What am I doing wrong?
=First(Fields!First_Name.Value, "Driver") &" "& First(Fields!Middle_Name.Value, "Driver")&" "& First(Fields!Last_Name.Value, "Driver")

Open in new window

Brenda WilkersonSR DBAAsked:
Who is Participating?
 
Brenda WilkersonSR DBAAuthor Commented:
REsolved
0
 
Tony303Commented:
I tried your syntax but modified to my report and could use the textbox anywhere, header or in table rows.

Is "Driver" your dataset?
Does this article help also?
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/b2fdefc9-ae76-43cc-a944-e587658c480b/
0
 
Brenda WilkersonSR DBAAuthor Commented:
Yes.  It is a  website data source.  The article said to specify the dataset which I have so I cannot figure out what the problem.  
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Tony303Commented:
How about talkiing the 3rd part out. So just concentrate on the first 2 peices of data?
Are your & signs correct (ie the third & sign has no space before it....
=First(Fields!First_Name.Value, "Driver") &" "& First(Fields!Middle_Name.Value, "Driver")&" "& First(Fields!Last_Name.Value, "Driver")

Clutching at straws here.
0
 
Brenda WilkersonSR DBAAuthor Commented:
Put space between variable and & and it worked.
0
 
Brenda WilkersonSR DBAAuthor Commented:
Resolved
0
 
Tony303Commented:
Great
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.