Unable to remove the "NULL" columns

[deena279]

Hi

i have a small query, i am fetching data directly from DB, all tables are joined with the column "Order_ID". i am creating a table box in which 1st column is order_id, which listed the order_id's from all tables. 2nd column i am listing Order_number from Order table. Since i am listing order_number from order table, few of the values in order_number is showing blank, as the respective order_id's are from Invoice table. Please help me how not to show the blank values in order number.

[Miguel_Angel_Baeyens · Accepted solution]

In the object properties, check Dimensions > "Suppress when value is Null" or in Presentation > "Omit rows where field is NULL"