Steps to import from excel: |
1) |
Get your form and data ready.
Form - importing data into a report means that a form must first exist containing all fields one wants to pour data into.
So make sure that the form contains the field elements that you want to import data into.
Data - make sure that your data is formatted to match the fields you would like to import to.
For example:
A field with yes/no option that should be imported into a checkbox field should have values of 1 or 0.
|
|

|
|

|
2)
|
Choose the 'Import Data' option in the toolbox left menu.
|
|

|
3)
|
Pick the xls (Excel) file you would like to import data from.
Once you have picked a valid file a table will appear, consisting of columns drawn from the xls file.
|
|

|
|
|
at the head of each column there is a listbox containing all the fields in the form.
All you need to do is asign each xls columm to a form field (showing in listbox)
|
4)
|
Press on the 'Import Data' button. The xls data will appear as data entries in the report bellow.
|
|

|