Removing blank columns from Cross-Tab Report

[dianne2n]

Is there a way to actually remove a column from a
cross-tab report? Supressing it still leaves the cell
showing (although it's empty). For this particular
report, all I'm really interested in is the totals.

I'm using CR 8.5.
What I'm trying to report is hours by Dept & workcenter
by month (Months being my columns - Dept/Workcenter
is a row) I'm getting the month from Work_day which is
a datetime field. I'm summing on Work_day by Month.

On my current report I have many (probably 1 for each day)
blank columns between the month's total column.
I'm trying to get a report that looks something like this:

Month: 06/2003 07/2003 08/2003 Totals
Dept WrkCtr
101 1234 6.5 0 12.0 18.5
101 1289 3.0 4.0 0 7.0
Dept Totals 9.5 4.0 12.0 25.5

102 2345 0 3.5 8.5 12.0
102 2346 22.0 10.5 4.0 36.5
Dept Totals 22.0 14.0 12.5 48.5

etc.

Thanks for your offers of help...

 

[synapsevampire]

Right click the crosstab and select Format cross-tab->select the date field in the Columns->select Group Options->A Column Will Be Printed For Each Month

The nature of the crosstab will show this:

Dept WrkCtr
101 1234 6.5 0 12.0 18.5
1289 3.0 4.0 0 7.0
Total 9.5 4.0 12.0 25.5

Given that you place the Dept and WrCtr in the rows, a date in the columns, and whatever summary field you need in the Summarized Fields.

If this doesn't resolve, please post table layout(s), and example data.

-k

 

[dianne2n]

Thanks for the hint.
I did actually have the Group Option selected to print
for each month. I think I discovered that the problem
was that I had put the @Hours also in the columns to be
printed. Now that I removed the @Hours field from the
columns section it looks much better!

Sometimes a push into the right corner is all that's needed.
Thanks for the speedy reply.