If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Results on One page in columns Newsprint style

Started by JBCLARK20, 30 Jul 2013 09:43:23 AM

Previous topic - Next topic

JBCLARK20

In report studio 10.2.1, I have a request to list projects in a sorted order on one page using a grid 3 columns wide and 6 rows deep. The first 6 projects should be in the first column, the next six projects should be in the second column and the last six projects should be in the third column. The projects are ordered by project area and stage of completion. Is there a summary function that delivers a record count that could be used to place the projects on the grid?

Lynn

Try using a repeater table with the repeater direction set "top to bottom, left to right". Set Across property to 3 and Down property to 6. Order your projects as desired.

Does that do the trick or is there some other requirement I'm missing? I don't see why you'd need the record count, but there is a count function.

JBCLARK20

Thank you so much. The repeater table, top to bottom, left to right did the trick. I ended up using a calculated ranking function rather than record number to do the final sort. Best!