No need to add code in RDP class, you can easily achieve this output by using matrix in SSRS report.
Perform following steps in the design of your SSRS report:
1. Add a matrix with this dataset.
2. Use 'Plant' as row group.
3. Add a column group with 'ChargeCode' as group expression which will automatically set for heading too and then use the 'Value' as value. Apply filter in the column group for (Bit = 1). This group will expand with only charge codes with Bit = 1 and show their values.
4. Add another column group on the right using the same expression 'ChargeCode' as group expression and 'Value' as value except this time apply filter of (Bit = 0) in the group. So this will expand for only charge codes with Bit = 0.
5. Add one more column inside the second column group to the left and use 'ChargeCode' expression as the value of that column. Now your second column group will expand for every charge code with Bit = 0 and will show two columns; one with the name of the charge code and another with its value according to the plant.
6. In the end just hard code your desired headings (i.e. 'Other Charge Code' and. 'Other Charge Code Value') in both the columns of second column group so it will repeat the same header for every charge code.
Following these steps will transform your sample data into the desired output.
