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,

score 2 · Answer 1 · edited May 23 '17 at 10:32

2

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.

edited May 23 '17 at 10:32

Community

1
1

answered Mar 11 '13 at 14:02

dotNetE

616
1
6
27

score 0 · Answer 2 · answered Jun 15 '18 at 13:02

0

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.

answered Jun 15 '18 at 13:02

Dhaval Mehta

1
1

Using 2 datsets in SSRS Axapta 2012

2 Answers2