Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reports showing only......
Message
From
13/05/2008 01:59:09
 
 
To
12/05/2008 22:38:52
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01316516
Message ID:
01316570
Views:
16
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform