How to filter report based off of multiple formula fields

[Former Member]

Hi,

I am working on this report for a client of mine, any type of prompt feedback would be greatly appreciated. I am trying to sort my report based on several field formulas. I have several formulas because I want a blank to appear if value is "" but a word to appear if value is "1". For example, one of my formulas is:  if {Daily_Flash_Report_for_Crystal.Peak?}="1" then "Peak" else "". I need each formula where the words that are the same are grouped together. For example my report layout is:

Group 1: Sales Rep Location

Group 2: Sales Rep

            Account name     Target/Peak/Focus

Example Account Name             Peak

Example Account Name 2          Focus

Example Account Name 3          Peak

I want to be able to see all of my "Peak" accounts at the top of the page group, the focus, then target, then blanks.

I am failing at using a parameter. Does anyone have any suggestions? I am using Crystal Reports 2011.

[abhilash_kumar]

Hi Jennifer,

Go to the Group Expert and add the formula to the Group List. If you then want to sort the group #3, then highlight that group in the Group Expert > Options > From the second drop-down choose 'Specified Order' > From the 'Named Group' drop-down choose 'Peak' first and then the rest.

-Abhilash