Rockridge Solutions
Commonsense Software and Consulting
Home | Solutions | Projects | Profiles | Contact

Eliminate Extra Blank Rows in XMLP Reports

Posted on December 12, 2011 by Todd Kummer

A recent XML Publisher report of mine printed a blank page at the end of the report anytime the final page was close to full. The culprit was extra blank spacer lines that were being added even though the content the lines surrounded was not included from the report.

Here's what the report looked like:

...content...
{blank spacer line}
{template call for conditional data}

The result was that the blank line was added even when the conditional data was not. If a report has multiple conditional sections, this can cause gaps in the output. As in my case, if those conditional sections are at the end, it can cause a blank page.

The solution is to move the spacer line into the template. That way it is only included if the conditional data is included.

Your report now looks like this:

...content...
{template call for conditional data}

And the template looks like this:

{begin template}
{blank spacer line}
...content...
{end template}

 

This has the added benefit of including the spacing for each instance of the data, in case there are multiple instances of the conditional data.

One last note on extra lines: Beware a space. If a line in your RTF has a field form that does not generate output (such as an if statement), it will not generate a line on the output. However, if there's a space before or after the form field it WILL generate a line.

« Built-in Function... | Main


Post a Comment:
Comments are closed for this entry.

Recent Posts

Monday Dec 12, 2011

Eliminate Extra Blank Rows in XMLP Reports

Saturday Feb 26, 2011

Built-in Function BulkInsertField

Thursday Jun 24, 2010

Spicing Up Your Vanilla With a Custom Look & Feel

Wednesday Feb 03, 2010

Local Sub-Templates for XML Publisher

Monday Dec 14, 2009

Generate Excel Spreadsheet from PeopleCode

Checking Query Security via SQL

Monday Nov 02, 2009

Rowset Manual Sort

Monday Oct 26, 2009

Meta-SQL %InsertSelectWithLongs

Tuesday Sep 29, 2009

Set Processing vs Complexity

PeopleTools 8.50 PeopleBooks

Tuesday Sep 08, 2009

Screen Capture Software: Greenshot

Wednesday Sep 02, 2009

Using Maps in PeopleCode

Sunday Aug 23, 2009

Accessing the Run Control from App Engine PeopleCode

Thursday Aug 20, 2009

Rowset Fill Method and the JOIN Keyword

Monday Aug 10, 2009

Select All / Clear All via JavaScript

Monday Aug 03, 2009

Pre-process XML Publisher Reports with XSLT

Friday Sep 12, 2008

Status Monitor Pop Up

Sunday Sep 07, 2008

Approval Workflow Engine (AWE)

Thursday Aug 07, 2008

Welcome to the Website

© 2008 Rockridge Solutions.
gipoco.com is neither affiliated with the authors of this page nor responsible for its contents. This is a safe-cache copy of the original web site.