Suppress Results Rows but Still Display Overall Results

[Former Member]

I am working on a query modification where my client would like to have the results rows suppressed (subtotals) but not the overall results. They still want the overall results displayed.

Within query designer, I know I can go to the properties on each characteristic (row) and under Display of Results, select "always" to suppress results rows. However this option suppresses all results rows, including the overall results.

Does anyone know how to suppress the results rows for subtotals but still display the overall results?

Thanks.

[majeed_mohammedabdul · Accepted solution]

Hi Eric,

If u dont use that function for the top most column, that is the left most column , then u can solve ur problem.

Regards

Majeed

[Former Member · Accepted solution]

Thanks Majeed. I tried your suggestion and it worked. Thanks!

[Former Member]

for the first row char > properties > suppress results - never >

for other row char > properties > supress result -- always..

it will work.

Regards,

BWer

Assign points if helpful.