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 |
|
avijit_mca
Posting Yak Master
109 Posts |
 Posted - 2014-07-21 : 10:07:08
|
| SSRS report background :generating student details.parameter need to select range of student list.e.g : student parameter : 1 to 50now exporting one pdf file with 50 page where each page having one student details. Requirement : when I will select 1 to 50 range .. one pdf file will be generate but instead of one file it should create 50 pdf file depends on Student id .thanks .Regards,avijit |
|
|
MichaelJSQL
Constraint Violating Yak Guru
252 Posts |
Posted - 2014-07-21 : 15:46:59
|
| If this is something you can run via SSIS, you can call your SSRS via SSIS in a loop passing the student parameter to the report. This could be used to generate a .pdf for each student. I had something similar that involves creating .pdf consisting of form letters. I pass in the form a unique identifier for each letter as parameter and a pdf for all those people who will be receiving that type of letter is generated. |
 |
|
|
avijit_mca
Posting Yak Master
109 Posts |
Posted - 2014-07-22 : 09:25:58
|
| okay. you mean saving each student report in pdf file. That a good idea. Could you please provide details like script component , reference etcThanks.Regards,avijit |
|
|
|
MichaelJSQL
Constraint Violating Yak Guru
252 Posts |
Posted - 2014-07-22 : 10:50:43
|
| http://technet.microsoft.com/en-us/library/ff793463(v=sql.105).aspxThis should be a good starter. |
|
|
|
|
|
|
SSRS export multiple pdf file