Menu
Lets create two embedded data set in SSRS, first one will fetch the Employee details and second will fetch the Department details. Lets take a new report and add a Embedded Data source first then will add Embedded Datasets.
A dataset does not contain the actual data. A dataset contains the information that is needed to retrieve a specific set of data from a data source. There are two types of datasets: embedded and shared. An embedded dataset is defined in a report and used only by that report.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With