CODEWITHSUNDEEP
ssrs-2008reporting-servicesssrs-grouping
Alaa Awad
Alaa Awad

Reputation: 4152

SSRS get the last row on each page

In SQL Server Reporting Services I have a row group with a dashed bottom border separating each row. I want to remove that dashed border from the last row on each page. How do I calculate the last row on each page?

I counted 25 rows on the first page, so I tried this:

iif((rownumber(nothing) MOD 25)=0,nothing,"Dotted")

But on page 2 some rows had so much text in a column that in the end the page only had 24 rows, so the row number changes based on amount of text. I need a new approach. Has anyone had experience with this kind of issue?

Upvotes: 0

Views: 3160

Answers (1)

djangojazz
djangojazz

Reputation: 13242

Why don't you just present a row grouping and then determine the properties on that? Choose the details row and then select 'Row Groups' and choose 'Add Group'>'Parent Group'. Define your logic for getting a total, add a footer if you want it at the bottom. Choose 'Page Breaks' and then report will break on grouping for a new page. Address the properties for the footers.

Upvotes: 1

Related Questions