Using 2 datsets in SSRS Axapta 2012

Question

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,

Answer 1

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.

Answer 2

You can use a single table for both emp details and dimensions. Create separate field for each dimension types. And fill them with values. then display them on the ssrs table.

Hope this helps.