Point Detail Report
COMMAND LICENSING AND DEFAULT MENU LOCATIONS
- The Point Detail Report command is part of the RPS Modeling Toolbox.
- The command is located on the Modeling toolbox menu ribbon.
- The command is located in the Reports menu group.
COMMAND DESCRIPTION
Creates CSV output reports that open directly in Microsoft Excel (or the program selected to open CSV files) that report a selection of points and optionally compare them to a surface and / or an alignment or feature line. The command can also report the points based on boundary lines.
The report provides the ability to organize the columns of data and select which data items to report in each column from a large list of options. Report local and global coordinates, Point IDs, Codes, Descriptions, survey and CAD attributes, Stations, Offsets, Deltas, Slopes, and more.
The report templates are stored centrally and can be used across all your projects and survive upgrade installations of Trimble Business Center.
COMMAND HISTORY
Update Information
VIDEO DEMONSTRATION
The following video shows how to utilize the Point Detail Report command:
SETUP AND CONFIGURATION
Command Interface Description
The Point Detail Report command dialog looks as follows:
Select points:
Select the points that you wish to report. Use the Options button for normal selection options (Advanced Select, Select by Layer, etc.).
Report definition:
In this section, you can select, create, and define as many custom report layouts as you require for your projects. Each saved report definition is stored in RPS Settings - a centralized location that is available to all of your projects and is not disrupted by TBC installation updates.
Select the Report Definition that you wish to use from the pull-down list of definitions.
Click the [Manage] button to create new or edit existing Report Definitions. The editor can also be accessed through the RPS Settings command in the Point Detail Report Settings area.
RPS Settings - Point Detail Report Settings:
Select a Report Definition to edit or review from the pull-down list of Report Definitions.
Use the following buttons to create, edit, or delete Report Definitions.
Create a new report template.
Edit the name of the selected report template.
Delete the selected report template.
Report Definition templates are saved automatically when you create a new template, change operations in the RPS Settings command, or exit the Report Definition function to return to the command.
To edit the fields of the currently chosen Report Definition, click the Edit Report Fields button.
Edit Report Fields:
The Report Fields Editor looks as follows:
Available Fields List:
The Available Fields List provides access to all of the fields that can be used to create data columns in the CSV file report.
To add a field to the report, select the field in the list and either double-click it to add it or use the 
button to move it to the Selected Fields List on the left side of the dialog. The field will be added below the highlighted item in the Selected Fields List.
To remove a field from the Selected Fields List, double-click the item or select the item and click the 
button to move it back into the Available Fields List.
To move a selected field up or down in the Selected Fields List, use either the 
or 
down buttons.
If you want to change the text used in the header of the CSV reports for each column, simply double-click the appropriate item in the Column Header List and edit the name to what you require for the report. The name changes are stored in RPS Settings and will be applied to all report templates that use that same data value.
Click OK to save the changes made and return to the command.
Click Cancel to exit the editor without saving the changes made.
Report fields:
This area displays the list of values that have been chosen in the currently selected template to report to the CSV file output. The order of the list is the order in which they will be written to the CSV file.
If you are satisfied with the template, you can select any of the optional reference fields (Reference Surface, Reference Line, Reference Boundaries) and then click Apply to run the report.
Reference Options:
The selected points can be reported as points only or as points in reference to a Reference Surface (e.g., to report Cut / Fill values), a Reference Line (e.g., to report Station and Offset values), or Reference Boundaries to list points with a reference to the boundary or boundaries in which they reside.
The Reference Surface, Reference Line, or Reference Boundaries options of the command will be grayed out unless the Report Definition includes report items that relate to a Reference Surface (e.g., Point Cut / Fill, Surface Slope, Surface Slope Direction, Surface Elevation, etc.), a Reference Line (e.g., Station, Offset, Slope (Line to Point or Point to Line), Delta Z (Line to Point or Point to Line), Line Elevation, etc.), or a Boundary (Boundary Name).
EXECUTE
Reference surface (optional):
Select the surface that you wish to use as the height reference for Cut / Fill or Surface Slope and Direction values. This is an optional selection.
Reference line (optional):
Select the alignment or feature / CAD line that you wish to use for Station and Offset reference. The alignment or reference line can be 2D or 3D. Note that if it is 2D, slopes and Delta Elevations between the line and selected points will be reported as undefined. This is an optional selection.
Show line direction toggle button:
Check this button next to the Reference Line selector if you wish to show the line direction indicators on the selected Reference Line.
Reference Boundaries (optional):
This field will be disabled unless the selected Report Definition includes the Boundary field option. When the Boundary field option is in the Report Definition, this field is enabled and allows you to select one or more boundary lines.
Select the boundaries that you want to report in the output file. Each point listed will have the boundary in which it resides listed in the report. Note that if a single point resides inside more than one boundary, the report will list all of the boundaries with which it is associated.
The boundaries can be any closed-area line (first and last point are in the same place, AutoClose Flag = Yes, Boundary Object, Polylines, Linestrings, 2D or 3D).
File name:
Enter the file name for the CSV file that will be created. The file can be saved to the Project Folder or anywhere on your computer or network, as you prefer. Right-click on this selection field to choose the Project Folder or browse for a location. Clicking the […] button will browse for the location and go to the last location used by the RPS browse function.
INPUTS
Select Points:
Select the points that you wish to include in the report. Use the Options button to access additional selection methods such as Advanced Select or Select by Layer.
Report Definition:
Select the saved report template that defines which data fields will be included in the CSV report and the order in which they will appear.
Reference Surface:
Optionally select a surface to report values such as Surface Elevation, Cut/Fill, Surface Slope, and Surface Slope Direction.
Reference Line:
Optionally select an Alignment, Feature Line, CAD Line, or other supported line to report values such as Station, Offset, Slope, Delta Elevation, or Line Elevation.
Reference Boundaries:
Optionally select one or more closed boundary lines to identify which boundary or boundaries contain each reported point.
File Name:
Enter the name and storage location for the .csv report file that will be created.
REPORTS
The Point Detail Report command creates a customizable .csv report containing information for the selected points.
The report content is controlled by the selected Report Definition and can include point coordinates, Point IDs, codes, descriptions, attributes, Station and Offset values, Cut/Fill values, slopes, elevation differences, boundary names, and other available point information.
The completed CSV file can be opened directly in Microsoft Excel or the application associated with CSV files.
RPS SETTINGS
Point Detail Report templates are stored in RPS Settings so they can be reused across different TBC projects.
Use the Point Detail Report Settings area in RPS Settings to create, rename, delete, or modify report definitions and to control the fields and column headers used in the CSV reports.
Changes to report definitions are stored centrally and remain available across projects and TBC installation updates.
HOT KEYS
U = Unlock
Q = Rotate Screen 15 degrees clockwise
E = Rotate Screen 15 Degrees anti clockwise
SHIFT Q = Rotate Screen 30 Degrees clockwise
SHIFT E = Rotate Screen 30 Degrees Anti Clockwise
WASD = Pan Up, Pan Left, Pan Down, Pan Right
SHIFT M = Pop Up Menu
Shift X = Undo Last Click or Pop Up Elevation Entry
X = Start Over
Z = Decrement
C = Increment
Shift Z = Reverse Direction to Downwards / Decrease (and decrease 2x)
Shift C = Reverse Direction to Upwards / Increase (and Increase by 2x)
HEADER BAR COMMANDS
In the Header Bar of the command, you will find command icons that link you to other commands that you may need access to while using this command. In this command, the following commands are linked:
- Help - this document access
- RPS Settings
- Takeoff Lines
- Smart Edit
- Adjust Linestring Elevation
- Convert to Linestring
- Create Alignment
- Create Horizontal Alignment Labels
- Linestring by Station
- Profile Viewer
COMMAND BUTTONS
Apply
Click Apply to run the report.
OK
Executes the command, generates the report, and closes on completion.
Cancel
Closes the command without further execution.
HELP
In the Help area, you will find a shortcut link to this Help document and training video. You can also access this document by pressing F1 on your keyboard.
USE CASE VIDEOS
The following videos show the use of the Point Detail Report command in a workflow context:
FEEDBACK AND ENHANCEMENT REQUESTS
If you would like to provide feedback on the use of the Point Detail Report command or to request enhancements or improvements to the command, please click Reply below.