Paginated Report grouping in tablix not working with a single dataset ?

[ashmitp869]

Hi All,

I am getting multiple lines with Qty and Price in Tablix view in Paginated Report.

The dataset is having three lines.

How can I group them together in one line.

PTD Claim =Sum(IIf( Parameters!DateYear.Value(0) <= Fields!Year.Value,
Fields!TotalCost.Value * 1.15,
Nothing))

PTD Qty =Sum(IIf( Parameters!DateYear.Value(0) <= Fields!Year.Value,
Fields!TotalCost.Value * 1.15/Fields!TotalPrice.Value,
Nothing))

Sample rdl file is provided.https://github.com/suvechha/samplepbi/blob/main/sample.rdl

[Anonymous · Accepted solution]

Hi @ashmitp869 

To group multiple lines with Quantity and Price into one line in your Tablix view, you can use the grouping feature in SSRS:

Open your report in Report Builder or SQL Server Data Tools (SSDT).

Select the Tablix where you want to apply the grouping.

Right-click on the row group in the Row Groups pane and select Add Group > Parent Group.

Choose the field you want to group by.

In the group header or footer, use aggregate functions like SUM to combine the quantities and prices.

This will sum up the quantities and prices for each group, displaying them in a single line.

Regards,

Nono Chen

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