Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting overlapping the images in Nprinting

Hi Guys,

I am using three diffrent colour arrows (Red,Green,Blue) & set three different rules for each arrows. But in Report PDF the arrows are showing overlapping in the "Change Column where as in the other "Change" column it is coming perfectly ok.

Please refer to the Image:

Arrow.png

The Rule set for these arrows below:

Blue:

Iif([Value of Reclaims Outstanding TP] =[ Value of Reclaims Outstanding LP ]  ,
[Value of Reclaims Outstanding TP]=[ Value of Reclaims Outstanding LP]
,[Value of Reclaims Outstanding TP]!=[ Value of Reclaims Outstanding LP] )

Green:

Iif([Value of Reclaims Outstanding TP] <[ Value of Reclaims Outstanding LP ]  ,
[Value of Reclaims Outstanding TP]<[ Value of Reclaims Outstanding LP]
,[Value of Reclaims Outstanding TP]!=[ Value of Reclaims Outstanding LP] )

Red:

Iif([Value of Reclaims Outstanding TP] >[ Value of Reclaims Outstanding LP ]  ,
[Value of Reclaims Outstanding TP]>[ Value of Reclaims Outstanding LP]
,[Value of Reclaims Outstanding TP]!=[ Value of Reclaims Outstanding LP] )

As you can see, the "This Period" & 'Last Period" value is coming same , it should come as Blue Arrow, but it is coming as overlapped.

Please help me to resolve the issue.

Thanks,

Iman Mukhopadhyay

5 Replies
mkelemen
Creator III
Creator III

Hi,

where exactly is the formula placed? Iif() suggests Visual Basic...

It is quite hard to read with all the spaces at the beginning and at the end of field names. Is [ Value of Reclaims Outstanding LP ] different field from [ Value of Reclaims Outstanding LP] ?

BR,

  Matus

Not applicable
Author

Hi Matus,

The formula placed on Formatting Rule Sheet Editor in Nprinting.

Space is not an issue as same condition applied on other field & the Arrow is coming correctly.

I have changed the "Spaces" but still getting the same issue.

Thanks,

Iman Mukhopadhyay

mkelemen
Creator III
Creator III

I am not expert on PixelPerfect but just by looking at these formulas they seem odd...

I created a teble in QV and the result is that Blue is always TRUE, Green+Red are TRUE if TP!=LP.

Can you post the other formulas that work?

  Matus

Not applicable
Author

Hi Matus,

Thanks for the information. You are correct. There was space/junk character at the end.Now it is coming perfectly.

Thanks,

Iman Muhopadhyay

mkelemen
Creator III
Creator III

I still think these formulas are wrong and it is just working for TP=LP.

You should test some cases where TP>LP and TP<LP.

BR,

  Matus