Basically, this example only has first column grouping and expanding, but I need many columns have the same feature as this first column with + and - sign to expand and collapse each group, it is hard to build it in asp.net gridview.
I have searched the internet, manage people created this kind of report with gridview just have first column has that feature, non more columns.
Does anybody know how can we build it in SQL server reporting services? is it possible? If anybody can build it in gridview, I prefer gridview. but I also want to know if it is possible in report service.
Appreciates any help or resources to help me create this kind report. thanks a lot,
Yes, in SSRS for achieving the same you need to follow below things:
1) create a matrix report, and add column grouping on your required columns
2) drag the column data just below the column grouping, you can have the nested grouping there.
3) for setting the (+) and (-) thing [expand and collapse] you need to set the toggle property of your grouping column by right clicking on them.
Ashutosh Pathak
Blog: http://catchcode.blogspot.com Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Peter Cong
Member
527 Points
681 Posts
How to create a report with many columns grouping and collapse and expanding?
Dec 24, 2012 12:55 AM|LINK
HI,
I am trying to create a web form apps using this kind of report: this the example site:
http://www.dotnettwitter.com/2012/07/group-total-and-grand-total-in-gridview_15.html
Basically, this example only has first column grouping and expanding, but I need many columns have the same feature as this first column with + and - sign to expand and collapse each group, it is hard to build it in asp.net gridview.
I have searched the internet, manage people created this kind of report with gridview just have first column has that feature, non more columns.
Does anybody know how can we build it in SQL server reporting services? is it possible? If anybody can build it in gridview, I prefer gridview. but I also want to know if it is possible in report service.
Appreciates any help or resources to help me create this kind report. thanks a lot,
Ashutosh Pat...
Contributor
5737 Points
1105 Posts
Re: How to create a report with many columns grouping and collapse and expanding?
Dec 26, 2012 08:17 AM|LINK
Yes, in SSRS for achieving the same you need to follow below things:
1) create a matrix report, and add column grouping on your required columns
2) drag the column data just below the column grouping, you can have the nested grouping there.
3) for setting the (+) and (-) thing [expand and collapse] you need to set the toggle property of your grouping column by right clicking on them.
Blog: http://catchcode.blogspot.com
Please mark it as answer if it helps, as clicking on the button can save time of others :)
MCP,MCAD,MCSD,MCTS
Thirumalai_p...
Participant
1799 Points
291 Posts
Re: How to create a report with many columns grouping and collapse and expanding?
Jan 07, 2013 04:58 AM|LINK
Hi,
If you still have the query not solved, pls look at the following posts, which may help you to solve the issue.
http://www.dotnettwitter.com/2013/01/group-total-and-grand-total-in-gridview_6.html
http://www.dotnettwitter.com/2013/01/group-total-and-grand-total-in-gridview_7890.html
Thirumalai Muniswamy My Blog
Mark as Answer if this reply helps you.
Peter Cong
Member
527 Points
681 Posts
Re: How to create a report with many columns grouping and collapse and expanding?
Jan 07, 2013 10:50 PM|LINK
Hi Trirumalai_pm, Thanks a lot for the example, it looks a good example, I will study it and let me know if this is exact match what I need,
Appreciate your help,
PS: I have sent to you email in your gmail inbox,