64185

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

Question:

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

Please, see screenshot:<a href="https://i.stack.imgur.com/xtyYG.png" rel="nofollow"><img alt="Sample" class="b-lazy" data-src="https://i.stack.imgur.com/xtyYG.png" data-original="https://i.stack.imgur.com/xtyYG.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" /></a>

How can I do it by SSRS v14.0?

Answer1:

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.

Recommend

  • NSOpenPanel's setDirectoryURL doesn't work on Lion
  • Windows Forms switch between Panels
  • Connect to OLEDB data source from Java?
  • Adding new column to DataFrame with values dependent on index ref
  • Can you render a page with multiple forms instead of one form for a jQuery, Rails 3 update?
  • Safari PHP form submission -file upload hangs
  • SSRS 2008 - Sorting within a group
  • Extjs, handling success or failure when doing a standard submit in a form
  • Is it mandatory to have a doGet or doPost method?
  • Efficient algorithm to find additions and removals from 2 collections
  • AWS-SES: Handling Bounces for Invalid ISPs
  • Where these are stored?
  • Building Qt project for C++11 standard
  • Application level floating views with navigation in Android
  • How to disable all widgets inside Panel or inside Composite?
  • Rails Find when some params will be blank
  • Master page gives error
  • Jenkins: How To Build multiple projects from a TFS repository?
  • Why ng-show works with ng-repeat but ng-if doesn't? [duplicate]
  • output of program is not same as passed argument
  • How to extract text from Word files using C#?
  • vba code to select only visible cells in specific column except heading
  • jquery mobile loadPage not working
  • Do I've to free mysql result after storing it?
  • align graphs with different xlab
  • Akka Routing: Reply's send to router ends up as dead letters
  • Unanticipated behavior
  • Transpose CSV data with awk (pivot transformation)
  • Data Validation Drop Down Box Arrow Disappearing
  • Matrix multiplication with MKL
  • using conditional logic : check if record exists; if it does, update it, if not, create it
  • python regex in pyparsing
  • How do you join a server to an Active Directory (domain)?
  • Android Google Maps API OnLocationChanged only called once
  • unknown Exception android
  • Can't mass-assign protected attributes when import data from csv file
  • Checking variable from a different class in C#
  • Sorting a 2D array using the second column C++
  • Unable to use reactive element in my shiny app
  • How can I use threading to 'tick' a timer to be accessed by other threads?