Eclipse Community Forums: BIRT » How to customize table header of cross tab

Home » Archived » BIRT » How to customize table header of cross tab

How to customize table header of cross tab [message #262502]

Fri, 30 November 2007 19:25

Eclipse User

Originally posted by: wang1a.yahoo.com

I am new in BIRT technology.

I need to customize order of header in a cross tab.
For instance,
for default order cross tab
col1 col2 col3
row1
row2

Now I need is
col3 col1 col2
row1
row2

And recommendation?

Thanks in advance,

Jay

Re: How to customize table header of cross tab [message #262517 is a reply to message #262502]

Sun, 02 December 2007 13:58

Eclipse User

Originally posted by: calvinwongkh_delete.this.thanks_.yahoo.com

Hi Jay,

I know that when I design a static cross tab using a table, I can rename
columns in the dataset query definition at the SQL Select statement like
"SELECT product as col1, location as col2,...". That way I can swap the
groups in the beforeOpen script where I can alter the queryText by
swapping the product to col2 and location to col1 in the above example.

The catch though is that product and location have to be the same
datatype (like if they are ID numbers they are all Decimals) or maybe
the datatype for those columns are defined as "Any", or all converted to
String.

Cheers,
Calvin Wong

Jay wrote:
> I am new in BIRT technology.
>
> I need to customize order of header in a cross tab.
> For instance, for default order cross tab
> col1 col2 col3
> row1
> row2
>
> Now I need is col3 col1 col2
> row1
> row2
>
> And recommendation?
>
> Thanks in advance,
>
> Jay
>

Re: How to customize table header of cross tab [message #262982 is a reply to message #262502]

Sun, 09 December 2007 21:28

Eclipse User

Jay,

You can just specify a Sorting for the column level if the desired order
is ascending or descending. otherwise it's not possible.

Jay wrote:
> I am new in BIRT technology.
>
> I need to customize order of header in a cross tab.
> For instance, for default order cross tab
> col1 col2 col3
> row1
> row2
>
> Now I need is col3 col1 col2
> row1
> row2
>
> And recommendation?
>
> Thanks in advance,
>
> Jay
>

Previous Topic:	Crosstab sub-total location
Next Topic:	Exception w/ page breaks in web viewer

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Jul 17 19:32:28 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter