report

Snoopyc

Hi expert, I have a report which needs to show the item no and description and I want to display them in one field with forward slash like fields!quantity.value & " / " & Code.BlankZero(fields!backorder.value). When we don't have backorder, the output shows as 500/. How to hide forward slash if backorder is zero? Thank you!

Luc_VanDyck

You can't do that in a SourceExpr. You'll need to use a text-variable and a IF-statement in the OnAfterGetRecord-trigger:

Will translate your non C/AL code into proper C/AL code:

txtValue2Print := FORMAT(Quantity);
IF Backorder <> 0 THEN
  txtValue2Print := txtValue2Print + ' / ' + FORMAT(Backorder);

Now you can use the variable txtValue2Print further in your report layout.

Snoopyc

Thank you!

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]