I have SQL Server 2008 R2 installed and am trying to utilize the new "Page Name" property. I find it works great if I'm setting a static value however now I'm adding a Row Group and I'm doing a Page Break after each Location name and when I export to MS Excel, it's only taking the FIRST Location Name and naming ALL the tabs that name. I have gone as far as writing a method in the code of the report to get and set a public variable and that doesn't seem to work either. Any help is GREATLY appreciated. Thanks!

This sounds like a function scope problem. When you say that every page has the name of the first value, this is probably because the expression is implicitly applying the FIRST aggregate function to the entire dataset. There are a couple different ways to handle this. Try referencing the name of the Textbox in the group header containing the value, like: =ReportItems!LocationName.Value There is an example of this solution in the download samples for our report recipe book at: http://www.wrox.com/WileyCDA/WroxTitle/Microsoft-SQL-Server-Reporting-Services-Recipes-for-Designing-Expert-Reports.productCd-0470563117,descCd-DOWNLOAD.htmlPaul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*