suppress cross tab details

[MHPGuy]

This is a sales report crosstab in which a record may have a sold date matching the current month in one of three effective date fields.

I have a cross tab that is pulling from one field (Sales Rep) in the row, and three in the column (potential effective dates):

| Effective 1 |
| Effective 2 |
| Effective 3 |
Sales rep | D1 D2 D3 | Subtotal
total rep | D1 D2 D3 | total count


(L section)| (Center Section) | (R Section)
FIXED | VARIABLE--------> | FIXED

(For purpose of explanation, I have drawn two lines separating the Left, Center, and Right sections I am referencing. The problem is in the Center Section X-axis variable)

In this crosstab, I have suppressed the detail records (D1, 2,3) total rep (D1, 2, 3), and Column labels (Effective 1, 2, 3). This leaves me with only showing the Sales rep, Subtotal, and total count. So, the center section is completely invisible.

Here is the problem- Crystal is still holding a place for each of the suppressed fields, making the x axis of the crosstab variable.

I need to keep this report on one page, and suppress the viewing of all of the center section as well as the place-holding in the center section. The "suppress" function has failed to work this far.

Can anyone tell be how to eliminate the place holding in the center section? Michael Phipps
Technical Business Analyst
Mercy Health Plans

 

[beanbrain]

You could create a formula that encompasses the three dates and use that as your center section. Remember that a cross tab formula cannot use variables. You would then have the center section operate on that formula for better control over that column.

 

[lbass]

Is your column field {table.effectivedate} with Effective Date1, Date2, and Date3 instances of that field? Your description makes it sound as though what you really want is a crosstab with no column field. Try removing it--just have a row field and a summary field.

I'm guessing the crosstab is placed in a group header or footer which is what is making the number of columns in the grid variable.

-LB