I have recently upgraded from SQL Server 2008 SP2 Enterprise edition to 2008 R2 Enterprise, and was in the process of validating that the process did not have any adverse affects on my existing
150 reports originally designed and managed via BIDS 2008.
Several reports were designed where the first page has a header different from the rest of the pages. I created the generic header in the
PageHeader and set
PrintOnFirstPage to False. This worked great in 2008...but in 2008 R2 the real estate on the first page is not "freed," so the first page looks
like it has an enormous top margin when rendered as a PDF. Even playing around with the visibility of the text box doesn't eliminate the whitespace - and setting visibility properties was not required to get it to work in SQL Server, which rendered as
a PDF perfectly just yesterday before our upgrade!
I noticed that there were three patches available, but I did not see a Fix available that addressed this issue, therefore I did not install them as advised on the site.
Is there any way to do free up the real estate so my first page can use it (maybe a setting in 2008 R2 that wasn't there for 2008)? Or is this a known bug between the two and a patch/hotfix
is in the works? I'd hate to have reports that were specifically designed with certain paging to have to be revisited one by one.
Thank you fo
View Complete Post