I have a report that creates a running sheet for orders to be taken our by a delivery driver.
There are 3 tables.
Main table with outlets (Full List Table). Child table with orders (Orders) and Grandchild with Order details (Order Details)
There is a column in the Orders table to give the order a “Drop Number”. The user can assign a number from 1 upwards to give the order in which the deliveries shoud be made.
I can very easily create a view that shows the orders in the correct order down the page but I am having trouble getting the report that is emailed to show the orders acording to drop number.
Below is the first part of what works at the moment. The [Drop Number] column is in the main parent table as I was going to assign the drop number to the outlet but realised that it is better for the user to do that to each individual order. The below expression doesn’t place the order in a sequence becasue the [Drop Number] Column is blank for each outlet. Running Sheet 22 is a slice of the main parent table.
As the expression must return a list of Unique IDs I need to be able to return a list of the Unique IDs of Running Sheet 22 Slice and order them by the column [Drop Number] in the Child table not the parent.
<<Start:OrderBy(FILTER(Running Sheet 22,true),[Drop Number])>>
Customer Name: <<[Name]>>, <<[Short Address]>>, <<[Post code]>>