CODEWITHSUNDEEP
reporting-servicesssrs-grouping
Roman
Roman

Reputation: 37

How to group by some column and show grouped value within existed another column

I would like to implement grouping, where values I need group by, may be shown within other existed column.

Please, see screenshot:Sample

How can I do it by SSRS v14.0?

Upvotes: 0

Views: 1250

Answers (1)

Alan Schofield
Alan Schofield

Reputation: 21738

STart by building your report with the details rows, then right-click the detail row in the row group panel below the main report design.

Do "Add Group" then "Parent Group". Choose the field that contains Buy/Sell and tick the "Add group header" option.

A new column will be added with the buy/sell field added. Delete this new column and then in the original column above instrument name, click the cell and choose the Buy/Sell field.

This should give you what you want.

Upvotes: 2

Related Questions