Grouping in Sap Crystal Reports

[former_member193866]

Hi,

Below is my formula..

if ({A_PFCHOLDINGS.POR_CURRENCY} & {A_SEC_FREECODES.FREE_CODE_41_NAME}) = ({%Valuation Currency} & {%Investment Type}) then 'Portfolio on Investments by Valuation Currency & Investment Type'

else

if({A_PFCHOLDINGS.POR_CURRENCY}&{A_SEC_FREECODES.FREE_CODE_41_NAME} & {A_SECS.COUNTRY_REF}) = ({%Valuation Currency} & {%Investment Type} & {%Country of Risk}) then 'Portfolio of Investment - Country of risk, Valuation Currency & Investment Type'

In above formula two conditions are there. Before else after else. I'm creating 2 categories. Because of else I'm getting only 1 cat at a time. How to get 2 cats at a time?

Please help me on this.

Thanks

Riaz

[Former Member]

A record can only meet one condition.

With an If then else statement as soon as a true condition is met the formula stops evaluating.

You will need to create a second formula for the second condition if you want to display both results.

Ian