troubleshooting Question

Change group options using a formula?

Avatar of Westwindcorp
Westwindcorp asked on
Crystal Reports
4 Comments1 Solution1734 ViewsLast Modified:
My users have asked me for a report that would display grouped data in two different formats: by month or by week.  The catch is that they want to be able to choose between the two options at runtime.  I currently have the data grouped by date, then by project number, with the detail records hidden and available in a drill-down.  They would want the top-level data to look something like the example below.

July 2008        $100,000
     Project1          $30,000
     Project2          $50,000
     Project3          $20,000

-----or-----

Week 29          $45,000
     Project1          $10,000
     Project2          $15,000
     Project3          $20,000

My first approach was going to be to create a parameter the users could set, then change the group display option to print either by week or by month depending on that value.  But I can't find anywhere to put the formula!

Am I missing something obvious?  Is there a better way to approach the problem?  I really don't want to create two separate versions of the same report over a formatting difference.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros