...

Double-click the icon below to get the training workbook and save it to your disk. You need to load it in the Builder and Writer applications.
Anchor_MON_1535879694_MON_1535879694

3. TS Report Writer

Getting ready

...

• In the SHIP Production environment, go to this link and download the app:
• http://web.ship.iodp.tamu.edu/tasapps/thsreport/jnlp/THSReport.jnlp
• In the SHORE Production environment, go to this link and download the app:
• http://web.iodp.tamu.edu/tasapps/thsreport/jnlp/THSReport.jnlp
• Follow your browser's instruction to install the application from the JNLP file.
• Click the Run button.
• Login as guest/guest (Fig. 3.1.).

Figure 3.1. Writer login window

...

After login, you are presented with a list of all existing report version that have a report status of open (O) or locked (L) and a version status of active (A) or released (R) (see Fig. l.3.2; more on report and version status later).
Figure 3.2. Writer window after login.

To print a batch:

• Select the appropriate report definition.
• Here, select TRAINING_REPORT with the latest version number.
• Browse to the appropriate data source Excel workbook using the Find SpreadSheet button. This should be the workbook that was used for the report definition as far as worksheet names and column names are concerned. Data may have changed.
• Here, select the ts_report_training workbook from wherever you placed it.
• Using the Report Destination button, select a folder where the report files will be written to
• Click the Validate button and the program will check if all names used in the report definition also exist in the data source workbook (and a few other things). You will get an error messages if the validation fails and have to resolve the issue.
• If the validation succeeds, the Create Reports button becomes active – click it to print the reports.
• A progress bar and counter will inform you of the progress.

...

Figure 4.2.1. Login window to Builder application.

Two types of user roles exist: Manager and Editor. Your account is given one or both by the system administrator and the type of authorization determines what you will see and be able to do. Most of the relatively few users are authorized for both roles.Image Added

4.3. Select or create a report to work with

...

After you logged in, you initially see two of the four functional areas of the Front Panel (Fig. 4.3.1.).

Image Added

• Top bar for user id and logout.
• Search area with multiple search options that combine to display a list of selected report versions.

...

Report status and Versions Status each always have one of four options selected and understanding these options and their combinations is critical (see below and Table 1). If you don't make any selection and click the Search button, the default display is all Open only reports and Active only versions from any owner, in reversed alphabetical order to display the more recent expeditions farther up on the list (Fig. 4.2.3).

Image Added

Figure 4.3.2. Main screen listing selected reports.

...

Table 1. Common applications of report and version status search combinations.

Editor menu

The Editor action menu is available if user is an authorized editor (Fig. 4.3.3., left-hand side).

...

• Edit report
• Clone Report: This is the most commonly used way of renaming or becoming owner of an existing report version.
• Create New Report: If you really want to start a new report from scratch.
• Export Definition: Option if you want to save an existing definition for use outside your environment for some reason. Exporting report definitions typically prints the JSON type definition into a new browser page.
• Copy-paste the content into a text editor and save as text.
• If necessary, add a file name extension "txt".
• Known issue:
• Many programs or operating systems do not understand the extension "JSON". If you don't get a new browser page with export
• In Firefox Preferences, Content/Pop-Ups, uncheck "Block pop-up windows
• Import Definition: Option if you want to use an existing external definition in your environment for some reason. Browse report definition file.

Image Added

Manager menu

The Editor action menu is available if user is an authorized manager (Fig. 4.3.3., right-hand side).

...

Figure 4.3.3. Manager and Editor action menus.

Image Added

4.4. Building a simple report based on one source data worksheet

...

• On the main screen, click the Create New Report button from the Editor menu.
• Note that you could also select an existing report from the list and click the Clone Report button,
• Enter a name for the report.
• Don't sweat it, you can always change the name by cloning the report later!
• Click the OK button and the new report is added to the report version list on the Front Panel.
• Find your new report on the list, select it by checking the box left to it, and click the Edit button. You are now in the Report Edit window and ready to go (Fig. 4.4.1).

Image Added

Figure 4.4.1. Report edit window.

...

