February 11, 2009 at 7:13 am
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
February 11, 2009 at 7:35 am
Figured it out
Changinagain
February 11, 2009 at 10:06 am
Do you mind posting your solution? 🙂
August 26, 2010 at 1:22 pm
what's your solution? I'm having the same problem? can you help if you even still remember it?
August 26, 2010 at 2:01 pm
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
August 27, 2010 at 10:08 am
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply