Sage 100

Crystal question. If you use a group selection formula, is that just to show it or not? In other words, if you are trying to exclude a group using a group selection formula, would that group's numbers still be included in the report totals??

If you use a statement to suppress (exclude) in Section Expert, the totals will not be included in the report.

You mean in the section expert to suppress the group's footer?

I usually will just utilize a statement in the Section Expert to filter the data I want for that group, so if I want to only include ""A"" and ""B"" but not ""C"" for the field that is used to group, I would type Groupfield = ""C"" to suppress, since it is a suppression statement, not an inclusion statement. Another example is for testing for that field being empty, nothing else needed --> ISNULL(Groupfield)

Am happy to help write it, if you'd like.

I have it written but I've run it with and without a particular customer and the report summaries aren't changing (using both group selection and section suppression). I don't see the customer but the report summaries aren't changing.

Ah, I have seen this before. Perhaps you could use a Running Total instead of a Summary. I'm not certain why Crystal included some data when it has been suppressed.

I thought about that. Thanks though @MichelleTaylor1!

Most welcome @ThereseLogeais !

Neither Group Selection nor Group Suppression will diminish the totals. You could use Record Selection or a Running Total to do that.

Record selection would be very complicated. They have a customer selection parameter (which can be ALL or specific customers) but they sometimes want to exclude certain customers when they run it for ALL so I added a customer exclusion parameter. I thought I had it figured out but it ran and ran and ran. That's when I tried the Group selection but that didn't work. I'll look at it again at some point...

There's no problem to have two parameters for customer number in Record Selection. One for includes (w/All) and one for excludes (w/None). (if {?included}=""All"" then true else {AR_InvoiceHistoryHeader.CustomerNo} in {?included}) and (if {?excluded} = ""None"" then True else Not({AR_InvoiceHistoryHeader.CustomerNo} in {?excluded}))

I use global variables to calculate report totals when I need a filter based on a group filter (similar to how you'd get values in a main report from a sub report). Running total fields don't work with all logic, but global variables are much more flexible.