Skip to Content

Crystal Reports crosstab with caculated member

Mar 05 at 11:31 AM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Mar 05 at 01:46 PM

Hi Yigal,

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


Show 2 Share
10 |10000 characters needed characters left characters exceeded


Its formatted as Number.

But the reason I can't do % just on that column is because I can't locate it in Formula, I can locate only DB fields.


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.