Grouping Columns and Totals

 SSRS

Grouping Columns and Totals In Table:

Add DataSource either in public(shared) or private:

Add Dataset to generate a report:

→ Added Data source in the shared data source that can be used in the entire project

→ used shared connection string in the private data source :

→ Add data Source

→ Add table from tool box and add columns to the table

In row Groups: Goto Details → add group → parent group → select group by a column that you want

Add group header and footer (optional) 

Preview the design 

Merging Cells and displaying at top of the group :

Delete grouping column → Left click and take a row on above → merge cell by selecting all 

cells → add column Name

In order to display group by value at top select  add group header and add group footer :

1.In row Groups : Goto Details → add group → parent group → select group by column that you want

Adding total like the sum of salary in a row:

Define a name in one cell and column in one cell: 

Adding toggle and expanding based on group column 

Select Details → properties → goto visibility → set hidden properties true