Horizontal table (Cross Table)

Hi, I'm new to BIRT and trying to display a horizontal table. So far I'm experiencing with the cross tables, but didn't get it. 
 
Having the following input data: 
<pre class='_prettyXprint _lang-auto _linenums:0'>
(date) (name) (phone) (Bool 1) (Bool 2)
2011-11-01 a 123 x x
2011-11-02 a 123 x -
2011-11-03 a 123 - -
2011-11-23 a 123 x x
2011-12-01 a 123 x -
2011-12-02 a 123 - -
2011-11-04 b 999 x -
2011-12-06 b 999 - -
</pre>
I would like to be able to display this data in the following way: 
<pre class='_prettyXprint _lang-auto _linenums:0'>

| a Phone: 123 |

| |Date |01|02|03|23|
| Nov. 2011 |Bool1|x |x |- |x |
| |Bool2|x |- |- |x |

| |Date |01|02| |
| Dec. 2011 |Bool1|x |- | |
| |Bool2|- |- | |

| b Phone: 999 |

| |Date |04| |
| Nov. 2011 |Bool1|x | |
| |Bool2|- | |

| |Date |01| |
| Dec. 2011 |Bool1|- | |
| |Bool2|- | |

</pre>
I'm able to display the name, phone and month in a normal table with 2 groups (name and date with interval month), but I have no clue on how to display the day, bool1 and bool2 in a horizontal table. 
 
Is that possible? 
Thanks for any suggestions in advance! 
 
Regards, 
Philipp

Find more posts tagged with

Comments

mwilliams

This isn't exactly what you're wanting, but it's close. You could probably tweak it a little more to get closer to what you're wanting. Let me know if you have questions! This report was made in 3.7.0. Be sure to change the location of the csv file in the dataSource to the location that you save the file.

pstein

Great, that help me a lot. Thank you so much!

mwilliams

You're welcome! Let us know whenever you have questions!

bhairavchampawat

Hi, Can I transpose my table using Cross table from X |A|B|C

T|1|34|5F|6|9|7 to X|T|F

A|1|6B|34|9C|5|7 C||

mwilliams

You can choose whichever dimension you want as the column vs row dimension. If you mean on the fly while running the report, you'd have to create a copy of both ways and hide/show with javascript to do this. Let me know if I'm misunderstanding.

Mayur Borgaonkar

Hi Michael,
 
Can I use Crosstab with secondary data sets? My requirement is to show the data in secondary data set in the cross tab. While creating Cube, I see that I can select secondary data set, but I am missing the parameter binding here.
 
Please let me know your thoughts. Thanks.