Query Tab (Report Template Editor Dialog Box) - Intergraph Smart 3D - Help

Intergraph Smart 3D Reports

PPMProduct
Intergraph Smart 3D
PPMCategory_custom
Help
Version_SThreeD_Custom
11 (2016)
SPFVersion_custom
7.1 (2018 R1)

Specifies the syntax to retrieve data for the reports. This tab allows you to execute the query and view the results.

You can create multiple query tabs for one report template by clicking Tools > Add Query. For more information on adding queries, see Add a filter-based query to a report template.

The first graphic shows the base query for the report, while the second shows the filter-based query used to further define the report.

Show Results Pane

Displays a pane at the bottom of the tab. When you execute the query, the results display here.

Execute Query

Runs the query specified on the tab.

Edit Query Parameters

Displays the Query Parameters Designer for modifying the query prompts that are presented to you when you run the report. For example, a prompt can ask you for the system parent name. This button is only available if the query is not filter-based.

Name

Displays the name for the query. This field is read-only.

Description

Describes the query. When you change the query description in the Report Template Editor, the description is updated in the report .rqe file.

Filter

Displays the name of the filter on which this query is based. This field is only available if the query is filter- based.

Properties

Displays the Filter Properties dialog box to change the properties of the filter if necessary. This button is only available if the query is filter-based.

Allow runtime filter selection

When checked, requires a filter selection be made when you run the report using Tools > Run Report in a 3D task. If this box is not checked, the report runs using the filter defined within the report.

Add

Displays the Select Properties dialog box to add a new property to a filter-based query. This button is only available if the query is filter-based.

Remove

Removes a property that was added to a filter-based query. This button is only available if the query is filter-based.

If the report is saved to the catalog and the filter is not a catalog filter, an error message displays: Cannot copy report to the catalog. Filter is not a catalog filter. You should edit the report template to correct the problem.

Queries in Design Layout

The Query tabs in the Report Template Editor populate the attributes you see when you open the report template in Microsoft Excel. To open the report template in Excel, click Design Layout on the Formatting tab of the Report Template Editor. In the Design Layout window in Excel, the query attributes are shown in the Report Items hierarchy. You click and drag to place the query attributes in the report layout window. The graphic below shows how you can populate the layout of a report template. For more information, see Design Layout.

See Also

Create a new report template from an existing template
Report Templates
Edit a Report Template
Report Template Editor