SSRS report - link two data sources

Finance and Operations/AX Developer Forum
1

Hi

If i need to create a report where each SalesTable record has its own page

and in each page i need to display the SalesLines for that SalesTable

then how could this be done?

For example

PAGE 1 ---->

Sales Order 1 some info

Sales Line 1 on Sales Order 1

Sales Line 2 on Sales Order 1

Sales Order 1 some more info

PAGE 2 ---->

Sales Order 2 some info

Sales Line 1 on Sales Order 2

Sales Line 2 on Sales Order 2

Sales Order 2 some more info

and so on…

Can I link two datasets to accomplish this or what would be the correct solution?

Thanks!
Mihkel

2

Please tell us whether you’re talking about SSRS report or MorphX reports. Also note that we could guess that if you to attached a tag with the version of your AX (please do it every time when you create a new thread).

3

AX version is 2012 and report technology is SSRS