.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Page Header, PrintOnFirstPage=False, HTML render fine, PDF export leaves extra space

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
As it says in the header.Setup:SSRS 2008, VS 2008 SP1Local Mode, rdlc fileDesign:Make a 1/2" Page header with a text box in it. Set PrintOnFirstPage=FalseBody contains a Table that spans multiple "hard" pages.Results:Renders to HTML in the report viewer just fine.PDF export leaves blank 1/2" at the top of page 1. With no header for page 1, I had hoped it would remove the extra space the same as in the report viewer.Question:Any way to tell SSRS not to leave space when page header is turned off for the first page?Attempts:Tried putting everything in a rectange in the header and set the visibility to false. Still leaves space.

View Complete Post

More Related Resource Links

SSRS Report - Page break after the Header when export to PDF



I am using SSRS 2005 version. I am printing multiple invoices, taking multiple invoice numbers as a parameter and printing invoices.

I have grouped the report based on Invoice  number, so that the invoices are printed sequentially and there will be page break after each invoice. Within each invoice there is a header, body and footer.

My issue is after the header is printed, an automatic page break happens after the header, and the body moves to the next page. Therefore there is a large gap between the report header and the body. The report layout is landscape.

I wish any one can solve this issue and grateful if they can give the solution for my problem.




Excel Render - Print Header on Each Page


Hello Microsoft or Forum Members:


This seems like a simple Microsoft Based Reporting System 101 feature...But I can not find out how to do it (among other things that seem like it should work with Microsoft rendering to Microsoft).


How do I make the SSRS 2005 Header for the Report print on each of the pages in excel once it is rendered from SSRS?


All I want is an answer by MSFT that says "YES" it can be done and how or "No" it is not currently available.


I noticed I am not the only one with this type of simple question:

(see this unanswered post)


Rendering ASP.NET Script References into the Html Header

One thing that I've come to appreciate in control development in ASP.NET that use JavaScript is the ability to have more control over script and script include placement than ASP.NET provides natively. Specifically in ASP.NET you can use either the ClientScriptManager or ScriptManager to embed scripts and script references into pages via code.

Re-positioning an HTML container with javascript onresize with a Master page.


I have an HTML <div> container that I float to the right of a gridview.  When the browser window is maximized, it looks fine.  When minimized, the gridview positions below the floating container and most of the data is pushed off the bottom of the browser - you have to scroll down to see it.

If I position the floating container above the gridview it looks fine in a minimized window, but looks real bad when maximized.

What I want to do is use a javascript: onresize event to re-position the floating container up or down depending on the window.inner.width AND do it with a Master/Content page structure AND do it for only the one page where needed.

I can capture the onresize event and display the window dimensions but haven't figured-out how to do it with a Content page that still uses the Master page.  I think I'm having a very "thick" week...

- Tinker


Extra file is included on the Page directive inherits =



I am trying to understand where the additional file name is coming from in my Page directives Inherits

attribute like so :

inherits ="Track_Milestones2, App_Web_techsrvcs_track_milestones2.aspx.cdcab7d2"

Is the result of this app being published on my local server at one time or could this

page have been compiled on a server ?

Thanks for your insights !

TextField control add extra character space at end of it



On one of my publishing page layout i have added Content Field (field of content type) that is

<SharePointWebControls:TextField FieldName="MyName" runat="server"></SharePointWebControls:TextField>
"MyName" is single line text column in the content type.

Then i edit the page which is using this page layout and add one text "Sandip" in that MyName field. Now problem is, this filed show the text on the page but at the end of it, it add space. i.e- "Sandip "

I m not getting why it is showing this.

Please help..!

Regards Sandip Patil Sharepoint Developer http://www.worldofsharepoint.com

Web Part working fine on the top-level page but 'Not Safe' error on lower-level pages.


I have created a Web Part which reads and parses the SharePoint logs in order to display usage information of the page it resides on.  The Web Part works perfectly on the top page, reading and displaying the information desired.  However, once the Web Part is added to any page lower in the site heirarchy (sub-page) the same Web Part throws the following error:

Web Part Error: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.

Show Error Details
Hide Error Details

[UnsafeControlException: A Web Part or Web Form Control on this Page cannot be displayed or imported. The type could not be found or it is not registered as safe.]
  at Microsoft.SharePoint.ApplicationRuntime.SafeControls.GetTypeFromGuid(Guid guid)
  at Microsoft.SharePoint.WebPartPages.SPWebPartManager.CreateWebPartsFromRowSetData(Boolean onlyInitializeClosedWebParts)

Of course the current version of the Web Part is in the SafeControls list on the web.config.

The Web Part was originally designed to return site activity only for the top default.aspx page and worked fine but started to fail in the manner described above once I added the following line of code to return a SPCo

Tablix Header missing on last page of PDF output

Tablix Headers don't show on last page of PDF and TIFF output.   I've tried all things mentioned including installing SQL Server 2008 Cumulative Update# 7.   My issue is that I have a Tablix with some header rows that repeat fine until the last page.   On the last page they are hidden.  This appears to be true of PDF and TIFF output.  THere are other issues with Word output.   The standard HTML viewer works fine.   So its clearly a PDF renderer issue.  

