Brenda Wilkerson
asked on
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?
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")
ASKER
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Put space between variable and & and it worked.
ASKER
Resolved
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Great
Is "Driver" your dataset?
Does this article help also?
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/b2fdefc9-ae76-43cc-a944-e587658c480b/