Finance | Project Operations, Human Resources, ...

How to Fix SSRS report Tablix , row grouping generating extra lines ,

(2) Share

Report

Posted on by Sachin Mittal

I have a Tablix in SSRS report , and that grid have these all fields , I have grouped row on three fields HSN Code , IGST rat , CGST rate , SGST Rate , and it should produced onlyone line as per the case , but its generating three lines I don't know how

After grouping

Before Grouping

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Sachin,

I see that you've used four fields for grouping and the view is obviously correct because the lines aren't identical.

BR

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (1)

Report

Hi Sachin,

Can you send us how would you like the expected result to be by drawing a table with values?

Because I can see CGST and SGST values are different so it makes sense that it won't produce one line only

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Sachin Mittal 2 on at

Like (1)

Report

I want grouping for line as per HSN codes and all rates, if these values are same, it should be grouped and for amount fields it should add them if all grouping condition met, I want result like this, for before grouping Tablix (added Sc)

desired result

for this Tablix

Was this reply helpful? Yes No
Layan Jwei 8,097 Super User 2025 Season 2 on at

Like (0)

Report

Hi Sachin,

I just noticed that the first screenshot in the question is after grouping and not vice versa

Check out this article about grouping to see what u did wrong (maybe it's helpful)

https://medium.com/@mohammed.talha.k9/d365fo-grouping-in-ssrs-report-design-7eb7f971b920

Thanks,

Layan Jweihan

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Did you try to use matrix? I think you can use the column group for (IGST rate , CGST rate , SGST rate) and row group for HSN.

Check this blog about Matrix in SSRS report:

https://help.boldreports.com/enterprise-reporting/designer-guide/report-designer/report-items/matrix/design-ssrs-matrix-report/

Thanks,
Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No