M
M Skabialka
I need something like a TRANSFORM statement that doesn't use aggregate
values.
I have a vehicle inventory where the parts have serial numbers. There are
multiple cases of the same part on a vehicle.
I need a report of all serial numbered parts on the vehicle - different
vehicles have different parts being tracked.
e.g - serial numbers on these three vehicles:
Wheel Door Mirror
Vehicle 1 123 645
Vehicle 1 124 574
Vehicle 1 125
Vehicle 1 126
Vehicle 2 789 345 568
Vehicle 2 790 854
Vehicle 3 843 736
When I do a TRANSFORM statement I have to choose an aggregate function, so
it must be count, or sum, or first, etc. But for this report I need all
serial numbers.
I tried FIRST and ended up with only one line for each vehicle. Serial
numbers can't be counted, summed etc.
Not knowing what parts, or how many serial numbered parts per vehicle, how
can I create a summary report as above?
Mich
values.
I have a vehicle inventory where the parts have serial numbers. There are
multiple cases of the same part on a vehicle.
I need a report of all serial numbered parts on the vehicle - different
vehicles have different parts being tracked.
e.g - serial numbers on these three vehicles:
Wheel Door Mirror
Vehicle 1 123 645
Vehicle 1 124 574
Vehicle 1 125
Vehicle 1 126
Vehicle 2 789 345 568
Vehicle 2 790 854
Vehicle 3 843 736
When I do a TRANSFORM statement I have to choose an aggregate function, so
it must be count, or sum, or first, etc. But for this report I need all
serial numbers.
I tried FIRST and ended up with only one line for each vehicle. Serial
numbers can't be counted, summed etc.
Not knowing what parts, or how many serial numbered parts per vehicle, how
can I create a summary report as above?
Mich