Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Using 2 datsets in SSRS Axapta 2012

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,

like image 309
piku Avatar asked Nov 03 '22 20:11

piku


1 Answers

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.

like image 106
dotNetE Avatar answered Nov 08 '22 04:11

dotNetE