BIRT 2.3.2 and Dual Column Listing Report

ikerarbizu

Hello everyone,
Hi have a sentence like this:
"select ID from FILES where FILES.FILE_TYPE='Photo'"
so I get a table this way:
ID
100
101
200
394
...

I need to show it in a table with 2 columns and 3 rows (no matter if it has more than 6 results, I only need the first 6 of them).

I have tried with the template but when I try with the "preview" option I get the rows this way:

ID ID
100 100
101 101
200 200
394 294
... ...

insted of what I need, that is:

ID ID
100 394
101 ...
200

or (even better):
ID ID
100 101
200 394
...

(I don?t need the headers, so the "ID" on the top of the tables is not important for the layout and all that things)

I really need a "step by step" explanation or a tutorial, becouse I can?t understand how the dual column works, and I have to make this report.

Thanks a lot!!!

mwilliams

You should be able to set the limit to how many records you want to return in your query. You can also do it within BIRT if you'd like under the settings in the dataSet editor or by using a filter on your table. Also in the dataSet editor, go to computed columns and add a computed column that uses the aggregation "runningcount". In your layout, you'll put a grid with 2 columns and 1 row. You'll put the same table in both cells of the grid. Then, in each table, you'll make a filter based on the computed column you made. In the left table, you'll put row["computedColumn"]%2 equal to 1. For the right table, you'll put the filter for row["computedColumn"]%2 equal to 0. If you haven't limited your results in your dataSet, you'll also want to add a filter in each table to limit the results to the first 6, with row["computedColumn"] less than or equal to 6. It should now do what you want. Let me know if you have questions.