..2 Form
Create and save a new form
Launch an XLSX Workbench, and create a new form with name CHART_COMP .
Assign a context to the form
Assign a context ZCONTEXT_CHART_COMP to the form. When an automatically creation of the Form structure will be prompted, you should press the button
to create a structure manually.
Create a Form structure
Add the new components into form structure as shown in the picture below:
Context binding for components
Perform Context binding for «Loopstep» , «Value» and «Grid» according to scheme below:
Markup of template
Markup an Excel-template as shown below :
Note: To create both charts we use the Dummy (temporary) dataset .
So, select the Dummy dataset sell range, after that, go to menu Excel: Insert--> Chart and pick a chart that you need :
Template binding for components
Perform Template binding for all the «Patterns» and the «Value» according to scheme below:
«Grid» of the Dataset
Select the «Grid» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:
«Chart» for the Advertizing budget
Select the «Chart» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:
«Chart» for the Sales
Select the «Chart» component node in the Form structure tree, and make some settings in the Properties tab according to scheme below:
Activate the Form by pressing a button
Form is ready to use now.