CODEWITHSUNDEEP
reporting-services
Eric W
Eric W

Reputation: 1

SSRS report with muliple datasets

I have added a separate dataset to an SSRS report...it contains some similar tables as another dataset. When I go to write expressions the fields in my new dataset have a "SUM" in front of the field numeric fields and "First" in front of the char fields??? Now I can't pick the numeric field for my report because it will "SUM" up all the data

Upvotes: 0

Views: 69

Answers (2)

Lucky
Lucky

Reputation: 4493

To follow on the heels of Ross' answer...

You can remove those [SUM(FIELD)] tags from your table by clicking it and hitting delete. To add the single data value you want to display, type the field name in brackets like [FIELD] right into that text box.

Alternately, edit the expression the be:

=Fields!YOURFIELDNAME.Value

Upvotes: 0

Ross Bush
Ross Bush

Reputation: 15185

Just remove the SUM() portion once you add the field. Perhaps it is there because of the scope of the bound item. There is no harm in removing the aggregate if the field is in a position in which a detail can print SUM(X)=X.

Upvotes: 0

Related Questions