I had the following textbox expression in my SSRS report and it was working fine.
= First(Fields!FirstName.Value) +" " + First(Fields!LastName.Value) + ", MD"
When I moved the textbox to the report header area I started getting the "scope required" error message
I did some research and saw that I needed to specify the dataset. Once I included the dataset (PPR) below the error went away.
= First(Fields!FirstName.Value,"PPR") +" " + First(Fields!LastName.Value, "PPR") + ", MD"
SSRS is now giving the same error but for another textbox/expression (below) that was working fine until I moved it to the header.
="Interim Score: " & CINT((sum(CINT(left(fields!Points.value,1))) / sum(CINT(right(fields!Points.value,1))))*100) & "%"
I tried the following 2 modifications to include the scope (PPR) in the expression but I am still getting the same error. Is this just a syntax error on my part or am I trying to do something that can't be done in the header?
didn't work
="Interim Score: " & CINT((sum(CINT(left((fields!Points.value,"PPR"),1))) / sum(CINT(right((fields!Points.value,"PPR"),1))))*100) & "%"
didn't work
="Interim Score: " & CINT((sum(CINT(left(fields!Points.value,"PPR",1))) / sum(CINT(right(fields!Points.value,"PPR",1))))*100) & "%"
Below is the full error message I am getting:
The Value expression for the text box ‘Textbox6’ references a field in an aggregate expression without a scope. A scope is required for all aggregates in the page header or footer which reference fields.
I only have 1 dataset (PPR) in my report.
I was reading up on the below page but I can't seem to pinpoint what I am doing wrong. Any suggestions would be greatly appreciated.
https://technet.microsoft.com/en-us/library/dd220421%28v=sql.110%29.aspx