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.