topic Re: How to merge second row line to first row, in Paginated Report Builder in Report Server

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

Sai_Alkesh — Sat, 16 Apr 2022 10:55:10 GMT

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.

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

FarhanAhmed — Mon, 18 Apr 2022 03:10:58 GMT

You should apply Grouping on "ItemNo and Category" Columns

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

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

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

Sai_Alkesh — Mon, 18 Apr 2022 11:46:42 GMT

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.