I'm a relative Crystal newbie--more experience with SSRS. I created a SQL Server procedure that has a parameter that groups a Lawson account either account/acct_unit or acct_unit/account. Which works fine in SSRS but we have to publish in Crystal for reasons I won't bore you with. I've tried working with dynamic groups and several other things, including changing my procedure so it orders by according to the parameter (which SSRS doesn't need, but I digress), but can't get the report to be dynamic. We're publishing it with Account first because I can't figure this out. I know there has to be a way to do it.  Can any of you Crystal gurus tell me how to accomplish this? I would be very grateful.

Looked logical and I tried it but I can't get the groups to stay attached to the Formula fields. Has anyone experienced this and have a fix?

It's probably the Friday brain dead thing,but I can't connect a Group to the Formulas I created.