<p>Hi all,</p>
<p>My Requirement is as below</p>
<p>Dataset : A B C</p>
<p>Dataset2: D E F</p>
<p> </p>
<p>o/p : A B C D E F</p>
<p> </p>
<p>so i have done full outer join of these tables and showing in a cross tab per the requirmenet but as some column data will be empty(Date column)for some columns and when i tried to show in excel format default it is showing as -1 and when i try to view in html it is showing as 0000-01-01 which is default date i tried to hide element in the property editor but doesnt help is there a any way i can hide the empty dates?? Thanks in Advance.</p>
