🚀 go-pugleaf

luna <lun@mos.com.np> wrote:

>i have this problem with reports. A field in my table is of type memo.
>This contains a list of various words and sentences separated by new
>lines. If i view this table from any form or intrabuilder, it looks
>alright.
>However if i create a report using this table, the report totally
>ignores all the new lines(\n)

HTML does that. Change the new line characters to <BR> ... (HTML for a
line break).

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm

luna wrote:
> 
> hi
> i have this problem with reports. A field in my table is of type memo.
> This contains a list of various words and sentences separated by new
> lines. If i view this table from any form or intrabuilder, it looks
> alright.
> However if i create a report using this table, the report totally
> ignores all the new lines(\n)
> So what i get is all the lines and words sqeezed together compact, which
> 
> makes it very difficult to read. Is there a way to make reports show
> field contents which have new lines more clearly.
> hope this makes sense.
> 
> Thanks for any help.
> 
> Luna Rajbhandari

I'd made a function converting the newlines into <BR>'s, it's a bit slow
on big memos but it works.


   function memo2html(s)
    {   
      if (s=="") return("");
      s1 = new StringEx(s);
      newhtml = "";
      x=0;
      for (i=0; i < s1.length; i++ ) {
        if (s1.charAt(i) == s1.chr(13)) {
        newhtml=newhtml+s1.substring(x,i)+"<BR>"
        x = i+1;
        }
       }
     newhtml=newhtml+s1.substring(x,i)+"<BR>"
     return(newhtml);
    }


, Boris