Conditional page breaks

I have a grid with a row. The visibility of the row is set by an expression:<pre class="_prettyXprint _lang-">!dataSetRow["inspection_participants_summary"] </pre>"inspection_participants_summary" is a column in one of my Data Sets that evaluates to "true" or "false". I also have a page break for after this row set to "Always". The problem is that when the row gets set to hidden, the page break still happens which causes an empty page to be displayed. I end up having this blank page displayed in the web viewer and the PDF output. I want to set the report up so that if that row in the grid is set to hidden, then the page break doesn't happen. So I made a script in the onCreate() part for that row:<pre class="_prettyXprint _lang-">if (dataSetRow["inspection_participants_summary"] == "true") { this.pageBreakAfter="always";} else { this.pageBreakAfter = "avoid";}</pre>However, when I run this, I get this error: <blockquote class="ipsBlockquote"> <div>org.eclipse.birt.report.engine.api.EngineException: There are errors evaluating script "if (dataSetRow["inspection_participants_summary"] == "true") { this.pageBreakAfter="always"; } else { this.pageBreakAfter = "avoid"; }": ReferenceError: "dataSetRow" is not defined. (/report/body/grid[@id="326"]/row[@id="328"]/method[@name="onCreate"]#1)</div> </blockquote> So how do I make the page break conditional? Is there another way I can get rid of the blank pages? Thanks!

Find more posts tagged with

Comments

micajblock

Try this.getRowData().getColumnValue("Category")<pre class="_prettyXprint">if (this.getRowData().getColumnValue("inspection_participants_summary") == "true") {this.pageBreakAfter="always";} else {this.pageBreakAfter = "avoid";}</pre>

mkdz

I get this error: <blockquote class="ipsBlockquote"> Row (id = 328):<div>+ There are errors evaluating script "if (this.getRowData().getColumnValue("inspection_participants_summary") == "true") {
this.pageBreakAfter="always";
} else {
this.pageBreakAfter = "avoid";
}":
TypeError: Cannot call method "getColumnValue" of null (/report/body/grid[@id="326"]/row[@id="328"]/method[@name="onCreate"]#1) </div></blockquote> "inspection_participants_summary" isn't something I display in my grid. It's just a value that's in my data set.

micajblock

Why are you using a Grid and not a Table? Grids are for formatting. Tables are for data. That being said, I think you can bind the data set to the Grid. You can also use persistent global variables or report variables if you are using a recent enough BIRT release.

mkdz

I am using the grid to format my page breaks and visibility. I have 10 different sections, so my grid has 10 rows. Each row has a visibility that is determined by a condition. I'm trying to apply the same thing to my page breaks.

micajblock

Is the [color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]"inspection_participants_summary" part of a data set that returns one row that drives the visibility of the sections? If yes use a table with 10 detail lines. If not use use report variables to drive this. [/color]