Not sure of understanding what your problem is. I use CR 2013, but I think that should work with version XI also. I proceed like this:
- Go to any detail section at the left of your report, on the blue colored area
- Right click the detail section --> Section Expert --> Click on details, not on details a, b, c, or d, just on details --> Click on the conditional formula icon for "Suppress (No Drill-Down) --> Type your conditions for suppressing the whole details section.

That should work...

Edited by Valert16 - 04 Apr 2016 at 7:07am

Cannot see where is the problem. When you say "it supresses everything" which sections are supressed? All details section for every row?, group header section?, other?

I've been doing some testing with a CR 10 version and it works fine, so I suppose there is some detail missing in your question.

The code "formula {@val_01_Total} = 0" will have the details section get supressed when {@val_01_Total} = 0. The only thing that can force all details section getting supressed in all rows is that the formula @val_01_Total returns zero in all cases. Have you verified that?

If nothing of above applies, could you post a screenshot of your report showing the section expert with "Details" selected, and the Formula Workshop with the code you are using?

Hi SteveDLC,

I don't see any explanation for your problem except there's something wrong in your report. I can't help you without seeing it. All testing I've done reproducing your problem gives me the expected results.

Have you tried using another formula, instead of @val_01_Total?

You yourself recognize that this technique does work in other reports, so there's some detail that is missing here.
The only thing I can recommend you is to rebuild and test your report step by step, wich can help you to find the cause of the problem.

What you have posted lately makes me think that you are using shared variables to pass information between one or many of the subreports and the main report.
I deduce also that the formula {@val_01_Total} is using a shared variable. If you use this formula in a detail section, you must be aware that it will work only if you use it in a section below the one that contains the subreport that assigns a value to the shared variable.

If that's not the case, suppressing the details section (not details a, b, c, etc.) will not work because the shared variable still contains its default value (zero if it is numeric type) and the formula probably returns zero, so all your details appear always suppressed.

The solution could be:
- Place the subreport that contains the shared variable used in {@val_01_Total} in the group header. I am assuming that this subreport only performs calculations and assigns a value to the shared variable. This way you can hide all details lines using the "Suppress (No Drill-Down)" conditional formula for the "details" section.
- If the subreport contains information you need to show, you should use one subreport to assign a value to the shared variable in GH, and another one for showing information in a detail section.
- Put the rest of fields and formulas in the details sections.

Hope this works...

Hi SteveDLC,

You're right when you say there's little information in regards to the order of processing and its relation to the placement of the different objects of a report (fields, formulas, subreports, etc.).

There's a place in CR help that may provide you a little understanding about that. It's the section "Report Processing Model". Have a look at this model (the "three pass model"). I know there's not a very clear explanation of every step, but you will see that some formulas, running totals and subreports, among other objects, are processed in pass 2, also known as WhilePrintingRecords pass. Think of this pass as a kind of sequential execution, in the sense of going from top to bottom. If you have some objects in the same section, you cannot guess which object will processed first.

This means that, in this case, the way of assure that one object (subreport, formula...) is processed before another, is to place it in an upper section. For example, any shared variable from a subreport placed in details b, becomes available to a formula placed in details c, d or e, but not to a formula in details a or b.

With all this in mind, when you have many subreports and you use them only to perform calculations that are stored in one or many shared variables, it's correct to place them in the group header and then the formulas with the shared variables in the detail sections.

Finally, you can hide a section with a subreport (or many) that only performs calculations and doesn't have any information you wish to show. Search in the net if you don't know how to do it.

Edited by Valert16 - 12 Apr 2016 at 12:33am