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?
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.
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!