bakerboy_1111
Registered User.
- Local time
- Today, 17:07
- Joined
- Dec 1, 2003
- Messages
- 43
Report that sums values in order
I'm currently trying to design a report that sums all the power flows in, say, a power plant. I'm having difficulty deciding how to set it out.
Firstly I'll try to describe what I hope to have in the report:
In a power plant layout, the different levels a connected in a way that's similar to a tree diagram. At the very ends of the tree diagram are the loads. These demand a certain amount of power. I would like to add up the powers at each node of the tree diagram, and be able to show these in the report. I was wanting to make it so that they are displayed on the report in a similar way to the actual layout, (that is, show the top level, then second, third etc).
For example, if I have a plant layout as shown in layout1.bmp attached, I would like the report to display something like the following:
TOP FEED LOWER FEEDS POWER
------------------------------------------------------------------
Switchboad 1: Load 1 5kW
Switchboard 2 8kW
Substation 13kW
TOTAL POWER: 26kW
------------------------------------------------------------------
Switchboad 2: Load 2 2kW
Load 3 4kW
Load 4 2kW
TOTAL POWER: 8kW
------------------------------------------------------------------
Substation: Switchboard 2 5kW
Load 5 3kW
Load 6 5kW
TOTAL POWER: 13kW
I wish it to be ordered from top feed to lowest as shown.
I have a table that has the following info:
Number, Name, Above Feed Name, Above Feed Number, Power
My logic is that as long as each load has an "Above Feed Name" then it is possible to figure out the layout.
Does anyone know how I can use this method to make my report do what I intend? Thanks to anyone who helps.
I'm currently trying to design a report that sums all the power flows in, say, a power plant. I'm having difficulty deciding how to set it out.
Firstly I'll try to describe what I hope to have in the report:
In a power plant layout, the different levels a connected in a way that's similar to a tree diagram. At the very ends of the tree diagram are the loads. These demand a certain amount of power. I would like to add up the powers at each node of the tree diagram, and be able to show these in the report. I was wanting to make it so that they are displayed on the report in a similar way to the actual layout, (that is, show the top level, then second, third etc).
For example, if I have a plant layout as shown in layout1.bmp attached, I would like the report to display something like the following:
TOP FEED LOWER FEEDS POWER
------------------------------------------------------------------
Switchboad 1: Load 1 5kW
Switchboard 2 8kW
Substation 13kW
TOTAL POWER: 26kW
------------------------------------------------------------------
Switchboad 2: Load 2 2kW
Load 3 4kW
Load 4 2kW
TOTAL POWER: 8kW
------------------------------------------------------------------
Substation: Switchboard 2 5kW
Load 5 3kW
Load 6 5kW
TOTAL POWER: 13kW
I wish it to be ordered from top feed to lowest as shown.
I have a table that has the following info:
Number, Name, Above Feed Name, Above Feed Number, Power
My logic is that as long as each load has an "Above Feed Name" then it is possible to figure out the layout.
Does anyone know how I can use this method to make my report do what I intend? Thanks to anyone who helps.
Last edited:
