OK

I didn't think it was possible. since the comment box is text only.  we use a third party email hosting service using office365 exchange and our SSRS is...

Initially, I did get this work, and work working fine until we decided to just render the reports to pdf, and email the reports to who ever needed them.

George

Thanks

I found some code that I modified and it is working well

DECLARE @isExists INT

exec master.dbo.xp_fileexist 'E:\ZipBatches\ReactorBatches.zip',

@isExists OUTPUT

SELECT case @isExists

when 1 then 'yes'

else 'No'

end as isExists

...

well since I am not an SQL programmer, I have been left with fixing what someone else started.

essential I have a timestamped table that records tank levels every 1 minute....