Skip to Content
avatar image
Former Member

Crystal Reports crosstab with caculated member

Hello all,

I have created croisstab and added 1 calculated member column.

I need to place % only in that column while all others are currency columns.

How can I do that?

I succeded placing it on database columns using GridRowColumnValue but not on calculated member column.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 05, 2018 at 01:46 PM

    Hi Yigal,

    What is the datatype of the field used as the "column" of the Crosstab?


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Yigal,

      Try this please:

      1. Right-click the Calculated Column's header cell > Calculated Member > Edit ColumnValue Formula.

      Type in a large number that may never appear in the crosstab column:


      2. Right-click one of the summary cells > Format Field > Number tab > Customize > Currency Symbol > Select the Position that has the symbol at the end.

      3. Then Click the formula button beside "Currency Symbol" and use this code:

      if (GridRowColumnValue("Field used as the Column of the Crosstab",currentcolumnindex)) = 99999999 thnn "%" else ""

      Note: Replace "Field used as the Column of the Crosstab" with the correct field used as crosstab's column. It needs to be enclosed in double quotes like above.