Hi everyone, I am having some trouble figuring out report templates and I have some questions.
What I have figured out is that the table used for the workflow already has an implicit Start function. The problem is I want to show data that is not necessarily related. How it makes sense to me is that you need a list of key values for a table you want to show data from. Something like:
<<Start: Select(Batches[BatchNo], [BatchNo] = [_THISROW].[BatchNo_ID])>>
BatchNo is the key value for the batches table and BatchNo_ID is the Batch Number field for the packaging table. This should return a list with one entry. Due to reasons the packaging table is not related to the batches table. What happens is none of the fields in Batches are displaying. For example after that start expression for Batches I enter <<[BatchNo]>> with an <<“End”>> and nothing is displayed. I can’t see the error of my ways as this is exactly how the literature explains it. Any help would be greatly appreciated.