I'm not a Backup Exec administrator, but recently one of my co-workers wanted a custom SSRS report to track our backups, which also allows him to receive this report on a regular basis via a subscription. This is what I came up with - perhaps you too will find it useful.
SELECT CASE TaskTypeID
WHEN 200 THEN 'Backup'
WHEN 300 THEN 'Duplicate'
END AS TaskType
,(ElapsedTimeSeconds / 3600.0) AS ElapsedTimeHours
WHEN 1 THEN 'Success w/ Exception'
WHEN 3 THEN 'Success w/ Exception'
WHEN 6 THEN 'Canceled'
WHEN 19 THEN 'Success'
END AS FinalJobStatus
,(TotalDataSizeBytes / 1024.0 / 1024.0 / 1024.0) AS TotalDataSizeGB
WHERE TaskTypeID IN (200, 300)
AND ActualStartTime > DATEADD(MONTH, -1, GETDATE())
ORDER BY ActualStartTime DESC
RDL: click here.