Post reply

Splitting a report by a column value

  • 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

  • November 3, 2006 at 3:03 pm

    #669924

    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)

  • November 4, 2006 at 7:26 am

    #669967

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

     

    Thanks

    Archana

  • November 5, 2006 at 9:31 pm

    #669983

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

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

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