In 2012 dimensions could be multiple(dynamic) for any employee.
Along with Employee details i need to show the dimensions. Now, I have a dataset in ssrs with empl details and another dataset with dimensions(multiple).
How can i show it together e.g
Name: XYZ
dimension1
dimension2
dimension3
Name:ABC
dimension1
dimension2
.
.
.
Thanks in advance
Regards,
Depending on your needs you can do this from a sub-report or by using the LookUp() function.
Please take a look at the following on Stack Overflow: Using Fields in Multiple Datasets in SSRS
It seems like the LookUp() function what you are looking for. Here is a good article on using this technique.
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