Author Topic: List Report  (Read 1168 times)

Offline ReportBill

  • Associate
  • **
  • Join Date: Jul 2015
  • Posts: 3
  • Forum Citizenship: +0/-0
List Report
« on: 28 Jul 2015 12:38:05 pm »
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!

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,787
  • Forum Citizenship: +105/-0
Re: List Report
« Reply #1 on: 28 Jul 2015 03:50:04 pm »
You want a repeater table. There are properties for the repeater table for the number of cells and the order.

Offline ReportBill

  • Associate
  • **
  • Join Date: Jul 2015
  • Posts: 3
  • Forum Citizenship: +0/-0
Re: List Report
« Reply #2 on: 31 Jul 2015 09:05:28 am »
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.

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,787
  • Forum Citizenship: +105/-0
Re: List Report
« Reply #3 on: 31 Jul 2015 03:52:04 pm »
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?

 


       
Twittear