Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reports showing only......
Message
De
13/05/2008 01:59:09
 
 
À
12/05/2008 22:38:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01316516
Message ID:
01316570
Vues:
18
Following the same advice Randy gave.............
1. When you call the report make sure the Veg is the currently selected table.

2. In the report form create a data grouping on Strain
in the menu click Report and Data Grouping
put Strain as the Group Expression
in Group Properties click Start Each Group on a New Page

3. Put all the fields you need in the Detail band. Do not include an alias in the field name.

4. In the Group Footer Band put the field you need totalled (presumably Quantity).

5. Double click on the field and in the Report Expression Dialog click Calculations. Select Sum.

FWIW.......I use VFP 8 rather than 9. I know that the report writer has been significantly enhanced, but I think this portion of the report writer is substantially the same.

>Okay here is an example of exact data etc to be contained within the report/s
>
>
>
>Data Table Name: Veg
>Fields pertinent to report: strain,quantity,location2,userid,date,notes
>Criteria Index On Strain, date (descending)sum totals on individual strain/s
>
>Strain          Quantity     location2     userid     date           notes
>Blueberry       150          1C            101        05/12/2008     and then..
>Blueberry       112          11D           104        05/12/2008     Okay!!
>Redwood         250          7E            100        05/12/2008     Ready 2day
>
>etc....
>
>
>
>what they are looking for is a report that will show only the totalsum of Blueberry possibly a dozen or more records with 1 sum total
>
>I am still kinda new at this I hope this helps
>
>Thanks in advance
>
>Fred W.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform