Very Computer

I have encountered a "Major Bug" in Foxpro 2.6 for Windows.

When using MEMO fields that a larger than one page in a GROUP band,
Foxpro WILL NOT start the data on the first page if the data should
require a second page.  It should fill up the first page with the MEMO
data, then continue to the second page?

To reproduce this behavior

Use a single table with 2 fields
    ACCT_NO        character 8
    ACCT_NOTES  memo

Put the ACCT_NO in the detail band.
Create a group band by ACCT_NO and put the ACCT_NOTES field their.
Click the property "Field can stretch".

Insert enough text in the MEMO field (ACCT_NOTES) to require a second
page.
Preview the report

This Bug/Problem is really kicking my ass!
Any Ideas will be greatly appreciated!

Thanks in Advance!
Don

Fox 2.6 has serious problems with memos in reports, as you have found.
There are only workarounds, but no solutions.  You can get 3rd party
report writers, which work well, but take some time to get used to.

One summer I did work for the government on a personnel system in 2.6.
One of the programmers was saddled with the daunting task of not only
getting the famed "Page X of Y" label working on a report, he also ran
into the problem you have encountered when memos run across pages and/or
groupings.  

Good thing the project was shelved after a few years and several million
of our tax dollars.

- John

Quote:>I have encountered a "Major Bug" in Foxpro 2.6 for Windows.

>When using MEMO fields that a larger than one page in a GROUP band,
>Foxpro WILL NOT start the data on the first page if the data should
>require a second page.  It should fill up the first page with the MEMO
>data, then continue to the second page?

>To reproduce this behavior

>Use a single table with 2 fields
>    ACCT_NO        character 8
>    ACCT_NOTES  memo

>Put the ACCT_NO in the detail band.
>Create a group band by ACCT_NO and put the ACCT_NOTES field their.
>Click the property "Field can stretch".

>Insert enough text in the MEMO field (ACCT_NOTES) to require a second
>page.
>Preview the report

>This Bug/Problem is really kicking my ass!
>Any Ideas will be greatly appreciated!

>Thanks in Advance!
>Don

Hi Don

You're right, there's a problem with Memo fields in the group band.
But can you try this ?
In the group band, call a function instead of having your memo field there
Create a character field in the group band, and put in it MEMOHERE()
And in the main program, you should have :

FUNCTION MEMOHERE
?? ACCT_NOTES
RETURN ""

In Foxpro 2.5b for Dos, all the Memo field (75 lines) appears then correctly
in the Print Preview window

You'll probably have to change the value of Set Memowidth To

Maybe this idea can help you ?

Paul Duvall

   -**** Posted from Supernews, Discussions Start Here(tm) ****-
http://www.supernews.com/ - Host to the World's Discussions & Usenet

Paul,

I tried what you recommended below in FPW 2.6.  Unfortunately it did not work :(

Have you been able to get this to work in the Windows version for Foxpro?