Now you are ready to design the report layout. You could try to print the reports now using instructions in Chapter 3, and find that everything works but you don't get any report because, we'll, you haven't defined any layout items yet.
Figure 4.4.3. Footer edit window.

Image Added

Adding and configuring layout elements

...

Now you are ready add fields, text, grids and tables to the block. Note: if you are trying to print the report at this stage you will still not get anything because empty blocks are intentionally programmed not to show.
Figure 4.4.5. Block edit window_Block Left & Right offset needs to be zero or wrapped text will spill over block border._

Image Added

Field element

The Field element is used (A) to print single values from the data sheet, and (B) to print images stored in the IODP ASMAN asset management system and downloaded on your machine when you run the Writer program.
The important thing to understand about field (and text, see below) layout element is that its location is fixed relative to the enclosing block, i.e., it is not being dynamically stacked below other layout elements the way block, grid and table are. So if you are configuring multiple fields and leave the same default offsets (from enclosing block), they will print on top of each other.
You can place multiple field (and text) elements horizontally next to each other (something you cannot do with block, grid and table elements). However, you have no control in setting the width of the field (or text) element, and the content cannot wrap, which means your content may be cut off at the right margin of the page. All you can control is the top left position of each field (or text) and that, in conjunction with the expected length of the content string, is what you have to manage positioning.
For the two limitations described above, it is recommend that the field element is used sparingly to display general data values (case A), if at all. The grid element is often a better option. However, field is the only layout element that can display images (case B) and that is its principle purpose.

A. Print a simple single value from the data sheet (we use the sample name here)

...

...

• From the Report Edit window, double-click the "block1" item to enter Block Edit. (or select the item and click the Edit button).
• From the Select element to add list, select Field, then click the Add button.
• A field item with default name "new FIELD #" will be added to the Layout Elements list.
• Double-click the new Field item to open the Field Edit window (or select the item and click the Edit button).
• For the Data source column, select the attribute column from the source worksheet to be used.
• Remember, the attributes available in this list are from the worksheet associated with the enclosing block.
• Using the training workbook, select "w1samples" here.
• Set Left offset (points) to move the field content to the right relative to the enclosingBlock Left & Right offset needs to be zero or wrapped text will spill over block border block.
• For our training report, set it to 100 points so we can add a text label in front of it.
• Set the Top offset (points) to move the field content down page from top of block.
• For our training report, set it to 0 points.
• Set the Font size (points).
• Set it to 12 for our training report since this is our report title.
• Set the Font style.
• Set it to BOLD for our training report since this is out report title.
• Set the UseMe flag. This should typically be "YES" otherwise the content will not display and unless other content exists below, the entire block will not display.
• Set to "YES" for our training report.
• Set Border. For fields, this is typically set at NONE.
• In our training report, we don't want to draw a box around the title.
• Is this an ASMAN image column? This flag is critically important. If set to "YES", the image process is triggered (see part B).
• For our training report, the answer is "NO" here.
• Therefore, the Image width (40-500 points) is irrelevant here.

Image Added

Figure 4.4.6. Block edit with first block getting a field layout element.

Figure 4.4.7. Field edit window.

Image Added

B. Print images

Printing images has some extra requirements:

...

• From the Report Edit window, double-click the "block1 title" item to enter Block Edit (or select the item and click the Edit button).
• From the Select element to add choices, select Text, then click the Add button.
• An item with default name "Text: new TEXT #" will be added to the layout items list.
• Double-click the new Text item to open the Text Edit window and configure as follows for our training report (Fig. 4.4.8.):
• Text to display = "SAMPLE NAME:"
• Left offset (points) = 5 (default).
• Top offset (points) = 0 (same as sample ID field).
• Font size (points) = 12 (same as sample ID field).
• Font style = NORMAL

Image Added

Figure 4.4.8. Text edit window

...

