Skip to Content
0
Former Member
Dec 01, 2009 at 08:04 PM

Help with formatting for Cross Tab Report Crystal 2008

157 Views

This is probably a simple question. I have a cross tab report that displays sales by month for a period of 6 months. These sales columns are formatted to be numbers with no decimals. In addition to these columns, I have inserted columns that display the percentage up/down in sales over the previous month. If I try to format the percentage columns, it changes every column to then display "##,##.##%" when I need to keep the sales columns at "##,###" with no decimal or percentage sign.

1. Is there a way to change the formatting of some of the columns but not all in a cross tab report?

2. If not, can I add a function that would change these in the calculation formula of the calculated member?

I tried to add "%" but it wants it to return a number.

Here is the current code:

//The calculation formula is used in place of the summaries in Calculated Members.

// This calculation formula must return a/an Number value.

If GridValueAt (CurrentRowIndex,CurrentColumnIndex-3,CurrentSummaryIndex) = 0 then 0 else

((GridValueAt (CurrentRowIndex,CurrentColumnIndex-1,CurrentSummaryIndex) -

GridValueAt (CurrentRowIndex,CurrentColumnIndex-3,CurrentSummaryIndex)) /

GridValueAt (CurrentRowIndex,CurrentColumnIndex-3,CurrentSummaryIndex)) * 100

Any help is appreciated.

Thank you,

Tobi