I’ve got a json data source and the root object has an array of accounts. I’d like to render each account as its own row. The first couple of columns would be the code and title associated with the account. Then I want to include an array of monthly expenses for each account. The monthly expenses may be of an arbitrary size and thus cannot be represented as twelve distinct properties.
I’ve been trying to achieve this with a smart marker like this:
&=sourceData.accounts.monthlyExpenses.value(horizontal, numeric)
However, this renders all the monthly expenses for all accounts in a single row
image.png (9.5 KB)
My desired output would look something like this:
image.png (7.4 KB)
I’ve attached the example designer spreadsheet and json data.
TwoDimensionalTemplate.zip (8.6 KB)
Please note that I’m attempting to do this exclusively with smart markers and a single json data source. the c# app is completely ignorant of the content of the Designer Spreadsheet and the json data - it just loads them from disk, calls process and saves the output.