<p>Good Day!</p><p> </p><p>I'm just new in using Birt Report and would like to seek for some help form you guys. Im trying to include a column on my birt report (Total Hours Spent). I was able to show the difference of 2 dates but in hours with the querry below:</p><p>SELECT DATEDIFF(HOUR,wo.reportdate,wo.statusdate) ) TotalHourSpent" ->> this will show how many hours</p><p> </p><p>But what i want is to have this kind of format as a result "[color=#ff0000;]<strong>1:12:32:44</strong>[/color]" on my Total Hours Column, so i use the querry below:</p><p> </p><p>" SELECT CONVERT(VARCHAR(15),Datediff(SECOND,wo.reportdate,wo.statusdate)/(60*60*24)) + ':' "<br />
+" +CONVERT(VARCHAR(20),DateAdd(SECOND,Datediff(SECOND,wo.reportdate,wo.statusdate)%(60*60*24),0),108) TotalHourSpent "</p><p> </p><p>Now the problem is, on the 2nd querry, its not showing any records on the preview option, but its working fine in SQL. But if im using the 1st querry it is working just fine on Birt</p><p> </p><p>How you can help me with my concern</p><p> </p><p>Thanks</p>
