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

Question

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

powergrouse (TechnicalUser)

(OP)

16 Sep 08 12:14

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 (TechnicalUser) · Answer 1 · 2008-09-30 23:08:34

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

Come Join Us!

Posting Guidelines

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