can you convert it to varchar(11) in your report datasource?
this produces the expected format, and cuts off the trailing zeros from a simple CONVERT(varchar,@CPUTM)
/*--Results
(No column name)(No column name)
00:00:00.8200:00:00.8200000
*/
DECLARE @CPUTM [time] ='00:00:00.82'
SELECT CONVERT(varchar(11),@CPUTM),CONVERT(varchar,@CPUTM)
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!