Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with one to many report
Message
From
03/06/2004 09:08:41
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
03/06/2004 05:58:07
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00909492
Message ID:
00909523
Views:
8
Simply, don't use one-to-many.

Create a cursor (result of a query) with the data you want to print, and base the report on that cursor.

How is the sum "wrong"? What is the expected result, versus the result you obtained? - For summing, one common error is to make VFP sum twice: once in the report variable, and once in the report field.

>I have 2 tables
>Parent table TABLE_P have fields: BADGE,GROUP_FILED,NAME1,SUM_1
>Chield table TABLE_C have fields: BADGE,NAME_O
>
>In data environment TABLE_P related with TABLE_C as one to many ( by field BADGE).
>
>In report it is two grouping fields: GROUP_FIELD and BADGE
>
>And I want to summary SUM_1 in TABLE_P grouping by GROUP_FIELD into sum_variable
>
>But in result summary position I have wrong sum_variable
>Please help me how I can sum field from parent table in report type
>"one to many"
>Thanks.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform