1 Reply Latest reply on May 21, 2020 1:41 AM by Luffy

    Ask about report queries on oracle apex

    Luffy

      Hi eveyone,

      I use rtf layout for report layout. When I export report query to excel format of apex version 19, i have one problem. More detail, now I return value in excel:

      abc

      def

      cgh

      But I hope to return value in excel to that format: abcdefcgh. I try my best to adjust options for rtf layout. Thank everybody in advance. A challenge for me.

       

        • 1. Re: Ask about report queries on oracle apex
          Luffy

          Hi people,

           

          I am lucky for finding the statement for this case. It is called exactly name (remove line breaks). I provide that statement for anyone who need it as me. 

           

          replace(replace(emp.name, chr(13), ''),chr(10), ' ')

           

          Thank eveyone again for viewing that question. If that request is not useful for everyone, I hope @Admin 'll remove it.