Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using the correct table format in a report
Message
 
 
To
12/07/2000 15:24:16
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00390809
Message ID:
00391483
Views:
9
>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) && or numeric key
>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 && in clause is also important to avoid problems with EOF()
>

>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform