Produce 1000 reports

• hkflight

  SSCommitted

  Points: 1949

  More actions

  April 2, 2012 at 10:10 am

  #259352

  I need to know how I would go about producing a profile report in pdf format for 1000 accounts. I need the filename of each report to include the account number for the account the report was run for, and I need these files saved as a PDF on a network share.

  Would I need to write .net code to accomplish this? Can SQL 2012 accomplish this task natively without .net code?

  Thank you for your guidance!

• Charles Hearn

  SSCrazy

  Points: 2680

  More actions

  April 2, 2012 at 10:50 am

  #1467740

  SQL Server 2008 R2 / SQL Server 2012 can do this with a data driven subscription in SSRS.