I see you tried "conversion operators CDbl, CInt and Cstr", but this is in SSRS, right?

How about trying Convert or Cast in the SQL, to say a varchar field. Then format as desired using string functions in SSRS.