Skip to Content
avatar image
Former Member

Suppress Specific Sections

I have a report that looks like this

hospital (group 1)

     doctor who (group 2)

         

          details .... details

group footer:   clients without services: 2 (summary of details)

                       caseload: 55 (summary of details)

     doctor John (group 2)

         

          details... details

group footer:   clients without services: 0

                        caseload: 32

primary care

     doctor Jane

         details... details

group footer:   clients without services: 0

                        caseloads: 66

My question is how do I suppress all sections where clients without services= 0. I tried to do this using a formula in the section expert > suppress > formula. However it does not let me use a summary field in the formula. Thanks for the help!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 28, 2015 at 04:46 PM

    The only way I can think of to do this requires a Command (SQL Select Statement).  How are your SQL skills?

    Basically the Command will pull the data for your groups and the sums for "clients without services" and "caseloads" - you'll set it up so that it doesn't pull data for docs who have no clients without services.

    Then you would suppress the details section and in either a group2 header or footer create a subreport to get the details.

    For more information about how to use commands, see here:  Best Practices When Using Commands with Crystal Reports.

    -Dell

    Add comment
    10|10000 characters needed characters exceeded