I managed to resolve my previous thread partialy wit one small problem

{items.qty} & ", " & {items.name} & ", "& {item.subname} & ", " & "Net kg: " & {items.mass}

This prints

5, Printers, HP Deskjet, Net kg: 5

Prints OH but if a database field eg {item.subname} is empty then the line does not print

I have tried

if {item.subname} = "" then {item.subname} = "-"
{items.qty} & ", " & {items.name} & ", "& {item.subname} & ", " & "Net kg: " & {items.mass}

this however gives an error message 'The remaining text does not apear to be part of the formula'

I then tried

if {item.subname} = "" then {item.subname} = "-";
{items.qty} & ", " & {items.name} & ", "& {item.subname} & ", " & "Net kg: " & {items.mass}

with the same result the line does not print prints