how can i get daily columns instead of rows ?

c031917

I'm looking for a way to transpose a birt report layout from this:

Month Day Name Hours

Jan 09
1 John 2.0
2 Paul 0.5
3 Paul 1.0
31 Jill 2.5

Feb 09
1 John 8.0
1 Jill 9.5
3 Paul 7.5
3 Jill 3.5
...

to that:

Month Name Day1 Day2 Day3 Day4... Day31

...

Jan 09
John 2.0 0.0 0.0 0.0 ... 0.0
Paul 0.0 0.0 7.5 0.0... 0.0
Jill 0.0 0.0 0.0 0.0... 2.5

Feb 09
John 8.0 0.0 0.0 0.0 ... 0.0
Paul 0.0 0.5 1.5 0.0... 0.0
Jill 0.0 0.0 3.5 0.0... 0.0

is there any method to get the daily report results into columns instead of rows ? e.g. computed columns ?

Peter (on Birt 2.2.2)

Find more posts tagged with

Comments

mwilliams

Hi Peter,<br />
<br />
You might be able to get what you're looking for with a parallel type report. You can see an <a class='bbc_url' href='http://www.birt-exchange.com/devshare/designing-birt-reports/510-sample-birt-parallel-sections-example/#description'>example</a> of one in the devShare.<br />
<br />
If you could upgrade to 2.3.1, you could possibly use a crosstab and do horizontal page breaks on the month.

c031917

Hi Michael,

i tried parallel reports and i think it would work. But while trying i discovered an even simpler method:

Make a table with the necessary groupings - outer group on date with interval=month, inner group on user in my case.

Then adding 31 columns, one for each day.

Then adding 31 aggregations on "worked hours", each grouped on user and having a filter entry like this for e.g. day #1 of the month:
row["date"].getDate()==1

down to
row["date"].getDate()==31 for the last column

Place aggregations in 31 columns on group header row for user. Hide outer group header row, discard all footers.

Thanks!

Peter

mwilliams

Peter,

Excellent! Glad you found something to work for you. If you have any other questions, let us know. Thanks!