Group in separate tables

Hi all¡

I have a new problem with one of my reports...

I have build a DataSet with the following datas:

HOUR ENERGY

In the report I need to put these two datas in tables. The problem is that I have to separate the datas in different tables (grouping by DAY).

I have tried to resolve the problem with a Cross Tab, but I need to repeat the column of HOUR in every table.

Anybody can help me?

Thanks¡
Ele

Find more posts tagged with

Comments

Virgil Dodson

Hi Ele,

Can you add more details on what the input looks like... and then the final result you are looking for?

Ele

Hi Virgil,

I need something similar to this example:

Day 1 Day 2 Day 3

Hour Energy Hour Energy Hour Energy

00:00 X 00: 00 X 00: 00 X
01:00 X 01:00 X 01:00 X
02:00 X 02:00 X 02:00 X
03:00 X 03:00 X 03:00 X
04:00 X 04:00 X 04:00 X
05:00 X 05:00 X 05:00 X
06:00 X 06:00 X 06:00 X
07:00 X 07:00 X 07:00 X
08:00 X 08:00 X 08:00 X
09:00 X 09:00 X 09:00 X
10:00 X 10:00 X 10:00 X
11:00 X 11:00 X 11:00 X
12:00 X 12:00 X 12:00 X
13:00 X 13:00 X 13:00 X
14:00 X 14:00 X 14:00 X
15:00 X 15:00 X 15:00 X
16:00 X 16:00 X 16:00 X
17:00 X 17:00 X 17:00 X
18:00 X 18:00 X 18:00 X
19:00 X 19:00 X 19:00 X
20:00 X 20:00 X 20:00 X
21:00 X 21:00 X 21:00 X
22:00 X 22:00 X 22:00 X
23:00 X 23:00 X 23:00 X
24:00 X 24:00 X 24:00 X

With the CrossTab, the result is:

Day 1 Day 2 Day 3
00:00 X X x
01:00 X X x
02:00 X X x
03:00 X X x
04:00 X X x
05:00 X X x
06:00 X X x
07:00 X X x
08:00 X X x
09:00 X X x
10:00 X X x
11:00 X X x
12:00 X X x
.
.
.
.
23:00 X X x
24:00 X X x

Thank you very much¡
Ele

Virgil Dodson

Hi Ele,

To get the hour to repeat, you need to add another summary field to the Data Cube. Select your hour field, and then Edit this measure so that it uses FIRST occurance of this value instead of the default SUM. You can now drop both measures into the crosstab to get the hour to repeat for each column.

If there will always be three days, then you could also create 3 different crosstabs from the same Data Cube and put each in a grid column. Then use the filter property to keep each crosstab focused on a single day of data.

I put both approaches in the enclosed example created with BIRT 2.2.2

Ele

Hi Virgil,

Thank you for the help, but the problem is that the number of days isn't always the same...

Regards,
Ele

Virgil Dodson

Hi Ele,

There are two different approaches in the report design. The first approach uses seperate crosstabs and a defined number of days. The second approach in that file will work for multiple days that grow to the right.