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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2013-03-07 : 17:32:25
|
| Experts,I am rendering SSRS report through report viewer of share point where I am getting 40 records per page but when i click on print then I am getting around 14-15 records per page. Is there any logic behind this pagination? Or can i fixed in both case (Rendering 14 records and printing also 14 records)T.I.A |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2013-03-07 : 22:14:21
|
| Hi I got one solution as1) add a parent group to the detail row (without header and footer). 2) set the group expression of the parent group to =Ceiling(Rownumber(Nothing)/14)3) select the just added row group and remove the sorting expression in the Group Properties (on the Sorting tab)4) in the Page Break tab check the check box " Between Each Instance of the Group fromhttp://www.sqlservercentral.com/Forums/Topic490774-147-1.aspxIt is working fine for VS2008 and Report manager but for printable version it shows only 6 records only..T.I.A |
 |
|
|
|
|
|
Pagination behavior??