I have a layout that I can't seem to get to work in BIRT. If anybody has an idea, I'd appreciate it.
In this table, I have a set of 13 rows of data. This set also has a date attached, which is stored in the database. For example, for every date entered into the database, I have 13 data points.
I want to display the 13 data points in a column (let's say column A). At the top of each columns is the date. And for each new date, I want to create a whole new column (i.e. column B, C, D, etc.). An example is below:
_____Date1 Date2
Data1 | 1 | 2 |
Data2 | 3 | 4 |
Right now, I seem to have it set up the way I want. It prints properly as long as there is only one date of data. If I add a second date, BIRT (my design) adds the second date below the first date, in the same column (column A, not

. See my results below:
______Date 1
Data1 | 1 |
Data2 | 2 |
Data1 | 3 |
Data2 | 4 |
It is important that I have this format, as having 13 columns across a page for each date(row) would not work properly. I wouldn't have a problem if the page format was in landscape or if it was much larger.
This does bring up a second question. Can I change the page layout to landscape? And how do I do it?
Thanks in advance