Hi, I have a report template for the following table structure:
BevDB - ingredient database
BevRecipe - Recipe menu item info
BevRecipeDetail - Recipe ingredient detail amounts, cost
Template is based on BevRecipe
This is pulling no information
<<Start: [Related BevRecipeDetails]>><<[Ingredient].[Item_Name]>><<[Qty]>><<[UoM]>>
<<[Cost]>> <> fyi End isn’t displaying properly int he text here.
Column [Related BevRecipeDetails] is the AppSheet generated REF_ROWS for the BevRecipeDetail table
[Ingredient].[Item_Name] is the dereference to the BevDB ingredient name
[Qty] is the column Qty in the BevRecipeDetail table
[UoM] is the column UoM in the BevRecipeDetail table
[Cost] is the column Cost in the BevRecipeDetail table
The information from the Parent table BevRecipe all comes through fine.
CATEGORY: <<[MenuBevCat]>>
MENU ITEM: <<[MenuItemName]>>
DESCRIPTION: <<[Description]>>
SELLING PRICE: <<[MenuItemSalesPrice]>>
TOTAL COST: <<[TotalCost]>>
POUR COST: <<[PourCost]>>
GROSS PROFIT: <<[GrossProfit]>>
SUGGESTED SP: <<[SuggestedSP]>>
I have followed the Order Capture app report template but have not managed to get any of the child table info to pull through in the Start - End expression.
Any help is greatly appreciated