textbox expression

• ramu4ind

  SSC Eights!

  Points: 865

  More actions

  February 24, 2009 at 12:32 am

  #206915

  In a report i need to write expression in a textbox.but i am not able to. The query for sql server is

  select convert(varchar(5),sum(convert(int,substring(det_timetaken,1,2)))+

  (sum(convert(int,substring(det_timetaken,4,2)))/60)) + ':' +

  right('00' + convert(varchar(2),(sum(convert(int,substring(det_timetaken,4,2)))%60))

  + (sum(convert(int,substring(det_timetaken,7,2))/60)),2) + ':' +

  right('00'+ convert(varchar(2),(sum(convert(int,substring(det_timetaken,7,2)))%60))

  + (sum(convert(int,substring(det_timetaken,10,3))/1000)),2) + ':' +

  right('00'+ convert(varchar(3),sum(convert(int,substring(det_timetaken,10,3)))%1000),3) from data

  this is giving me sum of the varchar column timetaken like 45:56:67:345.It is summing up and giving the result but in ssrs how to accomplish this in a particular textbox expression?

  Thanks,

  Ramu