Skip to Content
0

Grouping in Sap Crystal Reports

Jun 05, 2017 at 09:29 AM

30

avatar image

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

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

1 Answer

Ian Waterman Jun 05, 2017 at 10:58 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded