RS 2000: Number of pages in Preview and Print Preview differ
in [Reports]
|
Prev: How to Carry information from the web page into the report
Next: can I load VS2003 on Vista for Reporting Services 2000? running Sq
From: HJ on 20 Jun 2008 11:09 Hi, We notice that, when developing reports in Reporting Services 2000, the number of pages differ between the Preview and Print Preview views. And we notice that the end user is experiencing the same when he views a report in his browser and then prints the report. Why is the number of pages not the same in the views and on the print-out and how can we fix it? We have set all margins to 0,25in, the width to 8.3in and the height to 11.7 in. HJ
From: toolman on 23 Jun 2008 14:25 On Jun 20, 11:09 am, "HJ" <hjiscool_nos...(a)hotmail.com> wrote: > Hi, > > We notice that, when developing reports in Reporting Services 2000, the > number of pages differ between the Preview and Print Preview views. And we > notice that the end user is experiencing the same when he views a report in > his browser and then prints the report. > > Why is the number of pages not the same in the views and on the print-out > and how can we fix it? > > We have set all margins to 0,25in, the width to 8.3in and the height to 11.7 > in. > > HJ HJ, The view/output you see in preview is in HTML i.e. sized and formatted for viewing on a monitor. When you switch to print preview it is sized/formatted according to whatever paper size you've set your report dimensions to (A4 in your case). I've never tried but doubt you'll ever get the two to match since HTML always wants to be oriented landscape for onscreen viewing and paper almost always wants to be portrait. toolman
From: HJ on 24 Jun 2008 08:55 Toolman, Thank you for responding. Is there really no way to fix this? I cannot imagine that I am the only one experiencing this (although I could not find a solution anywhere...). HJ "toolman" <timd(a)infocision.com> wrote in message news:3a5e55b7-0a37-4d8e-8f14-1c448439e5bc(a)j22g2000hsf.googlegroups.com... On Jun 20, 11:09 am, "HJ" <hjiscool_nos...(a)hotmail.com> wrote: > Hi, > > We notice that, when developing reports in Reporting Services 2000, the > number of pages differ between the Preview and Print Preview views. And we > notice that the end user is experiencing the same when he views a report > in > his browser and then prints the report. > > Why is the number of pages not the same in the views and on the print-out > and how can we fix it? > > We have set all margins to 0,25in, the width to 8.3in and the height to > 11.7 > in. > > HJ HJ, The view/output you see in preview is in HTML i.e. sized and formatted for viewing on a monitor. When you switch to print preview it is sized/formatted according to whatever paper size you've set your report dimensions to (A4 in your case). I've never tried but doubt you'll ever get the two to match since HTML always wants to be oriented landscape for onscreen viewing and paper almost always wants to be portrait. toolman
From: toolman on 24 Jun 2008 10:15 On Jun 24, 8:55 am, "HJ" <hjiscool_nos...(a)hotmail.com> wrote: > Toolman, > > Thank you for responding. Is there really no way to fix this? I cannot > imagine that I am the only one experiencing this (although I could not find > a solution anywhere...). > > HJ"toolman" <t...(a)infocision.com> wrote in message > > news:3a5e55b7-0a37-4d8e-8f14-1c448439e5bc(a)j22g2000hsf.googlegroups.com... > On Jun 20, 11:09 am, "HJ" <hjiscool_nos...(a)hotmail.com> wrote: > > > > > > > Hi, > > > We notice that, when developing reports in Reporting Services 2000, the > > number of pages differ between the Preview and Print Preview views. And we > > notice that the end user is experiencing the same when he views a report > > in > > his browser and then prints the report. > > > Why is the number of pages not the same in the views and on the print-out > > and how can we fix it? > > > We have set all margins to 0,25in, the width to 8.3in and the height to > > 11.7 > > in. > > > HJ > > HJ, > The view/output you see in preview is in HTML i.e. sized and formatted > for viewing on a monitor. When you switch to print preview it is > sized/formatted according to whatever paper size you've set your > report dimensions to (A4 in your case). I've never tried but doubt > you'll ever get the two to match since HTML always wants to be > oriented landscape for onscreen viewing and paper almost always wants > to be portrait. > > toolman- Hide quoted text - > > - Show quoted text - HJ, You probably aren't finding a solution as most people simply accept this situation as "just the way these things work." That being said, if you absolutely, positively have to try and reconcile the two different page counts, this might (key word = might) work. Try setting the number of report rows per page to match the maximum printed lines per page. For example, if you know that the max number of printed lines is 60 (based on page size, headers/footers, margins, font size, etc.), set your report to page break after 60 rows. You can control the number of rows per page in your report by: 1) add a group to table, and set the "Group On" to an expression something like "=Ceiling(RowNumber(Nothing)/60)" 2) turn off group header and footer 3) set PageBreakAtEnd for group That's the best I can suggest. Good luck! toolman
From: Bruce L-C [MVP] on 24 Jun 2008 11:06
The other possibility IF you have your own front end (i.e. you are using your own webpages to view reports, not the built in portal Report Manager) is to show the reports as PDF rather than HTML. PDF (especially in RS 2000) is significantly slower though. -- Bruce Loehle-Conger MVP SQL Server Reporting Services "toolman" <timd(a)infocision.com> wrote in message news:3ce29745-875b-46c9-bb26-a51fbb1c2df9(a)j22g2000hsf.googlegroups.com... On Jun 24, 8:55 am, "HJ" <hjiscool_nos...(a)hotmail.com> wrote: > Toolman, > > Thank you for responding. Is there really no way to fix this? I cannot > imagine that I am the only one experiencing this (although I could not > find > a solution anywhere...). > > HJ"toolman" <t...(a)infocision.com> wrote in message > > news:3a5e55b7-0a37-4d8e-8f14-1c448439e5bc(a)j22g2000hsf.googlegroups.com... > On Jun 20, 11:09 am, "HJ" <hjiscool_nos...(a)hotmail.com> wrote: > > > > > > > Hi, > > > We notice that, when developing reports in Reporting Services 2000, the > > number of pages differ between the Preview and Print Preview views. And > > we > > notice that the end user is experiencing the same when he views a report > > in > > his browser and then prints the report. > > > Why is the number of pages not the same in the views and on the > > print-out > > and how can we fix it? > > > We have set all margins to 0,25in, the width to 8.3in and the height to > > 11.7 > > in. > > > HJ > > HJ, > The view/output you see in preview is in HTML i.e. sized and formatted > for viewing on a monitor. When you switch to print preview it is > sized/formatted according to whatever paper size you've set your > report dimensions to (A4 in your case). I've never tried but doubt > you'll ever get the two to match since HTML always wants to be > oriented landscape for onscreen viewing and paper almost always wants > to be portrait. > > toolman- Hide quoted text - > > - Show quoted text - HJ, You probably aren't finding a solution as most people simply accept this situation as "just the way these things work." That being said, if you absolutely, positively have to try and reconcile the two different page counts, this might (key word = might) work. Try setting the number of report rows per page to match the maximum printed lines per page. For example, if you know that the max number of printed lines is 60 (based on page size, headers/footers, margins, font size, etc.), set your report to page break after 60 rows. You can control the number of rows per page in your report by: 1) add a group to table, and set the "Group On" to an expression something like "=Ceiling(RowNumber(Nothing)/60)" 2) turn off group header and footer 3) set PageBreakAtEnd for group That's the best I can suggest. Good luck! toolman |