Crosstab Report - hide rows conditionally (blank, null, zero)
Crosstab Report - hide rows conditionally (blank, null, zero)
(OP)
I am largely self-taught on ReportSmith, and very grateful for the help of many of you here at the forum!
Is there a way to hide rows of a crosstab where all columns are zero, blank, or null? I have played a bit with the "Null Value String" option, and even custom sorts, but do not see any way to achieve this.
I want to subtotal a report by department, but the crosstab repeats all employees for every department. A (very) simple example of the situation (on the actual report I may get one or two rows per page that actually have data):
What I get...
Regular Hours
Dept Employee PP1 PP2...
101 John 36.25
Jane
101 Subtotal 36.25
102 John
Jane 40.00
102 Subtotal 40.00
Total 76.25
What I want...
Regular Hours
Dept Employee PP1 PP2...
101 John 36.25
Subtotal 36.25
102 Jane 40.00
Subtotal 40.00
Total 76.25
Thanks in advance!
Chris
Is there a way to hide rows of a crosstab where all columns are zero, blank, or null? I have played a bit with the "Null Value String" option, and even custom sorts, but do not see any way to achieve this.
I want to subtotal a report by department, but the crosstab repeats all employees for every department. A (very) simple example of the situation (on the actual report I may get one or two rows per page that actually have data):
What I get...
Regular Hours
Dept Employee PP1 PP2...
101 John 36.25
Jane
101 Subtotal 36.25
102 John
Jane 40.00
102 Subtotal 40.00
Total 76.25
What I want...
Regular Hours
Dept Employee PP1 PP2...
101 John 36.25
Subtotal 36.25
102 Jane 40.00
Subtotal 40.00
Total 76.25
Thanks in advance!
Chris
RE: Crosstab Report - hide rows conditionally (blank, null, zero)
From there, go to Insert -> Header/Footer and add a DEPT Footer.
Next, click on the desired columns and then the sum button.
If you want your detail hidden and to only show the summary footers, go to Format -> Section. Choose Detail in the box above and then check the Hide Section box.
Hope this helps.
RSGeek at WI dot RR dot COM