Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Wrapping in Cross Tab(How to wrap a Cross Tab to the next section automatically, when there are too many columns ?)
Wrapping in Cross Tab [message #632973] Thu, 14 October 2010 16:53 Go to next message
Jay Jakilinki is currently offline Jay Jakilinki
Messages: 11
Registered: October 2010
Junior Member
Hello

Is it possible to wrap the columns in a Cross Tab element to the next section when there are too many columns ? The next section would have the Row headers, just the remaining columns will appear in the next section.

For example, if there are 20 columns (based upon the data off course), in the Cross Tab, is it possible to have 1-10 in the first Cross Tab and the remaining 11 - 20 in the next Cross Tab ?

Please advice.
Re: Wrapping in Cross Tab [message #632987 is a reply to message #632973] Thu, 14 October 2010 17:58 Go to previous messageGo to next message
Jay Jakilinki is currently offline Jay Jakilinki
Messages: 11
Registered: October 2010
Junior Member
Update -

I am using BIRT 2.5.2

I stumbled into the "Column Area" tab in the Property Editor and started playing with the Page Break. I think this would work, unless the report users want the next section to be displayed just below the first section instead of in the next page.

This seems to be hard to do, right ?
Re: Wrapping in Cross Tab [message #633231 is a reply to message #632987] Fri, 15 October 2010 14:25 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

Jay,

If you do not want the page break you could always put the same crosstab
right below the first and then filter the top one based on dimension
values and then filter the bottom on dimension values. For example the
top one would be filtered to show values for last year and the bottom
one would be filtered to show this year. Does this make sense?

Jason

On 10/14/2010 5:58 PM, Jay Jakilinki wrote:
> Update -
> I am using BIRT 2.5.2
>
> I stumbled into the "Column Area" tab in the Property Editor and started
> playing with the Page Break. I think this would work, unless the report
> users want the next section to be displayed just below the first section
> instead of in the next page.
> This seems to be hard to do, right ?
Re: Wrapping in Cross Tab [message #633613 is a reply to message #633231] Mon, 18 October 2010 10:44 Go to previous messageGo to next message
Jay Jakilinki is currently offline Jay Jakilinki
Messages: 11
Registered: October 2010
Junior Member
Thanks Jason.

So, I have 2 options to consider:
1- Use the Page Break or the Page Break Interval in the Column Area
2- Create 2 Cross Tabs and apply filters.

Let me work on the report and will keep you posted.
Re: Wrapping in Cross Tab [message #633620 is a reply to message #633613] Mon, 18 October 2010 10:51 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

That is correct. Let me know how it goes.

Jason

On 10/18/2010 10:44 AM, Jay Jakilinki wrote:
> Thanks Jason.
>
> So, I have 2 options to consider:
> 1- Use the Page Break or the Page Break Interval in the Column Area
> 2- Create 2 Cross Tabs and apply filters.
>
> Let me work on the report and will keep you posted.
Re: Wrapping in Cross Tab [message #634380 is a reply to message #633620] Thu, 21 October 2010 09:36 Go to previous message
Jay Jakilinki is currently offline Jay Jakilinki
Messages: 11
Registered: October 2010
Junior Member
Hi Jason

I worked it out with the users to display the data in one Cross Tab across the rows with no column split. So, I evaded the trouble of creating a second Cross Tab and filtering.

Thanks much for your time and responses.
Previous Topic:Horizontal span?
Next Topic:Suppress Duplicates
Goto Forum:
  


Current Time: Fri Aug 22 15:50:12 EDT 2014

Powered by FUDForum. Page generated in 0.03180 seconds