CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2008ssrs-2012ssrs-tablix
KCodeR
KCodeR

Reputation: 139

SSRS limit number of rows returned for each column on report

I currently have a report which is set up to print name tags, I have created already 2 columns for the report and have a table within a list to group each person however at the moment when displaying as PDF it displays loads of names on page.

What I now need is that when display in PDF or Word, I need to limit the numbers of names returned in each of the columns to only 4 rows in each column giving a total of 8 names in the whole page.

Is this possible and how to achieve?

Similar to the below format:

Record 1    Record 5

Record 2    Record 6

Record 3    Record 7

Record 4    Record 8

Upvotes: 0

Views: 1431

Answers (1)

Hannover Fist
Hannover Fist

Reputation: 10860

I did something similar before.

You can set the Row Grouping to 

=INT((CountRows() - 1) / 4) + 1

This will set the first four name tags to line 1, the next 4 to line 2 and so on.

Then set Column Grouping to use the remainder (MOD) of the Row Number (CountRow) 

=CountRows() MOD 4

This will set Member tag 1 to column 1, 2 to column 2 and so on.

Of course I can't find the report that has this right now - I don't remember if there was an issue using CountRows and I had to use ROW_NUMBER in the query.

Upvotes: 1

Related Questions