How to output the results of a remote execute job to a report

hi all

I need to send a report to management on the outcome of job, but they also want additional details about each host.

is there a macro or a tag that I can include in the report template that looks up the status of a specified job id?

Also, is there a way in an html report to generate a graph (like the pie chart in the job_invocations menu)

Thanks in advance for your help