You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Web Reports Gen2 Calculate Number of OB Stops

in Warehouse Management

Summary:

I am trying to modify a web report ("Advanced Report") so it will show the number of OB Stops on every record of an OB Load.

Content (please ensure you mask any confidential information):

I am joining on 4 Data objects: 'facility', 'load', 'load_status', and 'ob_stop'.
So far, I have these columns included with their associated fields:
| Facility | Load Number | BOL |
| {facilty.code} | {load.load_nbr} | {load.bol_nbr} |

In the column on the far right, I want to have the field be the number of OB Stops associated with the Load number and BOL, but I can't seem to find a way to get this information included in the report. Right now, since I added a join on the 'ob_stop' data object, it at least displays a number of rows with the same Load and BOL number that are equal to the number of stops there are for each Load, but I would like to make it so that every record of a Load Number will only display

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!