Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report with Memo fields
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00681450
Message ID:
00682505
Vues:
19
>Zlatin,
>Thanks for your reply first.
>The data model is that it is an invoice print out form.
>I have already selected all records out to a temporary table.
>I need to place the shipping mark and item details at the
>same detail band. That means left side is the only one
>shipping mark from invoice header and right side are the
>item details. They need to be printed at the same lines
>row by row. But I found I can't make this report format
>by using VFP6 report designer. If I put the Memo field
>shipping mark at the same the row with item details,
>The come out is that the rest of items starting from second
>record are printed below the shipping mark Memo lines. That
>means the first record and the second record are separated
>many rows by the Memo lines.
>How to design this kind of report? I hope you will understand
>my point.
>
>Thanks again.
>
>Samuel


The detail band is definately designed to be one record per horiztonal row. Therefore, it doesn't accommodate what you are trying to do which is spread some information from one record across several detail rows. The only way I can think of to do what you want is to preprocess the data and fudge it. Start by adding all your detail records as usual, except add a new character field for the shipping info. Then for each invoice, use ALINES to chop the memo field up into separate lines. Loop through the array, writing each row of the array to the next detail line for the invoice. If you run out of detail lines before the array is done, add extra dummy lines to the cursor until the entire array is used up.

Cathy
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform