Also remember I have to automate this report via the SQL Server agent, Im not sure what sort of credential I should use there as well.

Many thanks