CODEWITHSUNDEEP
crystal-reportscrosstab
LotuX
LotuX

Reputation: 374

Crystal Report Cross Tab Calculated Member as text

I'vre created a cross tab report with 2 calculated Member to be able to have the difference between 2 column and the percentage of this difference in CR 2011. What I want to achieve is to create a new column that will display a test depending on the difference value. Here is a example:

Col1     Col2      Difference     Percentage        Action
 200        0            -200            100        DROPPED
 100      100               0              0        
   0      300             300            100        ADDED

How can create this action column. Calculated member only want some amount value so I cannot output a text in the formula.

Thanks in advance for your help

Upvotes: 0

Views: 2154

Answers (1)

LotuX
LotuX

Reputation: 374

I finally found the solution. I can use the Display string formula in the Format Field properties (Common Tab). Here I just check the column and return the string I want otherwise I just format the number.

IF GetColumnGroupIndexOf(CurrentColumnIndex) = 1 
   AND CurrentColumnIndex =4 THEN
   IF GridValueAt(CurrentRowIndex, CurrentColumnIndex,CurrentSummaryIndex) =2 THEN "DROPPED"
   ELSE "ADDED"
ELSE
   ToText( GridValueAt(CurrentRowIndex, CurrentColumnIndex,CurrentSummaryIndex),2,",")

Upvotes: 1

Related Questions