Group selection 1

[northw]

Hi All,
I have groupings in my report, one of the groupings is preferred clients which has all the customers and some elite customers, which can be identified based on the elite phone num field if it is null or not, determines a elite customer, I have top 15 clients for which I want to display only clients who have elite customers in the respective group.

I have created a formula:
Elite: if elitephonenum not null then 1 else o

and used it in the group selection.
SUM({Elite}, {Client}) > 0

the above group selection does not restrict any records, as I want to display Top 15 Clients with Elite customers, if there is a client in the top 15 with no elite customers, then I don't want it to be shown in the report or group tree, I want to skip it and display the next one.

Crystal reports 2011, SQL server 2000 database, report is built using tables and joins, no command object used.

Thanks in advance!

 

[kenhamady]

Group Selection won't restrict records. It can only restrict groups. And Group Selections happens AFTER the grouping and totaling are done. So the groups won't show in the report but they WILL still be in the record count and the group tree. They will also be included in any Grand Totals unless you use running totals. Running totals only count groups that meet the group selection criteria.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guides to Formulas, Parameters, Subreports, Cross-tabs, VB, Tips and Tricks

http://www.kenhamady.com/