nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Grouping Multiple columns

jborunda · 2014-10-13T16:09:40+00:00

I have the following report Plan Strategy Project Plan 1 Strategy 1 Project 1 Plan 1 Strategy 2 Project 1 Plan 1 Strategy 3 Project 1 Plan 2 Strategy 4 Project 2 Plan 3 Strategy 5 Project 3 Plan 4 Strategy 6 Project 4 Plan 4 Strategy 6 Project…

jborunda

I have the following report
 
Plan Strategy Project

Plan 1 Strategy 1 Project 1
Plan 1 Strategy 2 Project 1
Plan 1 Strategy 3 Project 1
Plan 2 Strategy 4 Project 2
Plan 3 Strategy 5 Project 3
Plan 4 Strategy 6 Project 4
Plan 4 Strategy 6 Project 5
 
where I want to group each column to display one instance of each (Plan, Strategy and Project) as follows:
 
Plan Strategy Project

Plan 1 Strategy 1 Project 1
 Strategy 2 
 Strategy 3 
 
Plan 2 Strategy 4 Project 2
 
Plan 3 Strategy 5 Project 3
 
Plan 4 Strategy 6 Project 4
 Project 5
 
I was able to group them but I had to create 3 different group instances and the columns where skewed, one under another and it is difficult to follow where the info belongs.
 
Plan
 Strategy
 Project
 
Also, I have a prompt window with an "All" function. I tried creating 3 different tables for each columns, which it worked when I select one instance at a time but when I select "All" the tables are off. 
I've struggled for quite a while only being able to group one column, hopefully someone can give some pointers as how to tackle this problem.
 
Thanks,
 
Jorge

Find more posts tagged with

Comments

pricher

Hi Jorge,
 
Based on what you are showing, you don't need grouping. One way to handle your scenario would be to sort the data on Plan, Strategy and Project (either in the query or at the table level) and use the Suppress Duplicates property of each column in the table. You can find that property by clicking on the column header of the table, going to Property --> General, and checking the Suppress Duplicates box.
 
I am sending you an example based on your data in an Excel spreadsheet.
 
Enjoy!
 
P.

jborunda

Hi pricher,
 
Thank you for your response and it works to a certain point... I did select Suppress Duplicates on all the columns as you suggested but I realized when there's a duplicate value next to each other, eventhough different values on another column, it suppresses that value. 
 
Plan Strategy Project

Plan 1 Strategy 1 Project 1
Plan 1 Strategy 2 Project 1
Plan 1 Strategy 3 Project 1
Plan 2 Strategy 4 Project 2
Plan 3 Strategy 4 Project 3
 
After selecting "Suppress Duplicates" on all columns, this is what I get
 
Plan Strategy Project

Plan 1 Strategy 1 Project 1
 Strategy 2
 Strategy 3
Plan 2 Strategy 4 Project 2
Plan 3 Project 3
 
**Notice that Plan 2 and 3 share the same Strategy 4 but when I suppress duplicates, Strategy 4 in Plan 3 is not shown....
 
Is there a reason why it is not shown???
 
Thank you,
 
Jorge

pricher

Hi,
 
Sorry for the late reply... Got busy....
 
I am sending you a new example that should solve your problem. This time, instead of using the Suppress Duplicates property, I am using the Visibility property of the Plan and Strategy data item.
 
The first step is to read ahead all the values for Plan and Strategy and keep them in two arrays, keepPlan and keepStrategy. This is done on the onCreate method of the detail row of the first table. Notice that this table is hidden, so it will not show in your report. Then, I add the logic to hide or show the Plan and Strategy data item on their respective Visibility properties.
 
Hope this helps,
 
P.

Andrea05

Hello,
 
I understand that this thread is very old but I would like to extend upon the above solution.
 
But I would like to know what you would do if you had the following scenario:
 
Plan Strategy Project

Plan 1 Strategy 1 Project 1
Plan 1 Strategy 2 Project 1
Plan 1 Strategy 3 Project 1
Plan 2 Strategy 4 Project 2
Plan 3 Strategy 4 Project 3
Plan 3 Strategy 4 Project 2
Plan 3 Strategy 4 Project 2
 
Where the results would be:
 
Plan Strategy Project

Plan 1 Strategy 1 Project 1
 Strategy 2 
 Strategy 3 
Plan 2 Strategy 4 Project 2
Plan 3 Strategy 4 Project 3
 Strategy 4 Project 2
 
Whereby you allow duplicates in the Plan group but only if they have distinct Projects?
 
Thanks!