Skip to Content
0
Former Member
Aug 15, 2013 at 02:36 AM

Crystal Reports 2008 - Displaying and Grouping results based on different logical criteria

1059 Views

I don't know how else to word that title. Logically what I'm trying to do is simple. I just have no idea how to accomplish it in CR.


There is one table of information. I want to setup 3 different pieces of logic and 1) display the results grouped by each piece of logic and 2) give a count of the number of records in each group.

Here is the logic:

Results set 1: Display all results if Field A contains a certain text string. Give a count of those results.

Results set 2: Display all results if Field B contains a certain text string. Give a count of those results.


Results set 3: Display all results if Field B contains a different text string than Set 2. Give a count of those results.

It seems so simple. I just don't know how to do this in CR or really what to Google to specifically find info on this.

Any thoughts would be appreciated. I was thinking to use Formula fields for the logic, and I'm just stuck on how to end up using them properly, if that's even the route to take.

Ultimately I would also like to display the counts for each of these result sets in a table as well.

Thanks,


Brian