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

All responses (5)

Answers (0)

Suggested answer

Waed Ayyad 6,556 Super User 2024 Season 2 on at

Like (0)

Report

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

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
Layan Jwei 7,266 Super User 2024 Season 2 on at

Like (0)

Report

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

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
Sachin Mittal on at

Like (1)

Report

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

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
Layan Jwei 7,266 Super User 2024 Season 2 on at

Like (1)

Report

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

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
Suggested answer

Mohamed Amine Mahmoudi 10,694 Super User 2024 Season 2 on at

Like (1)

Report

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

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