4. Marco de referencia
4.3 Marco legal
Try producing isometrics of the cable trays you have designed. Ensure you have checked them with then the Data Consistency Checker and amended any significant errors before running Isodraft.
www.aveva.com
10 Generating Reports
The AVEVA Marine database stores a large amount of 3D engineering information about user marine design. User can extract this data both graphically, in the form of drawings, or in text form, by producing reports. This session describes the principles and practice of producing reports.
Users can produce a report by running a report template (Reports) or one based on their own selection criteria (Quick Reports) from within the Outfitting module.
10.1 Reports
The template specifies what the report will contain, whether it will be sent to the screen or a file, and how it will be laid out.
There is a directory of example reports supplied with the product. This can be found in the directory
$PDMSUI/REPORTS. Under this directory there is a TEMPLATES directory. This contains sample
templates which can be used to generate standard reports. The templates are AVEVA Marine macros. The best way to see how they are defined is to select Utilities > Standard Reporting > Reports > Modify from the main menu, and look at the settings for the fields on the forms displayed.
Templates have the file extension .tmp, and the corresponding reports have a file extension .rep.
Most of the examples are based on the sample project supplied with the product.
The sample templates produce the following types of report:
catalogue_param This report lists Branch members, with their CATREFs and the parameters of the CATREFs.
catalogue_ptgmref This report lists Branch members, with their CATREFs followed by the PTREFs and GMREFs of the CATREFs.
centre_line The centre-line length of each Branch is listed. There is also an Imperial version of this report template.
line_list This report will list Branches, sorted by the name of the Pipe which owns them. The Pipe Specification, the Head and Tail bores and the Head and Tail references are given.
nozz_sched This is a Nozzle schedule, which lists all Nozzles sorted by name, and shows the P1 bore, connection type and direction, and the position of each Nozzle.
pipe_mto This report shows material information for all Branch members, sorted by type, Detail Text and Material Text. The Tube length and quantity of each component are totalled. There is an Imperial version of this report template.
steel_mto This is a material take-off list for structural components.
tube_mto This report totals all Tubing. The Specification Reference, P1 Bore, Detail Text and Material Text are shown.
tube_gradient This report gives the gradient of each tubing component.
tube_area_vol This report uses derived properties to report on the area and volume of tubing.
valve_list This report is an example of selective reporting.
10.2 Running a Report from a Saved Template
The user may already be familiar with creating a report by running a saved report template. If not, try this introductory exercise. Select the following Utilities > Standard Reporting> Reports > Run
The user will see a Windows File Browser, navigate to the location of the report templates, select the report template and click the Open button.
The Report Details form will be displayed. On this form the user will need to complete all required fields.
The information requested by this form is dependent on the settings of the Runtime Prompts form, defined during the template creation.
The Report Details form will be displayed. On this form the user will need to complete all required fields.
The information requested by this form is dependent on the settings of the Runtime Prompts form, defined during the template creation.
The information required by this form is totally dependent on what has been defined within the Template.
Below are shown other questions that may be asked by the report template for certain Runtime Prompts.
Filename If user specifies a filename, the report will be sent to the given file in the current directory. If user leaves this field empty, the report will be sent to the screen.
Hierarchy Here user should specify the elements where report should start its searches. The report will be produced for all these elements and elements owned by them.
Type(s) Here user should state all element Types that are to be reported on. The report will be produced for all the elements given.
www.aveva.com
With Defines the criteria that must match the elements before they will be reported on. This is sometimes referred to as a filter but works in the same way as the other occurrences in AVEVA Marine.
Volume Allows the setting of Limits. The report may be generated on elements that are Completely Within or Partially Within the limits.
From Allows the user to specify where the search will take place. The Default is MDB
10.3 Quick Reports
The Create Quick Report form is displayed when user select
Utilities
> Standard Reporting> Quick Reports
from the main bar menu. This form allows user to create reports with only basic formatting and this template cannot be saved.User can enter a filename for the output report. If user just wants to see the report on the screen, leave the File text box blank, or press the
Term
button, in which case any filename given will be ignored. IfTerm
is selected, a window will be displayed to show the results or the report, unless there is already a form currently displayed to which the results may be written to.The options performed by the buttons on the Quick Reports form are:
Types
AVEVA Marine element types can be specified. i.e. BRAN MEM BEND ELBOW TEEWith
This option is a way of narrowing down the report. Enter a AVEVA Marine expression, i.e.HBORE LE 75
Columns
These are the AVEVA Marine attributes to output of the report. The attributes specified will be used as headings to the column. User can enter expressions, enclosed in roundbrackets. The following example outputs the type, name, and the first three characters of the owner's name.i.e.TYPE NAME (SUBSTR (NAME OF OWNER, 1, 3)) or NAME OWNER HPOS TPOS
Hierarchy
Enter the element or elements at the top of the hierarchy that user wants to report on.Because user can give a list of elements which are entered with a slash character before each name, except for WORLD. i.e. /CTRAY_YY010
10.3.1 Run the Report
Press the Run the Report button when ready to generate the report.
Exercise 10 (Reports)
1. Run the report cabletray_sched.tmp to show the type of output created. This Report Template will be supplied by the trainer, nd can be saved locally.
2. Create a report to list all the cable trays with spec /SCTG. Create columns to display Name, Pspec, Hbore, and Tbore
3. Create a line list report and experiment with the sorting facility and notice the way it changes the output.