Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
TSJ_Aviman
New Member

Paginated Report - How to add a parent column after child columns?

I have the following grouping structure of my tablix below. The first two columns are of the parent group. The third column and subsequent columns are all child columns. How do I create a parent column after the child columns i.e. after "Rental"? Everytime I create a new parent column, it gets placed after "Bid Due Date".

 

Edit: Apologies in advanced if this has been asked before. I searched the forum but did not find anything.

 

Thanks in advance!

 

TSJ_Aviman_1-1775143603953.png

 

1 ACCEPTED SOLUTION
cengizhanarslan
Super User
Super User

The UI always anchors a new parent group column to the left boundary of the current parent group, you cannot drag it past the child columns using the standard insert menu.

 

The correct approach is to insert outside the group boundary using the column header:

  1. Right-click on the column header cell of the last child column ("Rental"), not the row group panel, but the actual cell in the tablix header row
  2. Select Insert Column → Outside Group – Right
_________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Connect on LinkedIn | Follow on Medium
AI-assisted tools are used solely for wording support. All conclusions are independently reviewed.

View solution in original post

4 REPLIES 4
v-sathmakuri
Community Support
Community Support

Hi @TSJ_Aviman ,

Could you please let us know if you are still facing the same issue?


Thanks!!

v-sathmakuri
Community Support
Community Support

Hi @TSJ_Aviman ,

 

Thanks @cengizhanarslan  and @Thomaslleblanc  for the prompt respone.

I hope above provided solution helped in resolving the issue. If you have anything else to check we would be happy to address.

Thanks!!

cengizhanarslan
Super User
Super User

The UI always anchors a new parent group column to the left boundary of the current parent group, you cannot drag it past the child columns using the standard insert menu.

 

The correct approach is to insert outside the group boundary using the column header:

  1. Right-click on the column header cell of the last child column ("Rental"), not the row group panel, but the actual cell in the tablix header row
  2. Select Insert Column → Outside Group – Right
_________________________________________________________
If this helped, ✓ Mark as Solution | Kudos appreciated
Connect on LinkedIn | Follow on Medium
AI-assisted tools are used solely for wording support. All conclusions are independently reviewed.
Thomaslleblanc
Super User
Super User

Y

ou can’t insert a parent column after child columns by using the normal “Insert Column” options, because SSRS always anchors parent group columns to the left of their child groups. That’s why your new parent column keeps jumping back to the “Bid Due Date” area — SSRS is enforcing the group hierarchy.

But you can achieve the layout you want. You just have to use a different technique.

Add a regular (non‑grouped) column to the far right

This is the simplest and most common workaround.

Steps:

  1. Right‑click the tablix body (not the group header).

  2. Choose Insert Column → Right.

  3. Place your “parent” data there.

 

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.