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
Post a Comment