NAV2009 report expression

hewajith

Hi Anyone,

Most of the posted invoice has standard vender po number (From sales header) and I have costized field on posted invoice to enter vendor Po number only for some invoices (If customer does not enter Po number on sales order at the time of posting invoices)

Now I want to print PO number as per following logic

If custome field for PO number =blank the I want to print standard Po number

For this I used experssion on rep[ort designer (Visibility in Text box)

It works perfectly but If costome PO Number on customized field is blank then It changes my format.

Have any one experienced same sort of situation?

Is there any better way /Experssion to be used for this perpose?

Thank you,

Hewajith

ara3n

could you put a screenshot and the code you are using for the expression.

Also what did you put in the format property?

hewajith

Hi Ara3n

Thank you for reply
I dave not used format property.
I have used only experssion on visibility tab
My expression is:
=iif((reportitems!Sales_Invoice_Header___POST_PO_Number_.Value)= "",False,True)

Please find the attached screen shots.


Thank you.

Hewajith

ara3n

So is your issue that it doesn't work with hiding the text box?

It works perfectly but If costome PO Number on customized field is blank then It changes my format.

or is it that your format changes?

hewajith

Hi Ara3n,

Sorry for communications breakdown...

Yes, I have problem with format.

If customized field has no value then my format changes (Distorted) automatically as shown in attachments

Thank you,

Hewajith