Wednesday, 7 October 2015

SSRS - Export multiple pdf file - Report generating 50 student details with 50 page (each student one page- group by student).

Step1. Create one Row Group based on Student.
Step2.Row Group has been created. We can see the Group1 in the Row Group Pane. Right Click on the Group1 column Delete Columns only. Delete Column window comes, Choose Delete column only and click on
Step3.Now you can see the Group1 column is deleted but Group1 is still available in the report that groups data Student wise.
Step4.Go to Group1 property by right click on Group1 in Row grouping pane. In the Group property, go to Page Break Page Break Option Check the box for Between each instance of a group and at the end of group”. Right click on the Tablix go to Tablix property. Tablix property windows comes: Check Add Page break after and in column header, check Repeat header columns on each page.” Step5.After implementing Page Break and Grouping, run the report and export it to PDF.

No comments: