We are developing a Movement Task Report in WMS(Web Gen Report).

We are developing a Movement Task Report in WMS(Web Gen Report). Most of the column in the report are pulled from Task, Wave enquiry and Allocation pages.We need to populate the destination column for Tasks in Ready status. It seems allocation table doesn't populate(value is null) destination location for tasks in Ready status, it only populates when task is completed. Apart from allocation table this destination column is available at the  Movement Request header Page and we want to pull the value in the report. So we want to know how to connect the Task table with