Skip to main content



      Home
Home » Archived » BIRT » A strange bug when using many tables
A strange bug when using many tables [message #368378] Tue, 26 May 2009 15:57 Go to next message
Eclipse UserFriend
I have a hierarchy of tables
Table1
Table2
Table3
Table4
Table5
Table6

This means Table1 contains Table2, Table 2 contains Table3, and so on.
Each table's parameters are bound to the former table.

Table4 and Table5 are parallel.
They are both in Table3's detail, but in different rows.

Everything is fine until I add Table6 into Table5.
After I add Table6 (in Table5's detail),
An automatic pagebreak happens between Table4 and Table5.
That is, Table 5 is on the next page, which is not what I want.
No matter I set their pagebreak to "auto" or "avoid," the pagebreak is
there.

This only happens when I use PDF-preview.
However, if I use HTML-preview, the pagebreak is not there.

Is anything wrong in my design? Or what can I do to avoid this?
Thank you.

Larry
Re: A strange bug when using many tables [message #368397 is a reply to message #368378] Wed, 27 May 2009 12:55 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Larry,

Any chance you could create a report using the sample db to show the
problem?

Jason

Larry Li wrote:
> I have a hierarchy of tables
> Table1
> Table2
> Table3
> Table4
> Table5
> Table6
>
> This means Table1 contains Table2, Table 2 contains Table3, and so on.
> Each table's parameters are bound to the former table.
>
> Table4 and Table5 are parallel. They are both in Table3's detail, but in
> different rows.
>
> Everything is fine until I add Table6 into Table5.
> After I add Table6 (in Table5's detail),
> An automatic pagebreak happens between Table4 and Table5.
> That is, Table 5 is on the next page, which is not what I want.
> No matter I set their pagebreak to "auto" or "avoid," the pagebreak is
> there.
>
> This only happens when I use PDF-preview.
> However, if I use HTML-preview, the pagebreak is not there.
>
> Is anything wrong in my design? Or what can I do to avoid this?
> Thank you.
>
> Larry
>
>
Re: A strange bug when using many tables [message #368402 is a reply to message #368397] Wed, 27 May 2009 14:00 Go to previous messageGo to next message
Eclipse UserFriend
Jason,

I put my sample code here:
http://www1.cs.columbia.edu/~wl318/birt/

The sample database is downloaded from here:
http://www.eclipse.org/birt/phoenix/db/mysqlscr/birt-databas e-2_0_1.zip

First try to view this report in PDF:
tabletest.rptdesign

You see table LV1 contains table LV2-1 and LV2-2.
In the PDF report, LV2-2 is right next to LV2-1.

However, check tabletest-ex.rptdesign, in which I added table LV3 in table
LV2-2.
Now, each row of LV2-2 is also on a new page.

Why?
This does not happen in HTML report.


Larry
Re: A strange bug when using many tables [message #368403 is a reply to message #368402] Wed, 27 May 2009 14:03 Go to previous messageGo to next message
Eclipse UserFriend
sorry...
"each row of LV2-2 is also on a new page."
should be
"each row of LV2-2 is always on a new page."
Re: A strange bug when using many tables [message #368407 is a reply to message #368403] Wed, 27 May 2009 15:01 Go to previous messageGo to next message
Eclipse UserFriend
Originally posted by: jasonweathersby.windstream.net

Larry,

I assume you are using BIRT 2.5 to do this? This may be a bug. Can you
open a bugzilla entry for this? BTW could you try to put the nested
tables in the headers and add a group to achieve the same result?


Jason

Larry Li wrote:
> sorry...
> "each row of LV2-2 is also on a new page."
> should be "each row of LV2-2 is always on a new page."
>
Re: A strange bug when using many tables [message #368410 is a reply to message #368407] Wed, 27 May 2009 16:52 Go to previous messageGo to next message
Eclipse UserFriend
Yes, I'm using 2.5.0.
I cannot use group in header because in my real case each table is bound
to a stored procedure.

My ugly solution is making the tables invisible and process each row of
data. And then put all the data I want in arrays. Then make a new table
below everything that only displays the arrays without binding table LV3.


Larry


> Larry,

> I assume you are using BIRT 2.5 to do this? This may be a bug. Can you
> open a bugzilla entry for this? BTW could you try to put the nested
> tables in the headers and add a group to achieve the same result?


> Jason

> Larry Li wrote:
>> sorry...
>> "each row of LV2-2 is also on a new page."
>> should be "each row of LV2-2 is always on a new page."
>>
Re: A strange bug when using many tables [message #368413 is a reply to message #368402] Wed, 27 May 2009 18:08 Go to previous message
Eclipse UserFriend
Just an update about this problem.
I tested a little more.
If all rows in table LV3 can be fit in a single page, then LV2-2 won't
appear in the next page. On the other hand, if the data in LV3 are longer
than a page, then LV2-2's each row will be in a new page.

So, if I set a very small Page Break Interval, such as 1, then there won't
have this strange new page.



> First try to view this report in PDF:
> tabletest.rptdesign

> You see table LV1 contains table LV2-1 and LV2-2.
> In the PDF report, LV2-2 is right next to LV2-1.

> However, check tabletest-ex.rptdesign, in which I added table LV3 in table
> LV2-2.
> Now, each row of LV2-2 is also on a new page.

> Why?
> This does not happen in HTML report.


> Larry
Previous Topic:Null in string concatenation
Next Topic:Pie Chart Legend Auto-Size?
Goto Forum:
  


Current Time: Sat Nov 08 23:11:33 EST 2025

Powered by FUDForum. Page generated in 0.04377 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top