Page Break Interval issues with BIRT Excel output

Hi,

I am using "org.eclipse.birt.runtime_4.2.1.v20120918-1113.jar" version of BIRT in my Eclipse.
I have to make a report in Excel for which I am using "org.uguess.birt.report.engine.emitter.xls" emitter.

The problem that I am facing is.
1. I want to hide a label and image based on some parameters, for which I used:
reportContext.getDesignHandle().getElementByID(123).style.display = "none"; OR
reportContext.getDesignHandle().getElementByID(124).getStyle().display = "none"; OR
reportContext.getDesignHandle().getElementByID(123).display = "none";
None of the above 3 lines worked, the label is having Element Id as 123.

2. The Table does a page break which I dont want, below are the properties that I have set:
Before: Auto, After: Auto, Inside: Auto, Page Break Interval: 0, Master Page: None, Repeat Header: UnTick
Even after setting all the above properties my table does a break at 19 rows.

Please find attached my rptdesign file.

Thanks in advance.
Jai Gharge

Find more posts tagged with

Comments

JaiG

Is there anyone who can help me with above 2 issues?
I am blocked badly.

Jai Gharge

JaiG

Not a single reply :unsure: :unsure:
Sm one please help :wacko: :wacko:

Jai Gharge

Jenkinsj5

This sounds like a problem with the Tribix excel emitter, I don't recall seeing anyone using their tool on here recently. The only excel emitter experts I have seen here recently have been using http://www.spudsoft.co.uk/

Is changing emitters an option for you?

Yaytay

<blockquote class='ipsBlockquote' data-author="'JaiG'" data-cid="115489" data-time="1364478308" data-date="28 March 2013 - 06:45 AM">
2. The Table does a page break which I dont want, below are the properties that I have set: 
Before: Auto, After: Auto, Inside: Auto, Page Break Interval: 0, Master Page: None, Repeat Header: UnTick 
Even after setting all the above properties my table does a break at 19 rows. </blockquote>
Some Excel emitters, including (I think) Tribix, but definitely nou including SpudSoft, introduce page breaks (or new sheets) based on the page size specified in the master page for he report. 
To work around this simply make the master page huge (10m x 10m?). 
This doesn't have any negative effects for Excel output, but obviously results in useless PDF output. 
 
I don't know any other workaround for those emitters. 
 
Your first problem doesn't sound like an emitter problem, do the elements appear with PDF output? 
 
Jim

JaiG

Hi Jenkinsj5,

Thanks for reply.
I tried using Excel emitter given in http://www.spudsoft.co.uk/, it solved the page break issue, but this emitter gave me very bad UI, it cuts across various columns of the table, so I again moved back to Tribix excel emitter. (I have attached 2 excel reports, 1 made by Spudsoft and other by Tribix).
I already have so many reports made with Tribix, that worked well except page break issue which I needed badly for this report.

Hi Yaytay,

You are right by increasing the size of Master Page (earlier it was 11 inches now changed to 100 inches) the page break didn't happen. But to see the pager footer user will have to scroll down 100 inches :unsure: how to fix this?

Also please help me with other issue as well, I need to hide a Image and Label by element ID dynamically in DataSet-fetch script, what is the working code for it? I tried all possibilities mentioned above :unsure:

Thanks in advance,
Jai G

JaiG

Hi Yaytay,

That work around worked for me, also i removed the footer as i wanted only to show a date, i added a text component which shows date after the grid, so user doesn't need to scroll till the end.

The only thing that I am stuck up is :
How to hide Label and Image with its elementID from DataSet open/fetch script?
I tried below codes:

reportContext.getDesignHandle().getElementByID(123).style.display = "none"; OR
reportContext.getDesignHandle().getElementByID(123).getStyle().display = "none"; OR
reportContext.getDesignHandle().getElementByID(123).display = "none"; OR
reportContext.getDesignHandle().getElementByID(123).setProperty('display', 'none');

I do see setProperty actually works, it changes the 'display' to 'none' but it doesn't reflect on UI, i.e. it still shows the Label :unsure:

Jai G.

Yaytay

<blockquote class='ipsBlockquote' data-author="'JaiG'" data-cid="115544" data-time="1364631496" data-date="30 March 2013 - 01:18 AM">
I tried using Excel emitter given in <a class='bbc_url' href='http://www.spudsoft.co.uk/'>http://www.spudsoft.co.uk/</a>, it solved the page break issue, but this emitter gave me very bad UI, it cuts across various columns of the table, so I again moved back to Tribix excel emitter. </blockquote>
 
The SpudSoft emitter is flexible, which means you sometimes have to put more effort in to get the results you want

The overriding rule with the SpudSoft emitter is one cell in equals one cell out, regardless of cell widths. 
This means that your heading block (implemented as a separate grid) doesn't line up with the table of data. 
The fix is simple: introduce extra cells in the grid so it has the same number of columns as the table, then span the grid cells across the appropriate columns. 
 
Unlike the page-size fudge that Tribix requires this fudge won't affect other emitters. 
 
I'm just about to go away for the weekend, but I'll see if I can sort an answer for your other problem next week. 
 
Jim