Select by Summary field

Posted on 2005-04-13
Last Modified: 2006-11-18
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?
Question by:BasilFawlty001
    LVL 34

    Expert Comment

    by:Brian Crowe
    Try the Record -> Selection Formulas -> Group... formula
    LVL 100

    Accepted Solution

    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.


    Author Comment

    Right ... I want to show all customers that have zero transactions so that works just fine, Thanks.
    LVL 100

    Expert Comment

    Glad i could help


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
    I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now