Hi,
I am trying to show variable group orders. I want the user to select which field should be in the first, second, third group etc... So the user could select to group first on project, second on manager, third on team. then the report would display such as...
project 1
manager 1
team 1
team 2
project 2
manager 3
team 4
team 5
or they could choose to group by manager, project, and then team. I can create the groups ahead of time but how do i change which field the groups will group on? or can i arrange the nesting of groups at runtime? is this even possible?
im not a crystal newbie but I have only dabbled here and there over the years. im not really sure even how to write code outside of sticking code inside the various formula buttons.
Thanks for any help in advance, any suggestions or pointers are much appreciated.
cheers