Has anyone found a way to flatten out Group Header rows in Self-Service (SSRM/InfoGo)? Basically, we have several tables with multiple levels of grouping, but each group adds another Group Header Row. What we really want to see is a Group Header row showing for each unique combination of Columns to save on screen real estate and make the output more easily readable for our users.
Here is an example of what we are getting in SSRM versus how we want it to lay out:
Table grouped by Hospital, Department, and Encounter Nbr with data for the Encounter's DateOfService, Status, and # of Products (SUM on # of Products for the Encounter):
Since the Encounter Nbr, DoS, and Status will be the same for every Encounter and we want the primary visual grouping to be by Hospital then Department, we want to flatten these out into a single Row for every unique combination thereof, which would look like:
The only way we can come up with to flatten these out in SSRM is to create a Formula column concatenating all of the 'flat' values into a String and grouping by that column. This removes major pieces of functionality like Sorting, Filtering, hyperlinking from Encounter Nbr to our parent app for that Encounter, etc. This is not an acceptable solution :(
Anyone have any ideas of how to make this happen without losing valuable functionality?
Please sign in to leave a comment.