Is it possible in template reports to expand tokens for the result set columns outside the [EACHROW][/EACHROW] block?
Here's a very simplified example scenario:
A query returns a result set with the following columns representing an invoice:
Invoice Number (same for every row)
Line Number (different for each row)
SKU Number (potentially different for each row)
Description (potentially different for each row)
Price (potentially different for each row)
Assuming the goal is to display a pseudo-invoice on the screen, then ideally we'd want to display the Invoice Number field once, then cycle through the [EACHROW] block to list the multiple line items (Line Numbers, SKU Numbers, Descriptions, and Prices) associated with the invoice.
It appears that in the Template Text box, I can place only HTML outside the [EACHROW] block; attempting to place column tokens there does NOT result in them being expanded. However, every column token INSIDE the [EACHROW] block DOES expand properly.
Am I missing something obvious, or is this simply not supported? If not currently supported, can it be added (maybe with a [FIRSTROW] block if necessary)?
Thanks,
Warren
Is it possible in template reports to expand tokens for the result set columns outside the [EACHROW][/EACHROW] block?
Here's a very simplified example scenario:
A query returns a result set with the following columns representing an invoice:
Invoice Number (same for every row)
Line Number (different for each row)
SKU Number (potentially different for each row)
Description (potentially different for each row)
Price (potentially different for each row)
Assuming the goal is to display a pseudo-invoice on the screen, then ideally we'd want to display the Invoice Number field once, then cycle through the [EACHROW] block to list the multiple line items (Line Numbers, SKU Numbers, Descriptions, and Prices) associated with the invoice.
It appears that in the Template Text box, I can place only HTML outside the [EACHROW] block; attempting to place column tokens there does NOT result in them being expanded. However, every column token INSIDE the [EACHROW] block DOES expand properly.
Am I missing something obvious, or is this simply not supported? If not currently supported, can it be added (maybe with a [FIRSTROW] block if necessary)?
Thanks,
Warren