General information
Category:
Reports & Report designer
Title:
Problem with one to many report
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only