I'm stuck at a stage of my app that needs a template report from a work order (generating a quote PDF), everything is showing except the Service description. My data structure and it relationships are described bellow:
Order Table
WorkOrder Table
| WorkOrder ID | Order ID (ref - Order Table) | (etc)... |
WorkOrderDetails Table
| WorkOrderDetails ID | Work Order ID (ref - Work Order Table) | (etc)... |
Quote Table
| Quote ID | Order ID (ref - Order Table) | (etc...) |
My bot is associated to Quote's table. And i'm not being able to get the WorkOrder Details on the report, it is blank. My start expression is:
<<Start:SELECT(WorkOrder[WorkOrder ID],[Order ID]=[_THISROW].[Order ID)>><<[Related WorkOrderDetails]>><<End>>
LinkedIn
Twitter
