Hi, I have a report that need to run for x number of customers, these customers will be stored in a table. How do i get my report to run for each of these customers, and store the pdf formats in a certain location. Thanks Rebekah

Create a Subscription for these Reports and send this Reports into a Shared folder location. http://msdn.microsoft.com/en-us/library/ms159264.aspx Rakesh M J Dont forget to mark it as Answered if found useful MCTS,MCITP,MCSS http://myspeakonbi.blogspot.com/

Rebekah Take a look at http://www.ssw.com.au/ssw/kb/KB.aspx?KBID=Q1455840Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/