List Report

[ReportBill]

Hello. New to the forum.  I am trying to create a report in Cognos 10 which will display values for all 50 US states.  I would like the data to be displayed (down 13 entries, then up, over and down 13 and repeat) as follows:

State         Count         State           Count          State           Count
Alabama       50           Kentucky        38            Ohio               17
Alaska          13           Louisiana        22            Oregon           33
Arizona         16           Maine            65             Pennsylvania   45
more.....                      more.........                    more.........

What is the best way to accomplish this task?

Thanks for the help!

[bdbits]

You want a repeater table. There are properties for the repeater table for the number of cells and the order.

[ReportBill]

I tried to add a Repeater Table, but I am only getting one cell.  How do you add cells?  I tried to convert a list, but I only get one cell.

[bdbits]

You mean in design mode or when you run it? Because you only see one cell in design, and it repeats according to the number of rows in the result set ordered as specified in the repeater properties.

If you are only getting one cell when you run the report, then I guess I am wondering if you either only have one row (unlikely) or you did some tweaking that is inadvertently suppressing the repeater cells. Maybe you could attach your report spec, if there isn't anything confidential?