reporting services - How to have a summarized data on the first page and the rest of the page is seperated per grouping in ssrs 2013? -


i'm newbie in ssrs.

my first objective seperate display of each item per group.

i've done setting tablix row group properties in pagebreak -> breaklocation between

in result, when exporting report excel, sheets seperated per item.

my next objective have first sheet consolidated data rest of sheet

current excel sheet format: [team a],[team b],[team c]

expected result: [overall team],[team a],[team b],[team c]

any , suggestions appreciated!

you should add list. set grouping list =1 (this means "all" basically) - can create want on overall team sheet in rectangle. once you're done, add row list, , create new list inside second row. group second list on team's unique identifier - generate you're getting after first "overall" page.

set page breaks on rectangle first row of first list , group on grouping of second list them split new tabs. protip: pagename field in properties pane lets define name of sheet when export excel!


Comments

Popular posts from this blog

How to connect android app to App engine -

gcc - MinGW's ld cannot perform PE operations on non PE output file -

php - display validation error message next to the textbox in codeigniter -