Link to home
Start Free TrialLog in
Avatar of Westwindcorp
Westwindcorp

asked on

Change group options using a formula?

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
Avatar of bdreed35
bdreed35
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Westwindcorp
Westwindcorp

ASKER

That was just what I was looking for!  All I have to do is some formatting and we are good to go.

One question though, out of curiosity: why do you put the date field in a variable?  Why not use the actual field name in place of the variable name?
You don't have to use a variable.  I use them when I reference the same field multiple times.
Great.  I thought it was just some weird CR quirk or something.  Of course we know CR doesn't have any of those!!  :)  Thanks again.