Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Page numbers in SSRS while exporting to pdf file Expand / Collapse
Author
Message
Posted Friday, June 13, 2008 1:44 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:25 AM
Points: 78, Visits: 281
Hi

I am designing the report in SSRS. In footer I have set the page out of (no. of pages). When I am viewing the report in report viewer it shows me for ex. 1 of 5 pages, 2 of 5 pages... etc...


When I exporting it to the pdf file the no. of pages increases and output is getting split into more pages. so now it shows me for ex. 1 of 7 pages, 2 of 7 pages.........etc.

But I want to keep the page numbers consistent with the viewer. so eventhough its divided in 7 pages. the page footer should show like 1 of 5 pages, 2 of 5 pages, 3 of 5 pages, etc..

is this possible??

Thanks


Thanks.

Gunjan.
Post #517025
Posted Monday, June 16, 2008 7:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 25, 2010 7:14 AM
Points: 170, Visits: 337
As far as I know this is not possible, the idea of the viewer is to show pages that have no length limit, they simply keep going until a ThrowPage is received.

When printing, or exporting to PDF, the expected output is by page size, and therefore you will get new pages every time (for example) the limit of an A4 piece of paper is reached.

To try to accomplish what you want, you would need to find a way of always having only an A4 page worth of data in a certain group, and throwing a page at the start or end of that group. This would become unworkable pretty wuickly and I wouldn't recommend it as an approach.

Nigel West.


Nigel West
UK
Post #517543
Posted Monday, June 16, 2008 7:38 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:25 AM
Points: 78, Visits: 281
Hi,

Thanks for the reply.

I have achieved that by storing the result into temp table and then assigning that field value to the attribute/control on the report which will work as a page number like =Field!SrNo.Value & ' of ' & Field!SrNo.Value

But the new requirement is if viewer shows 5 pages and while exporting to PDF if the page gets increased then for ex. for 3rd record it splits the page in to two. so the idea is to show like 1 of 2 next page 2 of 2 ; even though the pdf document has 7 or any number of pages but for individual record if the page gets split then it should work as per example I mentioned.

Is there any trick or provision in SSRS?


Thanks.

Gunjan.
Post #517556
Posted Monday, June 16, 2008 7:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 25, 2010 7:14 AM
Points: 170, Visits: 337
Nothing I can think of I'm afraid, sorry!

Nigel West
UK
Post #517561
Posted Monday, June 16, 2008 7:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:25 AM
Points: 78, Visits: 281
:)

No problem..

Thanks....


Thanks.

Gunjan.
Post #517563
Posted Wednesday, November 12, 2008 6:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 6:13 AM
Points: 11, Visits: 409
I'm sure you have moved on beyond this problem by now. However my users often report this phenomenon when the body dimensions extend (are wider than) the report layout dimenions. If your report layout is 8 1/2 long by 11 wide, with a one inch margin on the left & right, your report body can be no wider than 9 inches. When you export to pdf, the pages seem to grow beyond the preview mode. If you look at the number of pages in the print-preview mode you should see the real number of pages that will be printed or converted to pdf.
CJ
Post #601319
Posted Wednesday, February 18, 2009 11:16 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 18, 2009 10:05 AM
Points: 2, Visits: 0
The PDF Writer called PDFEdit995 has a function to number pages in a file.
Post #659669
Posted Wednesday, August 26, 2009 11:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, August 26, 2009 11:36 PM
Points: 1, Visits: 5
Please provide me the necessary steps to add page n of m concept in sql rs reports.
Post #778046
Posted Thursday, August 27, 2009 6:19 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 6:13 AM
Points: 11, Visits: 409
Here's the expression you can add to a text box placed in the header or footer:
="Page " & Globals!PageNumber & " of " & Globals!TotalPages
Post #778207
Posted Saturday, October 10, 2009 12:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 10, 2009 12:38 AM
Points: 1, Visits: 0
hi..

can u please tell me how to get the total no of pages present in a group in a Report Viewer's Footer.

I have a report with group by Village_code and i have 2 villages .first village have 25 no of pages and 2nd village have 7 pages.

I need my OUTPUT SHOULD BE..

PAGE 1: PAGE 1 OF 25
PAGE 2: PAGE 2 OF 25
PAGE 3: PAGE 3 OF 25..ETC FOR VILLAGE 1

AND FOR VILLAGE 2:

PAGE 1: PAGE 1 OF 7
PAGE 2: PAGE 2 OF 7 ETC..

Please help me how to do it........
Post #801180
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse