Background information
Sheets Click this button in the Report Objects button bar to insert a sheet into a report. If there are any sheets open during insertion, you will be informed via picklist about the open sheets. Select the sheet which you would like to insert from the list. If there are no open sheets, insert a placeholder for the sheets.
The sheet object you insert when working in a report template, in order to reserve space for a sheet, is always empty.
Properties of sheet objects
•
Selecting sheet cells: your image analysis program will insert precisely those sheet cells (of the measurement sheet) that are visible within the sheet window. This means you can alter the size of the window to clip lines and/or columns. Empty sheet cells are ignored at insertion. You can make use of the autofilter functions located in the Edit menu in order to have specific kinds of data not shown. Any filter you have set will be considered upon insertion into the report. When moving a sheet from a database to a sheet object, only the sheet cells are inserted which were displayed during the insertion of the sheet! If you ex- plicitly want to determine exactly the sheet cells which are to be inserted into a sheet, define a sheet object within the record object.
•
Formatting sheets: a template cannot be defined for a sheet. Each sheet you insert has to be formatted individually.•
Sheet object structure: your image analysis program converts measurement sheets (before insertion into a report) into a complex object made up of numer- ous separate text objects. Every single sheet cell is, in fact, a separate text ob- ject. You can completely disassemble a sheet into its component parts in a re- port for editing purposes.•
Editing sheets: to be able to edit each sheet cell separately you have to break up the grouping (‘ungroup’). Regroup each sheet after you have finished editing. You can work with the sheet more easily when it is grouped. A sheet that has been grouped together can be, e. g., positioned as a single object.Sheets in record ob- jects
Use sheets in record objects, if you want to insert additional information from an im- age database together with a sheet. A sheet which has been defined in a record ob- ject, has an additional tab located in the sheet properties. The Document Link tab en- ables you to exactly define the sheet cells which are to be inserted into the report.
Report Generator Inserting sheets - Step-by-step
193
Unlike the sheet objects which are directly inserted into the report, the acquired sheet cells are independent of the window size of the sheet.
Use this possibility if your measurement results are always written to a sheet in the same form, in order to determine the sheet cells which are relevant for you.
Sheet cells as field objects
Many special Add-Ins deliver standardized measurement sheets which are always constructed the same way. Use a special field function to acquire individual measure- ment results, i.e., the G-value of a grain size analysis, into the record object. The
[Sheet Cell] field is automatically included in the list of database fields. This field has additional object properties. You can exactly specify the desired sheet cell in the
Record Fields tab. A sheet is a group of in-
dividual text objects. Therefore, you can change the appearance of a sheet from sheet cell to sheet cell.
Step-by-step
Insert and edit open sheets directly into a report
1) Load the sheet you want to insert into a report. For example, use the Measure > Histogram... command to create a sheet .
2) Now maximize the sheet window (to do so, click the middle button in the upper- right corner of the sheet - in the document header). This will enable you to have the greatest number of sheet cells inserted into the report.
3) Activate the report window. Select, e. g., the report name located at the bottom of the Window menu in the list of files.
4) Select the image object and click the Sheet button located in the Report Objects
button bar and pull open the sheet object.
"
Should you have loaded numerous sheets, the Available Sheets dialog box opens. Select the desired sheet and confirm via OK."
Your image analysis program will insert all lines and columns of the mea- surement sheet into the report that are visible within the sheet window. Cells that are without content will be left out.5) Click the Ungroup button in the Order and Group button bar to be able to edit the sheet within the report.
"
What to do if the button bar is not available:Use the Special > Edit Button Bars... command. To have a button bar dis- played select the check box next to the name of that button bar.
"
A sheet that is inserted into a report is comprised of a group of text objects. The grouping that had kept the individual cells together will now be taken apart. You will thus now see the marking symbols around each separate text object."
You can now, e. g., rename the sheet or the columns, add a comment on individual measurement values, or have certain cells of the sheet highlight- ed in color.6) As needed, you can edit the sheet. Doubleclick, e. g., on the sheet header to rename the sheet.
Report Generator Report objects - Step-by-step
194
7) Once editing is completed, you select all the sheet elements by drawing a frame around the whole sheet - keeping the left mouse button depressed.
8) Click the Group button in the Order and Group button bar to have the separate sheet cells reassembled into a single object.
9) Position the sheet keeping the left mouse button depressed and, if necessary, adjust sheet size. Adjust sheet size by moving one of the sheet edges with the mouse, keeping the left mouse button depressed.
10) You now change the size of the sheet. To do this, you keep the [Ctrl] key de- pressed so that the sheet remains in the same position.
"
When adjusting the size of a sheet the font and font size remain un- changed. The separate values will thus be pushed closer together, and in extreme cases overlapping.11) Click the Properties button in the Report Objects button bar to have the sheet formatted. At the same time, you alter the properties for all sheet cells.
Report Generator Inserting sheets - Step-by-step
195
You can automatically fill an entire report with database information.
Inserting sheets into an empty sheet object
1) Close all loaded sheets. Simply use the Window > Close All command to do so.
2) Generate a new report based on the "Normal" template.
3) Select the image object and click the Sheet button located in the Report Objects
button bar and pull open the sheet object.
4) Load the sheet you want to insert into a report.
5) Select the sheet object on the report page and click the right mouse button.
6) Select the Select Sheet... command from the context menu to open a list of all the sheets loaded and to insert the desired sheet.
Report Generator Report objects - Step-by-step
196
Using sheets in a record object
1) Open an image database and insert a sheet.
2) Generate a new report based on the "Normal" template.
3) Use the Record button in the Report Objects button bar to insert an existing record object.
4) Click the Edit Object Template in the report window button bar to switch over to the edit-object mode.
5) Select the image object and click the Sheet button located in the Report Objects
button bar and pull open the sheet object.
6) Click the Properties button in the Report Objects button bar.
7) In the Document Link tab enter the Filename “ *.* " into the field in order to insert the first attached sheet together with the record.
Determine the number of rows and columns which are to be inserted into the report. The heading of a measurement sheet usually has the sheet cell number 0.
Please note: If you use 0 as the amount of rows or columns, your image analysis program inserts exactly that part of the sheet which was active during the inser- tion of the sheets into the database.
8) Click OK to close the dialog box.
9) Click the Finish Object Editing button in the report window button bar to exit the edit-object mode.
10) Now insert the sheet from the database into the adapted record object. To do so, you can either move the sheet or also the record under which the sheet has been inserted, onto the record object.
"
The sheet and the desired field entries as well, will be included in the re- port.Using sheet cells in a record object
1) Use the Record button in the Report Objects button bar to insert an existing record object.
2) Click the Edit Object Template in the report window button bar to switch over to the edit-object mode.
3) Click the Field button in the Report Objects button bar to add a new field object to the record.
4) In the Select Field dialog box, select the [Sheet Cell] entry and confirm with OK.
5) Click the Properties button in the Report Objects button bar.
6) In the Record Fields tab, enter a description of the measurement value into the
Fieldname field, i.e., G-Value.
7) In the Sheet group enter the Filename “ *.* " into the field in order to insert the first attached sheet together with the record.
8) Determine the desired sheet cell in the Sheet and Column field. Should the in- serted sheet not contain the specified sheet cell, the field remains empty.
9) Click OK to close the dialog box.
10) Click the Finish Object Editing button bar located in the report window.
Report Generator