...
- On the Report Edit window, click the Browse… Browse… button to Select file to upload (Fig. 4.4.1).
- When loaded, the file name will be displayed underneath the Browse… button. Watch out: The report export from Desclogik is a .xlsx-file. For Thin section report writer to accept the file, you have to open the .xlsx file, change the file format to 'Excel 97-2003 workbook/.xls', just renaming the workbook extension won't do the trick.
- On the Report Edit window, click the Declare worksheets button to open the Declare Worksheets window (Fig. 4.4.2).
- On the Declare Worksheets window, a Data source worksheet item with default name "new TAB #" will be displayed and marked in yellow because it needs to be edited. Click the Add button to add as many items as you have worksheets to declare.
- In this section you only need one (the first) worksheet in the training workbook. However, eventually you'll use three so you may as well declare them now.
- Double click the first list item(s), or select it and click the Edit button.
- Select the Source worksheet name from the drop-down list of available worksheets in the source workbook.
- Using the training workbook, select "worksheet1" from the drop down list of all worksheets in the training workbook.
- Set the Identity source column to the column in the data sheet that has the identifying "sample" information (typically the row headers in the data, i.e., the first column).
- Using the training workbook, select the first column "w1samples" from the drop down list of all columns in the worksheet.
- Is this the report control worksheet? Only one worksheet can be the control worksheet and the answer is typically "YES" for the first worksheet, and "NO" for all other worksheets.
- In our training workbook, worksheet1 is the control tab.
- Repeat for all worksheets to declare.
- Using the breadcrumbs, return to the Report Edit window.
- Save your report using the Save to Database button at the top right..
...