Couple of questions:
0. Are you able to run manually any SSRS reports from the VCM UI?
1. Have you configured email server on your MS SQL SSRS server? - see kb VMware Knowledge Base
2. Do you a have a single tier or dual tier installation (with separate SQL server)
I am able to run an SSRS report from the VCM UI
I have configured the email server on MS SQL and within VCM
I have a dual tier installation.