Skip empty line in Report

RMolenaarRMolenaar Member Posts: 94
edited 2015-07-28 in NAV Three Tier
Hi all,

I am changing an Invoice and added an extra data item "Customer.Name" into the report.
When this field is empty I want to skip the field because else there will be an empty row in the report.
I've read a lot about the Compressarray function but I do not get it working.

Is there any workaround to make an compressed array?

I've also posted an attachment of the layout in VS.

Thanks in advance

Rob
Microsoft Dynamics NAV 2013 R2
NAV 7.1

Answers

  • gandhi_nklgandhi_nkl Member Posts: 44
    Hi,

    Go to row visibility property and Click "Show or hide based on an expression", then set the condition like below,

    =IIF(Fields!Customer_Name.Value <>"",false,true)
    Thanks & Regards,
    Muthu
  • RMolenaarRMolenaar Member Posts: 94
    Thank you Ghandi,

    I only set a visibilty property on the field not the row.
    It is solved now.

    Best Regards
    Microsoft Dynamics NAV 2013 R2
    NAV 7.1
Sign In or Register to comment.