Suppress Columns in Manual Crosstab

[mgallot]

I inherited a manual crosstab report in which there are 7 column headings being displayed from left to right and this resides in the main report. Each column heading is displaying shared variables from 3 different subreports, so column 2 is also column 9 as well as column 16. After the report is run there can be a total of 21 unique column names which are displayed by Market or Region, depending what parameter the user selects. The Totals being calculated in the subreports are for a Profit and Loss Statement and all Income Statement category totals.

Is it possible to suppress a column if the totals for that region are zero, and regain the space in the report back? In other words, column 3 would take over the space that column 2 was using. I know I can suppress total fields, but how would the columns shift to the left?

This is my first experience with a manual crosstab and I am having a hard time finding much information on it.

Using CRXI 2 with a Bus Objects Universe.

Any help is most appreciated!

 

[Madawc]

A normal crostab will leave out a column or row that has zero data, this is part of the work it does automatically. Manual crosstabs are usually created to avoid this.

Is it possible to use a normal crosstab, if the business now want zero columns suppressed?

If not, you could do several alternate formats with different numbers of columns using sections that you selectively suppress. But it would be a lot of work, assuming that several different columns might come out as zero.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[mgallot]

This report used to be a normal crosstab but its been recreated into a manual crosstab. It took many months and a few different developers to create it so I am going to have to just work with it. I will have to add the suppression code to every field that is diplayed as well as the column headings. In addition, I found that I can add conditional position code to get the columns to move left. I still have to try it, lots of work, but I don't have much choice. Here is the url to the conditional positioning if anyone is interested.

http://crystalandweb.blogspot.com/2007/08/conditional-x-position-change.html