Crystal Reports Conditional Details Section

I have a report that joins multiple tables. One possibility for this join is that no rows are returned under part of the selections criteria. Sort of.

I have 3 groups: Movie Rental Place, Type of Movie, Rented / Not Rented / No Interest to Rent.

So an example could be:

1. Blockbuster | Comedy | Rented: List rented movies.
2. Blockbuster | Comedy | Not Rented: List movies not rented.
3. Blockbu开发者_StackOverflowster | Comedy | No Interest to Rent: List movies not interested in renting.

Now, I do not want to suppress a section if it is empty, I want to print something else in the Details section of CR. Is there a way to do this?

I am using CR 11.5.

Thanks

Go to Section Expert and check the "Suppress blank section" option. Add a new section below it (for the static message) and add a suppress formula to that section that uses some isnull check on whichever column indicates "no data".

Before, when I was attempting to create a custom formula for the Details section, I was testing on NULL values, when the report was setup to give default values for NULL values. Once I removed that, things worked as intended.

Thanks