CODEWITHSUNDEEP
reporting-servicesssrs-2008ssrs-2012ssrs-2008-r2reportingservices-2005
Ramanathan N
Ramanathan N

Reputation: 1

First of Function in SSRS / show first row of each page

In my SSRS report, I have more than 500 pages. In the header section, I have used an textbox with expression First (Productname), where the productname is one of the column in my report.

How to display the First row productname of each page on that control? Now it will always display the first row productname of first page on all the pages.

Upvotes: 0

Views: 1310

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21738

You need to use the ReportItems collection. Get the name of the cell that contains the text you want by clicking it and looking at the properties, assuming the name is myColumnCell then the expression in you header cell would be

=First(ReportItems!myColumnCell.Value)

Look here for more details if required.

https://learn.microsoft.com/en-us/sql/reporting-services/report-design/built-in-collections-reportitems-collection-references-report-builder

Upvotes: 1

Related Questions