<p>Hi Everyone,</p>
<p> </p>
<p> In my application, i have to build a crosstab report for the given sample data.</p>
<p> </p>
<p> Name Issues_count duration_in_mins date</p>
<p>
</p>
<p> xyz 30 450 2015-05-01</p>
<p> abc 64 900 2015-05-01</p>
<p> lmn 22 200 2015-05-02</p>
<p> xyz 25 150 2015-05-02</p>
<p> </p>
<p> Whereas the cross tab report measure should be the combination of issues_count and duration_in_mins as string like [ count / hh:mm] format. </p>
<p> </p>
<p>Expected crosstab report is like</p>
<p> </p>
<p> Name 2015-05-01 2015-05-02 Grand Total</p>
<p>
</p>
<p> xyz 30 ( 07:30) 25 (02:30) 45 (10:00)</p>
<p> abc 64 ( 15:00) 0 (00:00) 64 (00:00)</p>
<p> lmn 22 ( 03:20) 0 (00:00) 22 (03:20)</p>
<p> </p>
<p>Please help me in solving this report. Thanks in advance.</p>