• Go back to the Report Edit window and double click the "block 3 data1" element to enter the Block Edit window.
• In the Block Edit window, select Table from the Select element to add choice list and click the Add button. A new element "Table: new TABLE #" will be added.
• Double click the new layout element in the list to open the Table Edit window (Fig. 4.4.10). Configure the general table parameters for our training report as follows:
• Table name (not for display) = "table1" (used for the layout element listing in the Block Edit window).
• Border {GRID, NONE) = GRID.
• Left offset (points) = 5 (default), shifts left margin of table 5 points to the right of the enclosing block's left margin.
• Top offset (points) = 5 (default), shifts the table 5 points down relative to the top of the enclosing block or relative to the bottom of any layout element printed above the table.
• Internal font size (pts) = 10 (default); applies to all cells in the table except the column headers, which can have a different format (see below).
• Internal font style {NORMAL, BOLD, ITALIC"} = NORMAL; applies to all cells in the table except the column headers, which can have a different format (see below).

Image Added

Figure 4.4.10. Table edit window.

...

Figure 4.4.11. Column edit window.

Image Added

Next, define the rows for the report table whereby each row represents a set of parameter values (e.g., abundance, size, shape), for one set of data source columns (e.g., a mineral phase).

• Click the Work on Rows button to open the Table Row Edit window.
• Click the Add button to add new rows to the list, which initially have and temporary name.
• Add nine rows for our training report.
• Double-click one added row at a time to display the cell configuration options for each row in each column (Fig. 4.4.12). Configure as follows for our training report:
• Row Name (not printed): enter "row1" through "row9". This is only to tag the elements in the row list in the Table Row Edit window. You can do it quickly using copy-paste and double clicking a new row element as soon as you have entered the name.
• Double click the row again to configure each cell. For each cell, you can either enter a fixed text (typically used for row headers, such as the mineral name), or you can select a data source column, from which the value will printed if the row is triggered for printing (see column configuration above) (used for most cells). For our training report:
• For column 0 in each row, enter a text labels "Report row N text", where N is the row number {1,……,9}
• For columns 1, 2, 3 in row1, select data source columns:
• w1attr11, w1attr12, w1attr13
• For columns 1, 2, 3 in row2, select data source columns:
• w1attr21, w1attr22, w1attr23
• …..
• For columns 1, 2, 3 in row9, select data source columns:
• w1attr91, w1attr92, w1attr93
• Save regularly using Save to Database button given the tedious work involved in configuring tables.

Image Added

Figure 4.4.12. Row edit window.

...

• In the Report Edit window (Fig. 4.6.1.), double click (or create, if it doesn't exist already) the "block5 data3" item to enter the Block Edit window and configure for our training workbook:
• Block name (not printed) = "block5 data3".
• Data source worksheet = "worksheet1" (change from worksheet 3!)).
• Border = "BOX"
• You should already have a Text element in that block that says something like "WORKSHEET 3 DATA". If not, add one.
• Now, add a nested domain block element under "block5 data3" that will contain all domain-specific elements and information, i.e., Grid and Table elements that repeat for each domain. Double click the "Block: new BLOCK #" element and don't be confused by the Block Edit window looking exactly the same as before – orient yourself relative to hierarchy with the breadcrumbs!). Configure as follows:
• Block name (not printed) = "domain_block_5_1"
• Data source worksheet = "worksheet3".
• Border = "BOX"
• Within this domain block, create all the other layout elements that you want to repeat for each domain.
• First add a grid that looks the same as the one created for the simple report (see above), except that the data source references selected from the drop down lists will be "w3attr1" through "w3attr6" for the six cells of columns 2 and 4.
• Then create a table that looks the same as the one created for the simple report (see above), except that in the cell configuration, the references to attribute columns (report columns 1, 2, 3) are for worksheet3, i.e.:
• w3attr11, w3attr12, w3attr13
• w3attr21, w3attr22, w3attr23
• …..
• w3attr91, w3attr92, w3attr93

Image Added

Figure 4.6.1. Report edit window showing all five top-level blocks in training report.

Image Added

Figure 4.6.2. Block edit window for top-level block, associated with worksheet 1, containing a text element for the title and a nested domain block (associated with worksheet 3, not shown here) for elements and data that repeat for each domain

...

If no error messages appear and everything else looks normal, check if the necessary "Use Me" flag was set. For example, if you create a simple table an a block with nothing else, and none of the table columns are set with "Use Me", no columns will be used, the table header will not be printed (as specified), and the block will not be printed because nothing is in it, i.e., you get nothing.