CODEWITHSUNDEEP
ssrs-2008reporting-servicesaxaptadynamics-ax-2012
piku
piku

Reputation: 613

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,

Upvotes: 5

Views: 1285

Answers (2)

Dhaval Mehta
Dhaval Mehta

Reputation: 1

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.

Upvotes: 0

dotNetE
dotNetE

Reputation: 616

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.

Upvotes: 2

Related Questions