nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to set PageBreak Interval by documetn type in rptdesign ?

Elkaras

Hi, I have a problem .. now ..

I think all I've made rptdesign works really fine ...

but it has a big problem..

that is the page break works on excel type document..

the report usually has more than one hundred rows ...

so, the table in the report has page break by 10,

on the web viewer it works really fine ...

but.. excel ... the data has been divided by 10 ..and make other sheets..the divided data on

** I want to set pagebreak interval as 0 , when the rpt design calls when the output format is xls or xlsx..

what should I do ? !

Find more posts tagged with

Comments

Elkaras

has sovled by myself

Select the table and on script section for onPrepare.

first, get the type of output document type.

second, get table Element and set the value of PageBreakInterval.

Here's source..

[onPrepare] - on table element

outputFormatString = reportContext.getOutputFormat();
Packages.java.lang.System.out.println(" BIRT output format :" + outputFormatString);
if(outputFormatString=="xlsx"){
tableContext = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("myTable");
tableContext.setPageBreakInterval(0);
}

//

thanks for reading , have a good day.

mwilliams

Great! Glad you were able to solve this so quickly. Also, thanks for updating the thread! Let us know whenever you have questions!

jbriel

Hi, I am trying to do the same. I am using birt 4.3 and I want to set the p[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]age break interval to 0 if the user selected [/color]xls_spudsoft [color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]as the export option.[/color] I tried adding the following to the table's onPrepare section[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]outputFormatString[/color] = reportContext.getOutputFormat(); 
[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]Packages.[/color]java.lang.System.out.println(" BIRT output format :" + outputFormatString); 
[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]if[/color](outputFormatString=="xls_spudsoft"){ 
[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]tableContext[/color] = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("myTable"); 
[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]tableContext[/color].setPageBreakInterval(0); 
[color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]} [/color][color=rgb(40,40,40);font-family:helvetica, arial, sans-serif;]but[/color] that did not work for me. Does anyone have an idea what could be wrong?

mwilliams

Take a look at the beforeFactory script in this example. The name of the table set in the property editor is "myTable".

jbriel

Hi, thx for the reply. I am getting a weird result. If I run your attached example and printout the OutputFormat it says "PDF" when I run or export the report. Also for my own report the OutputFormat stays "html" when I use the xls_spudsoft export option. Any Ideas? Could it be something with my birt environment that's not right?

mwilliams

If you run to the web viewer and then export the report, it runs it as "pdf" format because that's what the web viewer runs as. If you run straight to xls_spudsoft, it should work correctly. Let me try putting the output format in the report and testing.

mwilliams

You could create your own export to XLS option, like in this report.