Yes David,

I thought of it. Using RS is an easy way to create charts. My problem is I need to create the report and send it by email automatically.

I already followed the steps as explained in this excellent article and managed to send the tabular report automatically using SQL Server Agent, but now the new requirement to send a chart besides the tabular report has been asked.

Any advice from you will be highly appreciated,

Marco