Search code examples
reporting-servicesssrs-2012ssrs-tablix

How can I scope use of First to get only the first value in a group?

I have a report structured as:

Org  
   Project  
      Version

Each of Org and Project are groups. Version is the detail row and there can be multiple Versions per Project. I need the aggregates at the Project level to be the First value of Version. I tried using "First(Fields!name.value)" and I get first in the dataset scope. I tried "First(Fields!name.value,"table1_project")" where table1_project is the name of the Project group, and I get an error saying the scope parameter is invalid.

Is there a way to scope this so I get the "first" value of Version in the Project row?

SSRS 2012 with VS 2012

This is what the report looks like: enter image description here

These are the groups:

enter image description here

Error message I'm getting: enter image description here

table1_project Properties: enter image description here

Solution

  • So this worked:

    =First(Fields!baseline.Value,"table1_project")

    which is what I tried a dozen times before I posted the original question. I have no idea what happened but it's working now.