SQL Server 2008 R2 BIDS PageHeader's PrintOnFirstPage=False Not Behaving Like SQL Server 2008 BIDS

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

Want to convert html page into pdf format & send same pdf as a attachment

Dear All i want to convert html page into pdf format & i have to send that same pdf  by attachment,if some one has the sample code , please send me

Howe to do :Excel export button in report viewer visible false...?

hi all,  How I can do avoid to display  Excel export in ReportViewer..? if I Use //-------------------------- reportViewer1.ShowExportButton = false; //---------------------------------------------------- Both the buttons will be disabled...for only Excel button How can I...?    

Report fine; PDF export fine; Excel export crashes - ArgumentOutOfRangeException

I use the Report Viewer Redistributable 2005 Service Pack 1 (version 8.0.50727.1843). On my ASP.NET page the report displays fine, in a ReportViewer control, using an rdlc file. Export to PDF works fine. Export to Excel crashes. Stack does not tell me much because it's all internal to the Report Viewer:[ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.Parameter name: index]   System.Collections.ArrayList.get_Item(Int32 index) +7483656   Microsoft.ReportingServices.Rendering.ExcelRenderer.DoubleList.get_Item(Int32 index) +5   Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderImage(Image image, PageTableGrid pageTableGrid, PageReportItemInfo reportItemInfo, PageCell pageCell, Int32 row, Int32 col, Boolean addHeaderRows) +907   Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer.RenderGridCell(PageLayout pageLayout, Int32 row, Int32 col, Hashtable& duplicateItemsTable, Boolean addHeaderRows, ReportItem parentItem, Hashtable riReferenceTable) +1317   Microsoft.ReportingServices.Rendering.BIFFUtility.WorkSheet.WriteRowBlocksAndCells(ExcelRenderer excelRenderer, Stream stream, UInt32 indexBeginOffsetPosition, Int32 minCol, Int32 maxCol) +936   Microsoft.ReportingServices.Rendering.BIFFUtility.BaseWorkSheet.WriteWorkSheet

SSRS 2008 - repeating a non column header column on every page

Hi - I am working on my first SSRS report and I have mostly all of it down except one issue. Per requirements, I need to display a column that is a non header column to repeat on every page while printing and or when I save the generated report in SSRS as a PDF file. I have seen some previous blog from 2007 where RepeatWith property is recommended to be set to the same name of the Tablix in which the column(s) are embeded, tried that but it is not working. Can any one help me on this or guide me how to resolve this? Thanks, Manny

SQL Reporting Services - Page X of XX counts in header

I have searched high and low for how to calculate page numbering in the header where the global values do not apply.   I have a report that generates 300+ invoices and I need the page numbers to reflect page x of xx for that invoice only.  My report page breaks for each customer invoice.  I have found code to get the page number in the header and I have found code to get the total pages in the body.  These two solutions cannot be combined.    Has anyone found a workaround in code behind or some other method?I would appreciate any guidance.   Side note: thank you all for all your postings and solutions.  They have been highly valuable as I am new to SSRS.

Need help to search for extra space in all tables.

Hi, I try to search for data which has some extra spaces in ALL TABLES. Does any one know if there a tool that can do that or the scripts can return all the data (see desire results below). Thank you in advance.  SQL2008. IF OBJECT_ID('Tempdb.dbo.#T1', 'u') IS NOT NULL   DROP TABLE #T1 GO CREATE TABLE #T1 (   FullName   VARCHAR(30) ) GO INSERT INTO #T1 VALUES ('Joe  Smith') INSERT INTO #T1 VALUES ('April Smith ') INSERT INTO #T1 VALUES ('Peter Chen') INSERT INTO #T1 VALUES ('Kristine Nguyen') GO IF OBJECT_ID('Tempdb.dbo.#T2', 'u') IS NOT NULL   DROP TABLE #T2 GO CREATE TABLE #T2 (   FullName   VARCHAR(30) ) GO INSERT INTO #T2 VALUES (' John Smith') INSERT INTO #T2 VALUES ('Lisa Tran ') INSERT INTO #T2 VALUES ('Nicole  Ngo') INSERT INTO #T2 VALUES ('Brandon Lee') GO    SELECT *      FROM #T1;    GO       SELECT *      FROM #T2;    GO -- Desire results. FullName         TableName ---------------- --------- Joe  Smith       #T1   (2 spaces in between) April Smith      #T1   (space after Smith)  John Smith      #T2   (space in front) Lisa Tran  &

Repeat header rows on all pages when you export to excel sheet and print it

Hello , I need to export report into excel sheet. And when people try to print it . The header rows only appear on First page of the print . Other subsequent pages d onot have header rows. I saw another thread saying SQL server 2008 R2 will solve the issue. Can you tell me that is fixed and how to i go about configuring it on SQL server 2008 R2.   Thanks Madhavi

.aspx page when browsed with chrome browser works fine but with IE8 it displays "Internet explorer c

HiI have VS 2008 installed and have  IE8 browser as well as google chrome browser.However wheneever i try to run a .aspx page in solution explorer of VS with the browse with.. options,the page runs fine with chrome browser but not with IE8.The IE browser shows the error "Ineternet explorer cannot display the page".I have set the IE as the default browser in the browse with ... option of the VS 2008.Please suggest.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend