Hi Girvin, the Report-Builder should better get this information from the view, which is datasource of the report. All what could be done through SQL before submitting the data to the report will work faster (and mostly better).
You have to write in SQL SELECT '-'||"text" FROM "table" This will submit all content of the field "Text", which contains characters (or empty text) with a '-'. All fields, which are NULL, we be NULL without '-'. Regards Robert -- Homepage: http://robert.familiegrosskopf.de LibreOffice Community: http://robert.familiegrosskopf.de/map_3 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy