Thursday, April 26, 2012

You may show the total number of records in an SSRS report.

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