Crosstab Report - hide rows conditionally (blank, null, zero)

[powergrouse]

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

 

[FireGeek21]

I am not sure a cross tab is the way to go. I have something similar to what you are trying to do but used Tools -> Report Grouping and added the DEPT to Report Grouping. Next, make sure your first sort item is the DEPT - same as the group.

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