Click here to download the complete files for all steps in this tutorial.
We will now add a detailed image of each customer’s location to the report. To do this we define another show map-style data adapter. Click on the tab at the top of the script editor with the title Image data per row (shown as just ‘Map’ in later versions of ODL Studio). You will now see the following:
Press the Add a table button and in the dialog that pops up, select the Customers table as the source table and the Drawables table (called DrawableObjects in ODL Studio version 1.0.0) as the destination table. A data adapter table will then appear, for you to define the map view for individual customer points. Configure the adapter exactly as shown in the following screenshot:
Note we have set Address as the source under imageFormulaKey. This is because we will use the address as a unique key field to link the table generated by this data adapter to the main report’s table.
We will now add this image to the main report. Do the following steps:
Using image formulae can be complex; for your own reports you could instead hire us to help you set these up. For the technically-minded user, this formula does the following:
Save the script and run the view basic report function as per the previous steps. After a few seconds, this generates a report with this first page: