• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Select by Summary field

I have a report that has a list of Customers and their total number of transactions.  I've grouped the actual transactions by Customer ID and have the Customer name and a summary field of the number of transactions in the footer.  The footer is the only part not suppressed.  I need to select by the summary field but it doesn't show as available.  Can I not select by a summary field?
0
BasilFawlty001
Asked:
BasilFawlty001
  • 2
1 Solution
 
Brian CroweCommented:
Try the Record -> Selection Formulas -> Group... formula
0
 
mlmccCommented:
What are you trying to do?  Show only the customers with a certain number of transactions?  You could use conditional supression based on that field.

mlmcc
0
 
BasilFawlty001Author Commented:
Right ... I want to show all customers that have zero transactions so that works just fine, Thanks.
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now