Hi
The "idea" was to group by load, then a subtotal by load and a project total.
Subtotal and projecttotal should be a sum of the table 'ASSWEIGHT', subtotal -> per load a total of 'ASSWEIGHT' and projecttotal -> total of all values 'ASSWEIGHT'.
Subtotal calculates oke and projecttotal was not the issue, this calculates easily.
The problem I have is the grouping with these 2 datasets.
Dataset 2 contains the different possible loads.
Dataset 3 contains the data.
Grouping should be done by dataset 2 (by LOAD) with values showed of dataset 3.
------------
Second :
As you can have more then 1 value of column NR which is the same in 1 load, I was thinking of some sort of "inner calculation" to get the amount of identical data in 1 load.
(Identical data in column NR)
For example:
load_1 contains 2x
NR 101IDX ID NR PROF ASSDIM ASSWEIGHT LOAD
5 100020 101 HEA200 3000*190*200 127 load_1
6 100017 101 HEA200 3000*190*200 127 load_1
load_1 contains 2x
NR 30017 100041 300 HEA180 4000*171*180 142 load_1
20 100042 300 HEA180 4000*171*180 142 load_1
So I also would like to have a total of how many times the value in column
NR occurs.
In my first post, that is the '2x 101 subtotal 254' and '2x 300 subtotal 284' line.
Although the actual subtotal per NR is not really neccesary, the amount of entries of NR in a load would be really handy.
(Let's assume NR 101 has 23 entries in Load_1, it would be handy it is on the report how many times 101 is in load_1 without having to count it yourself. Read, 23 times line with all data of NR 101 printed below each other.)
load_1
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
101
Would refer to
If you show report 2 of my tryout, you will see that on the first page the list has an entry:
Maybe an extra column which states:
will be easier, I don't know an I don't know if this is possible.
I hope this is more clear to you ?