<?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 Re: Creating Hierarchy in the Same Column in Paginated Report in Developer</title>
    <link>https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy-in-the-Same-Column-in-Paginated-Report/m-p/4060481#M54343</link>
    <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/656661"&gt;@bchappidi&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;
&lt;P&gt;You can refer the following links to get it:&lt;/P&gt;
&lt;P&gt;&lt;A href="https://learn.microsoft.com/en-us/sql/reporting-services/report-design/create-a-recursive-hierarchy-group-report-builder-and-ssrs?view=sql-server-ver16" target="_blank" rel="noopener"&gt;Create a recursive hierarchy group in a paginated report - Microsoft Report Builder&lt;/A&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/grouping-pane-report-builder" target="_blank" rel="noopener"&gt;Grouping pane in a Power BI paginated report - Power BI | Microsoft Learn&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyiruanmsft_0-1721878477972.png" style="width: 999px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1138458i9BB5580B9A5FA8EB/image-size/large?v=v2&amp;amp;px=999" role="button" title="vyiruanmsft_0-1721878477972.png" alt="vyiruanmsft_0-1721878477972.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-or-delete-a-group-in-a-data-region-report-builder-and-ssrs?view=sql-server-ver16" target="_blank" rel="noopener"&gt;Add or delete a group in a data region in a paginated report - Microsoft Report Builder&lt;/A&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;And you can follow the steps below to get it:&lt;/P&gt;
&lt;P&gt;1. Insert a table&lt;/P&gt;
&lt;P&gt;2. Drag one field which you want it to be as a hirerachy onto the table&lt;/P&gt;
&lt;P&gt;3. Select the table and right-click to select "&lt;STRONG&gt;Insert Row&lt;/STRONG&gt;"--&amp;gt;"&lt;EM&gt;Inside group - Below&lt;/EM&gt;"&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyiruanmsft_1-1721893082235.png" style="width: 999px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1138668i8614D7D99E1CCECB/image-size/large?v=v2&amp;amp;px=999" role="button" title="vyiruanmsft_1-1721893082235.png" alt="vyiruanmsft_1-1721893082235.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;4. Change the text display position for every hierarchy&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyiruanmsft_2-1721893268044.png" style="width: 999px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1138672iF3984B61F1BA2846/image-size/large?v=v2&amp;amp;px=999" role="button" title="vyiruanmsft_2-1721893268044.png" alt="vyiruanmsft_2-1721893268044.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;Best Regards&lt;/P&gt;</description>
    <pubDate>Thu, 25 Jul 2024 07:41:20 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-07-25T07:41:20Z</dc:date>
    <item>
      <title>Creating Hierarchy in the Same Column in Paginated Report</title>
      <link>https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy-in-the-Same-Column-in-Paginated-Report/m-p/4057821#M54320</link>
      <description>&lt;P&gt;Hi Everyone,&lt;/P&gt;&lt;P&gt;I have a question about how we can create a hierarchy in the same column in a paginated report, as shown in the attached screenshot.&lt;/P&gt;&lt;P&gt;When I create row groups, the hierarchy levels are showing as different columns. Please let me know how to achieve this.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Expected design /output:&lt;/P&gt;&lt;P&gt;**************************&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="Capture123.PNG" style="width: 616px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1137651iB5695862A477C42A/image-size/large?v=v2&amp;amp;px=999" role="button" title="Capture123.PNG" alt="Capture123.PNG" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I want a hierarchy similar to the one mentioned in the link below&lt;/P&gt;&lt;P&gt;&lt;A href="https://www.reporting-services.eu/index.php/2019/06/22/splitting-merging-cells-in-tablix/" target="_blank"&gt;https://www.reporting-services.eu/index.php/2019/06/22/splitting-merging-cells-in-tablix/&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you!&lt;/P&gt;</description>
      <pubDate>Wed, 24 Jul 2024 09:31:20 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy-in-the-Same-Column-in-Paginated-Report/m-p/4057821#M54320</guid>
      <dc:creator>bchappidi</dc:creator>
      <dc:date>2024-07-24T09:31:20Z</dc:date>
    </item>
    <item>
      <title>Re: Creating Hierarchy in the Same Column in Paginated Report</title>
      <link>https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy-in-the-Same-Column-in-Paginated-Report/m-p/4060481#M54343</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/656661"&gt;@bchappidi&lt;/a&gt;&amp;nbsp;,&lt;/P&gt;
&lt;P&gt;You can refer the following links to get it:&lt;/P&gt;
&lt;P&gt;&lt;A href="https://learn.microsoft.com/en-us/sql/reporting-services/report-design/create-a-recursive-hierarchy-group-report-builder-and-ssrs?view=sql-server-ver16" target="_blank" rel="noopener"&gt;Create a recursive hierarchy group in a paginated report - Microsoft Report Builder&lt;/A&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/grouping-pane-report-builder" target="_blank" rel="noopener"&gt;Grouping pane in a Power BI paginated report - Power BI | Microsoft Learn&lt;/A&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyiruanmsft_0-1721878477972.png" style="width: 999px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1138458i9BB5580B9A5FA8EB/image-size/large?v=v2&amp;amp;px=999" role="button" title="vyiruanmsft_0-1721878477972.png" alt="vyiruanmsft_0-1721878477972.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&lt;A href="https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-or-delete-a-group-in-a-data-region-report-builder-and-ssrs?view=sql-server-ver16" target="_blank" rel="noopener"&gt;Add or delete a group in a data region in a paginated report - Microsoft Report Builder&lt;/A&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;And you can follow the steps below to get it:&lt;/P&gt;
&lt;P&gt;1. Insert a table&lt;/P&gt;
&lt;P&gt;2. Drag one field which you want it to be as a hirerachy onto the table&lt;/P&gt;
&lt;P&gt;3. Select the table and right-click to select "&lt;STRONG&gt;Insert Row&lt;/STRONG&gt;"--&amp;gt;"&lt;EM&gt;Inside group - Below&lt;/EM&gt;"&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyiruanmsft_1-1721893082235.png" style="width: 999px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1138668i8614D7D99E1CCECB/image-size/large?v=v2&amp;amp;px=999" role="button" title="vyiruanmsft_1-1721893082235.png" alt="vyiruanmsft_1-1721893082235.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;4. Change the text display position for every hierarchy&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="vyiruanmsft_2-1721893268044.png" style="width: 999px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1138672iF3984B61F1BA2846/image-size/large?v=v2&amp;amp;px=999" role="button" title="vyiruanmsft_2-1721893268044.png" alt="vyiruanmsft_2-1721893268044.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;Best Regards&lt;/P&gt;</description>
      <pubDate>Thu, 25 Jul 2024 07:41:20 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Developer/Creating-Hierarchy-in-the-Same-Column-in-Paginated-Report/m-p/4060481#M54343</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-07-25T07:41:20Z</dc:date>
    </item>
  </channel>
</rss>

