Re: Memo Field in Report vfp 6 ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Mon, 3 Jan 2005 08:06:13 -0700

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
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Relevant Pages

  • Re: Memo Field in Report vfp 6 ?
    ... > Hi Wilson: ... > report bands and try it again. ... > try creating a simple report to see if the memo field behave the same way. ...
    (microsoft.public.fox.vfp.forms)
  • Re: Truncating of memo fields
    ... Robin wrote: ... >The data is not being compared in the memo field although ... >the query in a list box. ... >to run this report with many records, ...
    (microsoft.public.access.reports)
  • Re: Report issue
    ... The query now selects fields from 2 tables joined by a filed. ... The resulting list which contains the caption fields and memo field forms the ... code so that the report with one record will print as seperate printout. ... Below it the memo field ReportsMemo.crreport. ...
    (microsoft.public.access.modulesdaovba)
  • Re: A problem with clsJustifyText
    ... columns and 2 approaches of the justify code, which kind of confused me and ... The memo field contains forewords from different bodies, ... Do you have any other code behind this report? ... "Stephen Lebans" ...
    (microsoft.public.access.reports)
  • Re: Excluding Report Sections
    ... George, one more question. ... i am using a memo field and i would like to inset several variables within ... > In the query that your report is based on, ... Then the article section within the contract replace the standard ...
    (microsoft.public.access.reports)