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")
Using website data source :w00t:
Changinagain
-
Figured it out
Changinagain
-
Do you mind posting your solution?
-
what's your solution? I'm having the same problem? can you help if you even still remember it?
-
It was in my table properties, I had the wrong dataset name. This was my first SSRS report so I was lost a lot of the times.
Changinagain
-
A common solution I use is to use the text boxes in my formula rather than do it with fields and scope. The syntax for using a textbox is ReportItems!textboxname.Value. In most situations the text boxes are already in the correct scope.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply