<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Excel Tab Names in Report Server</title>
    <link>https://community.fabric.microsoft.com/t5/Report-Server/Excel-Tab-Names/m-p/4011716#M35656</link>
    <description>&lt;P&gt;I have created a paginated report in Report Builder from an excel spreadsheet containing information on eight regions of our company. Try as I may, I can't seem to name the tabs using the Region field. If I leave the Tablix PageName empty, the tab names appear as Sheet 1, Sheet 2, etc. but if I add the expression as generated by the program (First(Fields!Region.Value, "Dataset2"), the last Region name is used and the names are US Tri-State 1, US Tri-State 2, etc. I get the same result even if I pare down the expression to just&amp;nbsp; Fields!Region.Value. What am I doing wrong?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-26 113008.png" style="width: 776px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1122693i36B28197C78982BD/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2024-06-26 113008.png" alt="Screenshot 2024-06-26 113008.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
    <pubDate>Wed, 26 Jun 2024 16:41:34 GMT</pubDate>
    <dc:creator>PCorbitt</dc:creator>
    <dc:date>2024-06-26T16:41:34Z</dc:date>
    <item>
      <title>Excel Tab Names</title>
      <link>https://community.fabric.microsoft.com/t5/Report-Server/Excel-Tab-Names/m-p/4011716#M35656</link>
      <description>&lt;P&gt;I have created a paginated report in Report Builder from an excel spreadsheet containing information on eight regions of our company. Try as I may, I can't seem to name the tabs using the Region field. If I leave the Tablix PageName empty, the tab names appear as Sheet 1, Sheet 2, etc. but if I add the expression as generated by the program (First(Fields!Region.Value, "Dataset2"), the last Region name is used and the names are US Tri-State 1, US Tri-State 2, etc. I get the same result even if I pare down the expression to just&amp;nbsp; Fields!Region.Value. What am I doing wrong?&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot 2024-06-26 113008.png" style="width: 776px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1122693i36B28197C78982BD/image-size/large?v=v2&amp;amp;px=999" role="button" title="Screenshot 2024-06-26 113008.png" alt="Screenshot 2024-06-26 113008.png" /&gt;&lt;/span&gt;&lt;/P&gt;</description>
      <pubDate>Wed, 26 Jun 2024 16:41:34 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Report-Server/Excel-Tab-Names/m-p/4011716#M35656</guid>
      <dc:creator>PCorbitt</dc:creator>
      <dc:date>2024-06-26T16:41:34Z</dc:date>
    </item>
    <item>
      <title>Re: Excel Tab Names</title>
      <link>https://community.fabric.microsoft.com/t5/Report-Server/Excel-Tab-Names/m-p/4012083#M35659</link>
      <description>&lt;P&gt;Are you using the PageName on a row group for "&lt;SPAN&gt;Region"?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Also, I'd try the following:&lt;/SPAN&gt;&lt;/P&gt;&lt;LI-CODE lang="markup"&gt;=Fields!Region.Value &lt;/LI-CODE&gt;</description>
      <pubDate>Wed, 26 Jun 2024 23:01:01 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Report-Server/Excel-Tab-Names/m-p/4012083#M35659</guid>
      <dc:creator>aduguid</dc:creator>
      <dc:date>2024-06-26T23:01:01Z</dc:date>
    </item>
  </channel>
</rss>

