Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Steve Hanzek
Starting Member
2 Posts |
 Posted - 2011-12-01 : 15:51:43
|
| I'm working on creating a new statement, to be sent to about 200 vendors. The current statement is in Crystal Reports, and creates a single pdf file, which is then burst into individual pdf files based on the vendor id.I want to replace this with a statement that can select individual or all vendors, and create individual pdf files right from the start, rather than one pdf file and bursting them into multiple pdfs.I'm somewhat new with the VS 2008 reporting system. I'm sure I can create the statement, but not sure about the looping logic that is needed to allow user to select individual vendors or all, and then create the separate files.Any clues/tips would be appreciated.Visual Studio 2008 with SQL Server 2008.ThanksSteve |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-02 : 01:06:55
|
| you need to add a parameter to report based on vendorid and then add a filter to filter data in dataset based on value of this parameter. then call report progrmattically inside a loop and use resultset from vendor table to get distinct list vendor names to be passed to report each time and generate corresponding pdfs .------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Report with Visual Studio output to multiple pdfs