Need Formula for Crystal Report Business object 2

[hormaz]

I want to create a formula on overapping situation,
ADT_FCY Balance and ADT_LCY Balance always display together in my report,
but i want to display only non zero figures, E.g; If ADT_LCY Balance is 2000 and ADT_FCY Balance is zero but when i add the formula of not equal to zero in ADT_FCY Balance there is a problem, if ADT_FCY Balance is zero then the ADT_LCY Balance will also get removed even it has balance, it is due to overlapping situation. Kindly help

 

[IanWaterman]

Add the two fields together and check that sum is not equal to zero

In section expert inthe suppress formula add this


ADT_LCY Balance + ADT_FCY Balance = 0

The section will be suppressed if that sum is true.

Ian

 

[hormaz]

Tan,
can you tell me the exact step shold i write this formula against the supress if zero. or create the new formula, or should i write above formula in expert. Kindly guide & thanks for your valuable guidance.

 

[IanWaterman]

In section expert you will see check box for suppress. Opposite that is a formula box. Enter the formula I suggested in there.

Ian

 

[lbass]

I think you could use a selection formula like this (report->selection formula->record), assuming these are detail level fields, not summaries:

(
ADT_FCY Balance <> 0 or
ADT_LCY Balance <> 0
)

-LB

 

[hormaz]

Ian,
ADT_LCY Balance and ADT_FCY Balance are different check out this example,
If;
ADT_LCY Balance = INR 2000 ADT_FCY Balance = USD$ 0.00

for above situation i dont want to show ADT_FCY Balance as it is zero, but when i apply not equal to zero in ADT_FCY Balance, the ADT_LCY Balance(INR 2000) also get removed, to avoid these which formula to use, kindly guide

 

[hormaz]

lbass,
Thanks for your suggestion but still zero are coming in ADT_FCY balance. Please refer to the previous post example you will get the proper idea of my problem. Thanks for your support again. Kindly help

 

[lbass]

Please confirm that these balances are not calculated summaries and that they are displayed in the detail section.

Also explain in what formula area you are using "not equal to zero" and show the actual formula you are using.

-LB

 

[hormaz]

lbass,
I have used not equal to zero in fcy balance in expert & also used your formula but still zero is coming. Kindly help and thanks for guidance.

 

[lbass]

Please go to report->selection criteria->record and copy the selection formula and paste it into this thread.

-LB

 

[hormaz]

lbass,
Did'nt get the copy the selection formula part, Kindly help.

 

[lbass]

In the toolbar, go to report->selection formula->record and copy the formula that appears there and then paste it into this thread.

-LB

 

[hormaz]

Thanks, the problem is sorted out.

 

[lbass]

And how did you sort it out? Please explain.

-LB

 

[hormaz]

Just right click the FCY_Balance then select dropdown of show zero value as select -, when you run the report where-ever it shows zero it will show you -(dash), it will not affect the LCY_Balance too. Thanks lbass for your knowledge.