Reporting Services - Auto Generate Report

Hi Experts,
I have 2 table, Table A contains a list of client's Email, and table  Table B contains of client's transaction record.

My task is to create a reporting services that can automatically generate a client transaction report(EACH CLIENT) and automatically send to their email address in Table A every month.

Anyone know how to do this?

Thanks.
mkdev2009Asked:
Who is Participating?
 
planoczCommented:
Make a stored procedure and join the two tables, then create your report to call in the SP.
0
 
mkdev2009Author Commented:
planocz, thanks for reply. Do u have any sample tutorial on how to do this? cos i have no idea how to start it. Thanks in advance.
0
 
mkdev2009Author Commented:
forced to accept
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.