table: column grouping

0

Hi,

which report structure would you suggest to create a table with the following layout:

           Category 1      |      Category 2    |     Category X
       -------------------------------------------------------------
       Attr1 Attr2 Attr X  | Attr1 Attr2 Attr X | Attr1 Attr2 Attr X
     -----------------------------------------------------------------
1.1.   val  val   val        val   val   val      ...
2.1.   ...
3.1.   ...
...
31.1.

Data comes from SQL (Dataset) as (time,category,attr,val).

How can I realize these grouping of columns with the table object? I tried to insert group headers into the table->columnHeaderList, but then then content of each category is displayed on a new page.

Thanks!
 

wisoo123's picture
Joined: Jun 18 2013 - 5:40am
Last seen: 3 months 2 days ago

2 Answers:

0

Hi,

This kind of report you can try with crosstab in iReport. Becouse you can able to create subgroup column in crosstab easily than table.

I developed such reports in crosstab becouse such report can easily managed with crosstab than table.

Thanks

Ajinkya

ajinkya_c's picture
935
Joined: Aug 29 2012 - 6:13am
Last seen: 2 years 8 months ago
0

Hi Ajinkya,

you are right - I tried to create a report this weekend using crosstabs, and it worked better than with tables (but maybe it is possible with them too?).

What I couldn´t  implement until now: how can I avoid page breaks inside a column group? For example, in my example above all columns "Attr1"-"AttrX" of "Category 2"  should be displayed on next page, if one or more columns do not fit on the current page.

Wisoo123

wisoo123's picture
Joined: Jun 18 2013 - 5:40am
Last seen: 3 months 2 days ago
Feedback
randomness