Get a total count of records like so in SSRS:
<Value>= Count(Fields!TimeEntryID.Value)</Value>
Try specifying the dataset as seen below if you are told that the field holding the Value node "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."
<Value>= Count(Fields!TimeEntryID.Value, "DataSet1")</Value>
Other things I tried which did not work:
- <Value>= Sum(iif(Fields!TimeEntryID.Value,0,0,1))</Value>
- <Value>= Sum(iif(Fields!TimeEntryID.Value,0,0,1), "DataSet1")</Value>
If the iifs were to work, the second parameter shows the value to match, the third parameter shows the value to use in the event of a match, and the fourth parameter shows the value to use in the event of a mismatch.
No comments:
Post a Comment