We have a Social group column which list all the social group a student part of, as a Student been part of more than one group which caused table to grow big in row count wise.
We have then converted the Group column values into different columns using cross table and it is very successful since the reports running very faster now.
Now the challenge is, we were creating PDF using QMC looping over the values of 'Group' column earlier, is there any optimitic solution to get PDF for each group since the group values are converted into columns now !
Please let me know if any further details required.