Hi,

use the code function in reporting services.

That way you can use the script you have already written.

here is an overview here

http://www.sqlservercentral.com/articles/Development/2803/

and http://www.odetocode.com/Articles/130.aspx

HTH

Simon