Never mind. I figured it out. You can use the "FormatPercent" function as follows:

=FormatPercent(((SUM(Iif(Fields!Quality.Value="Good", Fields!Length.Value, CDec(0))))/SUM(Fields!Length.Value)),2)

It is failing on all queries

Hello Steven,

I am running Service Pack 3.

The account used for sqlmail is sysadmin

Thanks Antares686. Your idea helped alot. It did improve query time.

I have found the solution!

Microsoft has added another parameter to xp_sendmail called @ansi_attachment which can be set to TRUE. This then causes the text file to be...