Hi!

I have the following table ,

• Database Table:

  BatchID    BatchName      Chemical      Value
  ----------------------------------------------
  BI-1          BN-1       CH-1             1
  
  
  BI-2          BN-2       CH-2             2
  ----------------------------------------------
  

I need to display the following table.

                 BI-1          BI-2
                 BN-1          BN-2
-----------------------------------------
CH-1             1            null
------------------------------------------
CH-2             null          2
------------------------------------------

Here BI-1,BN-1 are two rows in a single columns i need to display chemical value as row of that.Could Please help me to solve this problem.

I tried it in Pivot table but i unable to get this. So is there any chance in Reporting Server MDX. Could you please Answer this question.

This is high priority to me .

Thank You in advance.