Skip to Content
0
Former Member
May 22, 2014 at 06:32 PM

How to filter report based off of multiple formula fields

17 Views

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.