Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using the correct table format in a report
Message
De
12/07/2000 15:24:16
Cindy Winegarden
Duke University Medical Center
Durham, Caroline du Nord, États-Unis
 
 
À
12/07/2000 15:10:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00390809
Message ID:
00391462
Vues:
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
    LargeMemoCursor.LargeMemo = ;
        ALLT(LargeMemoCursor.LargeMemo) + "***Separator goes here***" + ;
        ALLT(TableWithMemoFields.MemoField)

ENDSCAN


>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform