>Cheryl,
>
>First off - my favorite advice is that it is easier to run a report off 1 table/cursor rather than 2. Data would be combined with a SELECT statement and would be non-normalized just for the report. Saves issues with SET SKIP.
>
>Now, for your large memo.
>
>CREATE CURSOR LargeMemoCursor (KeyField C(10), LargeMemo M)
>INDEX ON KeyField TAG KeyField
>
>SELECT TableWithMemoFields
>SCAN
>
> *!* Find the record or add a new one
> IF !SEEK(TableWithMemoFields.KeyField, "LargeMemoCursor")
> APPEND BLANK
> REPLACE LargeMemoCursor.KeyField WITH TableWithMemoFields.KeyField
> ENDIF
>
> *!* Add your own separator between the individual texts
> <b>LargeMemoCursor.LargeMemo = ;
> ALLT(LargeMemoCursor.LargeMemo) + "***Separator goes here***" + ;
> ALLT(TableWithMemoFields.MemoField)</b>
>
>ENDSCAN
>
Hi Cindy,
Ai-Ai-Ai!!!!!!! (it's a Russian expression) :) Do you assign field content with =??????
Use Replace instead:
local lcMemoString
lcMemoString=lcMemoString+lcSeparator+ALLT(TableWithMemoFields.MemoField)
replace LargeMemoCursor.LargeMemo with lcMemoString in LargeMemoCursor
>
>>Thanks for your help. I haven't looked at VFP in a long time and this is helping refresh my memory.
>>My problem really lies in the fact that I have two tables being the drivers one is in the detail line as normal and the other one is in the group area. This is the one that I have the descr table 1 thru 15 and each group is a separate descr number so that we get clean breaks between each page to keep the data together. Here is the real problem. since this is the the group area I don't keep rereading that table. Is there a place a I can read through this table store all the memo fields together as one huge field and print this field? Would I hit a space limit? Sorry for the confustion at the beginning. I forgot how the report was set up.
If it's not broken, fix it until it is.
My Blog