Crosstab static column

I need to create a report on BIRT 2.3.0, having cross tab with static columns.

The structure is like:-
Period 1 Period 2
ExpenseA ExpenseB ExpenseA ExpenseB
AREA1
AREA2

See the attached sample report image file.

i.e. there will be column group header which will have multiple columns within that (which will be repeated under each column header). The number of period is fixed let say 10. But the database I am connected to has only 4 periods. And I need to display all 10 periods (filled with 0s in case data is not present).So, in the dimension of the data cube I edited to display 10 Periods, giving the true condition "1==1" (also gave just true). But this does not help.

Any idea, how can this be achieved?

Find more posts tagged with

Comments

mwilliams

Hi AshishK,

So, the database you're connected to currently only has 4 periods, but will at some point have 10 periods?

AshishK

It will, but if it does not have data at any point of time, then also I need to display data for 10 periods.

mwilliams

AshishK,

You could create another dataSet, either scripted or flat file, that has all of the periods represented, do a joint dataSet and merge the data that way. Then you'd have all periods represented every time, regardless of it being returned from your main database.

SrinivasaRao

Hi,

Can you please give any example?

That will be more helpful for me. I also struck at this point.

Thanks