crBold in Cross-Tab not Working! 1

[southbean]

Hello All,

I’m trying to use crBold in a Cross-Tab formula and it’s just not working!!!

The formula I want to conditionally bold is a row in the cross-tab:

@RowFormula: 
If {table.Field1} IN ["value1"," value2"," value3"," value4"] Then “-“ & {table.Field1}Else 
If {table.Field1} = “Other” Then “--“ & {table.Field1} Else “---“ & {table.Field1}

On X-2 button for ‘Style’ I have this formula:

If {table.Field1} IN ["value1"," value2"," value3"," value4"] Then crBold else crRegular

If I put the @RowFormula in a non Cross-Tab report and use the conditional Bold formula it works just fine. But, in the cross-tab it does not.

I would appreciate any/all help or suggestions with this!

Thanks,

- Tom

 

[lbass]

Try:

If currentfieldvalue IN ["value1"," value2"," value3"," value4"] Then “-“ & currentfieldvalue Else
If currentfieldvalue = “Other” Then “--“ & currentfieldvalue Else “---“ & currentfieldvalue

-LB

 

[southbean]

Hi LB,

Thank you for your quick reply!

Do you mean for me to replace my @RowFormula with yours or put your formula in the X-2 Style condition?

Thanks again!

- Tom

 

[lbass]

Sorry, I misread your post. Try the following--note that you must put the actual values in the formula, and yes, this belongs in the font tab->style->x+2 formula area:

If currentfieldvalue in ["-value1","-value2","-value3","-value4"] then crBold else crRegular

Please note that I am unclear whether there is a leading space in the value that you are adding to the hyphen. If there is, then change the results in quotes to: "- value1","- value2", etc.

-LB

 

[southbean]

Bingo!

LB, you are the MAN!

Thank you VERY much!!!

- Tom