	Product(s):	gINT Logs, gINT Professional, gINT Professional Plus
	Version(s):	N\A
	Environment:	N\A
	Area:	Report-Log
	Subarea:	N\A

Advanced Log Report Design Tutorial

communities.bentley.com/.../271314

This tutorial is designed for intermediate-to-advanced level gINT users, and is intended for self-study. You should be familiar with log report design before working through this tutorial.

The following topics are covered:

Smart Reports

A smart report form automatically adjusts its format based on the data, utilizing decision logic in properties in the report design and its entities. It will hide a column when there is no data for that column. Some examples:

Having a surface elevation label and data appear in the report header for boreholes that have elevation data, and not for those without it.
On a log, if a sample has refusal, displaying the refusal penetration in inches after the final blow count, separated from it by a slash, as in ‘25-55/3"’. If no refusal, displaying the blow counts and N-value.
Highlighting data that is outside tolerances with bold or colored font.
On a log, Including or omitting specific columns depending on whether data for them is present, and enlarging the other columns to take up any vacant space.
Setting the depth displayed per page based on a value in the borehole record, if present, and using defaults if not.

Variable Depth Scales

The depth scale of a log report is the way you specify how many page units (vertical inches or mm measured on the printed page) are used to represent some number of depth units (vertical feet or meters of borehole depth in the field) on output. There are certain default behaviors of the software that generate an appropriate depth scale in response to you entering a fixed depth scale value in REPORT DESIGN or OUTPUT (or leaving this blank). However, users often want more control of the depth scale, such as varying it between projects and/or boreholes, calculating it based on the total depth of the borehole, and so on.

Photos on Reports

In this exercise we take the SIMPLE REPORT log form and convert it to a test pit log that displays photos on the pages following each log. We will set this up so that if there are no photos, no additional pages will print, but if photos are referenced by the borehole, they will be printed two to a page. We will take the following approach:

Create a new table to reference multiple photos for each borehole, with a Bitmap File field in the photos table
Add two bitmap symbol entities to the side of the report to display the up to two photos per page
Move the column entities to a block, and set a condition to suppress the printing of this block after page 1
Set an output override X value for the photos so they move over to the left to replace the column entities on page 2 and beyond.

Variable Graphic Legends

A variable legend entity creates a legend displaying the material, sampler, well or other symbols in use in a single log, all boreholes on a fence report, or throughout a project (displayed in a graphic text doc). This is a useful visual aid on a report. The legend is called variable because the set of symbol boxes that appears will vary from log to log or fence to fence, depending on which symbols are in use.

We will create variable legends on a log and a fence, and create a graphic text document showing all material and sampler symbols for the project.

Note: in order to create a fence or graphic text document you will need a license for gINT Professional or Professional Plus.