Merging of Two Datasets in a single Tablix..

Finance and Operations/AX Developer Forum
1

Hi Can any help me out … how to add two data sets values in a single Tablix of RDP class in a SSRS Report …?

2

What’s the version of SSRS? SSRS 2008 R2 has Lookup and LookupSet functions, but older versions don’t.

In any way, consider doing the job in your data provider class and returning data in such a form that makes it easiest for your report (which may mean returning a single temporary table in this case).

3

Hi Martin,

I have used Lookup Function Either

but Iam getting this following error

2017-03-03_12-14-11.jpg
2017-03-03_12-14-11.jpg997×393 60.1 KB
2017-03-03_12-13-13.jpg
2017-03-03_12-13-13.jpg715×657 71.5 KB

4

awert.jpg
awert.jpg715×662 73.3 KB

Sorry Refer this Lookup

5

Did you verify your version of SSRS?

6

Yes Martin,

Its SSRS 2008 R2 version.

7

Maybe the tooling for your version of AX (which you still didn’t mention) is written against an older version of SSRS.
Can’t you handle it in the RDP class, as I suggested?