Merging of Two Datasets in a single Tablix..

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

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).

Hi Martin,

I have used Lookup Function Either

but Iam getting this following error

Sorry Refer this Lookup

Did you verify your version of SSRS?

Yes Martin,

Its SSRS 2008 R2 version.

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?