General information
Category:
Reports & Report designer
Title:
Parent Child reporting query
Environment versions
Network:
Windows 2003 Server
I am trying to produce a report with a parent-child table involved. The parent table has a budget field and the child table has a series of entries under the budgeted item.
I want to be able to show the budget sum in the summary band; how do I get the report to take a single budget value? At the moment, whatever I do, I get the budget figure multiplied by the number of child entries. So, if I have a parent record with a budget figure of 5 with 3 supporting child entries, the total budget for the group is 15 when it should be 5.
thanks
Barry Sutton
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