Export 1 PDF per record using SQL DB

[kriscorrie]

Hello,

Not sure the best way to request help on this one,

im looking into the possibility of creating 1 pdf report for each record in my recordset.

Sorry im a real novice, so i have no clue where to start, but basically i want to query some data that pulls a report which has 1 page per record, but i want to export each individuals report to a unique pdf file, that is name in some significant to the record. (URN for example)

Any help would be much appreciated

Kristofer

 

[RiverGuy]

You will want to use a 3GL programming language or maybe SQL Server Reporting services to loop through the records and do the export, so this question really isn't that applicable to SQL Server Programming (this is a SQL Server Programming forum). Do you have any experience with programming languages or reporting software? If so, this question would be more applicable in a forum for one of those tools.