textbox expression

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » textbox expression

textbox expression

Rate Topic

Display Mode

Topic Options

Author

Message

ramu4ind

Posted Tuesday, February 24, 2009 12:32 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, November 20, 2009 3:23 AM
Points: 39, Visits: 200

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

Post #663249

« Prev Topic | Next Topic »

Permissions