reporting services - How to implement Underlay Following Sections in SSRS? -
i trying implement underlay following sections in ssrs. there way achieve this?
in crystal reports there underlay following section check box through can achieve this. want use feature because in details section there 1 column (unit area) repeats data in each row due totals @ group footer comes wrong (due duplicate unit area) workaround correct totals work me if underlay not possible. googled underlay feature , solution find of using matrix per below msdn post. let me know if there other possible workarounds or solutions.
this issue has been frustrating figure out, figured out how mimic crystal's underlay following sections behavior in ssrs!!! stumbled across solution , after finding have searched on method used , found many articles referencing it, never equating solution mimicking crystal's underlay property. here's how did it.
i had 3 groups - call them company, business, employee - , details. traditionally, these groups laid out on separate rows this:
company
...............business
..............................employee
...............................................details
using table, put columns on same row - details row - instead of multiple rows.
company...business...employee...details
now, should result in duplicate values each of groups every detail set in dataset. , if have set , run it, see that's get. let's fix it.
- click anywhere on table bring tablix control region.
- click on control details row; should highlight row.
- open properties , scroll down section called other , property called hideduplicates. there should drop down list groups.
- select group represents parent group, in case company.
this property hides of group duplicates providing underlay looking for. have save , preview!
i used method on other reports wanted 1 of groups, company group, on line itself. no problem, remember far details row concerned, business group parent.
hope helps
Comments
Post a Comment