Skip to Content
0
Nov 15, 2012 at 05:37 PM

Issue on displaying date in different columns

28 Views

Hello,

I am doing a report on 2 DSO's. these 2 DSO are in a Multiprovider. I have to Display like below

Material Exact Date revised date 1000 ****** 10001 ****** 19991 ****** 111111 ******

the main idea of this report is to display the material and its revised date. If revised date is not available then display the exact date. So AT ANY TIME ONLY ONE column will have date in it and the other should be blank.

DSO1 contains---- Material & Exact date

DSO2 contain --- Material & Revised dates.

But Some times for a particular material there may not be a revised date maintained in DSO2, in that case I have to take Exact date from DSO1 for that material.

Could any please help me how can I proceed on this.

Thanks and Regards

KT