I am creating a report with a table that is grouped company. Each company is on a separate page and the grouping is by company. I need to print the company name in the header of the page. Currently the First company in the report query is printed on every page. I'm using SQL Server Reporting Services for SQL 2008 R2. How can I print the correct company on each page.
Thanks!
Microsoft SQL ServerSSRS
Last Comment
Arifhusen Ansari
8/22/2022 - Mon
Megan Brooks
The header expression may contain the First() function. There are special rules for header text box expressions. You can read about the details here.