I have a report that lists sales order numbers and is grouped by sales manager. Simple enough looks like this:
John Smith
123
777
715
Mary Jones
478
798
Within the table we also have the postal code and now we want to add this to the report but give the user the choice to group either by sales manager or by post/zip code.
I've tried using a boolean parameter and using this to supress the unwanted group but this is obviously isn't working how I'd like it because all I'm doing is hiding the sales manager. If two different managers have made sales in the same post/zip code area, the post/zip code gets repeated in the report.
How do I get Crystal to use the group chosen by the end user and ignore the other? Is this possible?
Any thoughts and help greatly appreciated!