Horizontal table?

Novice
edited February 11, 2022 in Analytics #1
Hi,

i am completely new to BIRT. So maybe the solutions could be quite easy.
I am using the BIRT RCP Designer to create a report.

How can i create a horizontal table, like the following

SQL Database
No Name Age (column name)
1 ...a ... 12
2 ... b ... 13
3 ... c ... 14


and i want a table like that :
No ...... 1 ... 2 .... 3
Name ...a ... b .... c
Age .... 12 ..13 .. 14

The only thing i managed so far was using cross tab and draggin all 3 fields to
<Datafields to define columns>. But then i get something like
1 .. 2 .. 3
a .. b .. c
12 .13 . 14

all bold as headers and the column name is missing.

P.S. How to make tables in this forum ?

Comments

  • Novice
    edited December 31, 1969 #2
    Another question is :

    when the table is growing to the side, how to make sure, that there are page breaks ?
  • PuckPuck
    edited December 31, 1969 #3
    The crosstab control is what you need to make this happen. You may need to change the measures, and/or dimensions to get the desired output. Also you can change the default fonts, bolding, etc for the headers to get the look and feel you truly desire.
    Warning No formatter is installed for the format ipb
  • Novice
    edited December 31, 1969 #4
    Okay, thanks.