How to add row group next to None row Group in Power bi report builder/SSRS

[meghnath2911]

SLNo	OrderNo	State	County	Comment
1	51294AB	CA	County1	Comment1
2	76011AB	TX	County2
3	33780AB	DC	County3
4	90228AB	IA	County4	Comment2
5	57194AB	MO	County5
6	38812AB	MT	County6
7	90208AB	LA	County7	Comment3
8	39402AB	KS	County8
9	72969AB	ME	County9

"I'm just stuck here. How do I build a report like the one above in Power BI Report Builder? Kindly explain it step by step."

[meghnath2911]

I don't think my requirement can be accomplished in a paginated report.

[d_gosbell · Accepted solution]

Your example report just looks like a list of detailed rows. I cannot see anything that looks like it requires an additional row group. It looks like you should be able to get the output you want just using the default detail row group.

[meghnath2911]

I have created the table above with the help of Excel. In the "Comment" column, there were multiple identical values (Comment1, Comment1, Comment1). To avoid displaying them multiple times, I centered and merged them, similar to the rest of the values. Now, I want to recreate the same table in Power BI Report Builder. Could you please guide me on how to perform this task?

[d_gosbell]

Ok, so that was not clear from your initial post. I don't believe there is a way to create groupings on the right. Groupings are always added on the right and top of a tablix.

There are 2 possibly workarounds:

1. You can create the look from your initial post, by setting the HideDuplicates of the Comment cell to the name of your dataset
2. Or you could create a second tablix to the right of your first, using the same dataset, but with a grouping on Comment and only having SLNo in the details, but hiding the detail column

This produces output like the following. It should be possible to move the second tablix right up against the first one so that they appear as a single table. I've left some space for illustration purposes.

[meghnath2911]

    I have done as you instructed below.

Below is desired result

Thank you very much for your assistance. I achieved a 99% success rate with your help. However, my main challenge now is figuring out how to merge-center, as shown in the desired result.

[d_gosbell]

So I posted 2 suggestions in my previous reply. 

1. Use the HideDuplicates option - this gets you output like the example you initially posted

2. Use a second tablix - this will allow you to do the merge and center

[meghnath2911]

1. I tried what you said, but adding a row group does not work because if I add a row group, it will automatically jump into the column before the "SL No" column.
2. If you can perform an advanced merge cell operation, that would be helpful, as row merging does not work.

[Anonymous]

Hi @meghnath2911 ,

Please follow these steps to achieve your goal:

1. Create Data Sources and Datasets

          Create a dataset by using the query designer or writing the query manually to fetch the data you need for the report.

      2.Insert a Table and add row group 

         In the 'Row Groups' pane at the bottom of the Report Builder, right-click on 'Details' and choose 'Add Group'.

         Select 'Parent Group' if you want to create a higher-level grouping.

      3.Design the Report Layout

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.