I got my initial idea for this from here.

http://www.easkills.com/ssrs/determinepagenumberinssrs20052008

That source did not quite produce the results I was expecting, so that is when I brought in the use of the...

I figured out how to handle this in T-SQL for 2005.

DECLARE @RowsPerPage int

SELECT @RowsPerPage = 2

;WITH TotalPages

AS

(

SELECT [CheckNumber], [TotalPagesPer] = CEILING(CAST(COUNT(*) AS decimal(10,4)) / CAST(@RowsPerPage AS decimal(10,4)))

FROM Table1

GROUP BY [CheckNumber]

)

SELECT

@RowsPerPage...

I believe I may be able to handle this through the ranking functions, where I determine which page the details need to display on. Just not sure yet how to...

I was under the understanding that you can no longer query system tables. At a glance, I deemed sys.objects to be a system table. But now after doing further research,...

To Ghanta Bro - Yeah, I have done it that way in the past with a smaller set of data, but it was very time consuming. I was hoping to...