Alex Rivera | Logout

SSRS - Expression using different dataset fields

Asked 2012-03-12T23:15:45.140
14

I have a report with multiple data-sets. Different fields from different data-sets are used in different locations of the report.

In one part of the report, I need to do a calculation using fields from two different data-sets. Is this possible within an expression?
Can I somehow reference the data-set the field is in, in the expression?

For example, I'd like to do something like this: 

=Fields.Dataset1.Field / Fields.Dataset2.Field
reporting-services dataset ssrs-2008 reportbuilder3.0 bids
Edit
Report

1 Answer

1

Another option is to use a parameter as a variable. This is helpful if you want to create a calculated field in one of the datasets. This is best applied when the parameter value comes from a dataset with a single record.

answered 2013-05-01T15:55:54.023

Your Answer