Hi guys,
I am currently learning VW after moving from AutoCAD, and I'm hoping for some help with the reports.
I've got several lighting pipes, which I've converted into hanging positions and attached lighting devices.
I've used the total hung weight record and it includes the weight of the pipe, which is great if you're hanging the pipe as well.
But if you are using venue pipe, the venue just wants to know how much you are putting on the pipe.
I've tried a few methods and ended up with the below, which is almost what I need, but not quite.
Using criteria such as: if lighting device has position X.
Using substring to remove the "kg" which means I can convert it to a value and then sum in the data base header.
I really only want two columns and a row for each position in the report (plus headers).
Position, Weight
Lighting Bar 1, 250kg
Lighting Bar 2, 311kg
I'm currently stuck with the database showing in the worksheet and then the sum only in the database headers.
Its a bit of a work around, because I would need to duplicate this for each hanging position and append, unless there is a way to do it all at once that I'm not seeing.
But the work around is ok if I can get the result.
What am I missing here?
Hazz