Re: Memo Field in Report vfp 6 ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Fred Taylor (ftaylor_at_mvps.org!REMOVE)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 08:25:39 -0700

Use ALLTRIM(yourmemofield) in the report expression, or use RTRIM() if
leading spaces are important. Note that if the trailing white space is
CR/LF, you'll still get the blank lines. In that case, you'll need to write
a function that will remove the extra white space.

FUNCTION trimcrlf
LPARAMETERS tcInfo
tcInfo = RTRIM(tcInfo)
DO WHILE RIGHT(tcInfo)=CHR(13)+CHR(10)
  tcInfo = LEFT(tcInfo,LEN(tcInfo)-2)
ENDDO
RETURN tcInfo

Either build this function into your application, or have it present in the
same folder as your application and make sure it's compiled. Call it by
using TRIMCRLF(yourmemofield) in the report expression for that field. 

-- 
Fred
Microsoft Visual FoxPro MVP
"Wilson Pye" <wilsonpye@comcast.net> wrote in message 
news:nP-dnXoobaXEznzcRVn-2Q@comcast.com...
> Hi Fred,
>
> You were correct, the last record of the filtered data set had blank 
> lines.
> Is there a way to clean up all the memo fields in the cursor before 
> running
> the report?
>
> Thanks
>
> Wilson Pye
>
>
> "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
> news:On7sEXa8EHA.2192@TK2MSFTNGP14.phx.gbl...
>> Yes, but are any blank records showing in your record set that you're
>> reporting from?  Does the last memo field that has data have a lot of
> blank
>> space at the end of it?  Either one of those two conditions can cause
> blank
>> pages.
>>
>> -- 
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "Wilson Pye" <wilsonpye@comcast.net> wrote in message
>> news:Zb0Cd.742551$mD.364470@attbi_s02...
>> > Hi Fred,
>> >
>> > I have a filter set and  the last record is printing.  Then I get a
> number
>> > of blank pages in the preview.
>> >
>> > Wilson
>> >
>> > "Fred Taylor" <ftaylor@mvps.org!REMOVE> wrote in message
>> > news:%23iVEQnP8EHA.1292@TK2MSFTNGP10.phx.gbl...
>> >> Do you have blank records or extra blank space at the end of your memo
>> >> field?
>> >>
>> >> -- 
>> >> Fred
>> >> Microsoft Visual FoxPro MVP
>> >>
>> >>
>> >> "Wilson Pye" <wilsonpye@comcast.net> wrote in message
>> >> news:RRWBd.608019$wV.301937@attbi_s54...
>> >> > Hi Lee,
>> >> >
>> >> > Thanks for the information.  I did tighten things up.  The problem I
> am
>> >> > having is multiple blank pages after the last record.
>> >> >
>> >> > Wilson
>> >> >
>> >> > "Lee Mitchell" <Leemi@online.microsoft.com> wrote in message
>> >> > news:acFh1G47EHA.1512@cpmsftngxa10.phx.gbl...
>> >> >> Hi Wilson:
>> >> >>
>> >> >> This is a broad question.  The Report Designer has never handled
> memo
>> >> >> fields very well.  In general, you want to remove any extra space 
>> >> >> in
>> > the
>> >> >> report bands (white space) and try it again.
>> >> >>
>> >> >> Are you using any data grouping or calling any UDFs in the report?
> If
>> > so,
>> >> >> try creating a simple report to see if the memo field behave the
> same
>> >> >> way.
>> >> >>
>> >> >> I hope this helps and have a Happy New Year!
>> >> >>
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> > rights.
>> >> >>
>> >> >> Sincerely,
>> >> >> Microsoft FoxPro Technical Support
>> >> >> Lee Mitchell
>> >> >>
>> >> >>
>> >> >> Keep an eye on the product lifecycle for Visual FoxPro here:
>> >> >> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
>> >> >>    - VFP5 Mainstream Support retired June 30th, 2003
>> >> >>    - VFP6 Mainstream Support retired Sept. 30th, 2003
>> >> >>
>> >> >> >Hi,
>> >> >>
>> >> >> >Can anyone shead some light on how to get a memo field to behave 
>> >> >> >in
> a
>> >> >> >VFP
>> >> > 6
>> >> >> >Report?
>> >> >>
>> >> >> >I am getting extra pages in the end, extra pages in the beginning,
>> >> >> >there
>> >> >> >seems to no explanation.
>> >> >>
>> >> >> >Wilson
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>>
>
>