How to merge second row line to first row, in Paginated Report Builder

[Sai_Alkesh]

Hi

I have the following setup

Item No     Category     Direction1     Direction2     Value     Value3

10006        Cat1             Pay                                     100

10006        Cat1                                   Rec                              125

10007        Cat1            Pay                                      98.5   

10007        Cat1                                  Rec                               88.4

How can i show the values for the same item & Category in one row and not have them split into multiple rows.

Any help will be appreciated.

[FarhanAhmed]

You should apply Grouping on "ItemNo and Category" Columns

Understanding groups in a paginated report - Microsoft Report Builder & Power BI Report Builder | Mi...

Add Grouping to Table Reports in SSRS (tutorialgateway.org)

[Sai_Alkesh]

Dear @FarhanAhmed Thank you for the reply, and i did as suggested. Did the grouping based on Item # and Category from the rows tab below the canvas, however the result is still the same. The values are still coming in 2nd row. Tried different combinations for grouping, but didnt work.