I have a summary table (created from a stored procedure) that's set up with fields for each day in the month - Day1Sales, Day2Sales, Day3Sales, Day1Goal, Day2Goal, Day3Goal, Day1Var, Day2Var, Day3Var, etc.
Some days, the fields will be 0 since actual process days are Tues thru Fri (except for holiday schedules). I'm creating report which list each day as a column, printing 3 rows (Sales/Goal/Variance).
I've suppressed any fields/column which are 0. However, there's a gap where those fields would normaly print. Is there any way to suppress the fields and cancatenate the columns so that the columns print without the gaps for non-process days?
Some days, the fields will be 0 since actual process days are Tues thru Fri (except for holiday schedules). I'm creating report which list each day as a column, printing 3 rows (Sales/Goal/Variance).
I've suppressed any fields/column which are 0. However, there's a gap where those fields would normaly print. Is there any way to suppress the fields and cancatenate the columns so that the columns print without the gaps for non-process days?