To create a dynamic grouping in crystal report:

1. you’ll need to create a formula to determine the groups
2. Add the formula to the group expert

But if you find the formula that you’ve created doesn’t show in the group expert, just add

When you try to access the stored procedure that you created from Database Expert in Crystal Report, you’ll discover that your stored procedure doesn’t appear in the list. In order to make it appear you must grant Crystal Report the permission to execute.