Splitting a report by a column value

Question

Splitting a report by a column value

Archana Wathore

SSC Rookie

Points: 28
More actions
November 2, 2006 at 8:48 am

#173352

I have a report that needs to be spilt into multiple reports based on customer number. It should create seaparate pdf files for each customer number.Is there a way to accomplish this in SQL server 2005 reporting services.

Thanks

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Ali-282628 Right there with Babe Points: 762 More actions · Answer 1

You could create a report that takes the customer number as a parameter, then have your application call this report for different customers and generate PDFs. Your application could pretty much be anything from a vbscript to a .net winforms application. There are many code examples on how to call RS repots from .NET out there. (I've done this from a winforms .net app and it was pretty simple)

Archana Wathore SSC Rookie Points: 28 More actions · Answer 2

I would appreciate it, if you could send me some examples or links to some examples on winforms .net applications.

Thanks

Archana

Ali-282628 Right there with Babe Points: 762 More actions · Answer 3

http://www.codeproject.com/sqlrs/PDFUsingSQLRepServices.asp should help you get started

Splitting a report by a column value

Cookies on SQLServerCentral