Dynamic Reports

Alan Cooke said:
Where/how do I use the JSON?  This will be a first for me.

 Under Test Print there is a switch for Custom JSON, flip it on.

Then click on the Fx button. For some reason clicking on blank field does nothing.

Then type in your code.

To create a JSON you only need to use the curly brackets { }.

Like in my example previously, I put in a variable a select to get a subset of records. Then I created my JSON.

If you only want to create a JSON for the current record you can just use the curly brackets.

{
jsonName1: fieldname1,
jsonName2: sum(referencefield.number),
}

The nice thing about using the JSON is that you can create fields that pull data from anywhere in your DB and add it to your print. You can create your own subtables as well.

let otherTableData := select otherTable
{
jsonName1: fieldname1,
jsonName2: sum(referencefield.number),
jsonName5: count(otherTableData),
jsonSubTable: for loop1 in (a select or a reference field) do
    {
        jsonName3: loop1.fieldname3,
        jsonName4: loop1.fieldname4
    }
}

So I have something like this as a word file, notice the subtable in the table:

And my code looks like:

let x := (select Ingredients);
x.{
    jIngredient: Ingredient,
    jCost: Cost,
    jActivity: for loop1 in Activity do
        {
            jAction: loop1.Action,
            jQuantity: loop1.Quantity
        }
    end
}

And this is my output:

You can also reference Carbone's documentation for help as well.

Fred

As a First try this would be correct ?

Can't see anything