Adding/Editing Reports

Use to search for existing PMWeb Reports.

This field is automatically populated by PMWeb with the next available number.

Enter the name of the PMWeb report.

Enter the Type of report.  The options for this field are set up by your Administrator within Portfolio>Lists>Lists.

Enter the Revision Number of this report.

Enter the Status of this report.  Note:  Workflow is not currently available in PMWeb Reports.

This field will automatically be populated based on the PMWeb module that you selected when you created the report.

Grid Themes change the colors of the rows, headers and footers when the report is run. 

Select the Distinct checkbox to remove all duplicate rows from your report results.

This area displays information regarding the report(s) selected including the when and who last ran the report, records returned, selected and not selected.

The Field List contains all of the fields that can be displayed in the PMWeb Report based on the Record Type selected.  (See #7 above)  To add fields to the report, drag the field from the Field List on the left to the "Select" area on the right.

Use the Add Calculated Field button if you want to create a calculated field rather than use a field directly from the Field List.

This field will be automatically populated by PMWeb with the next consecutive number.

This field will be automatically populated with the name of the table that the field is a part of.

This field will be automatically populated with the name of the field that you chose from the Field List (as it is named in the SQL table).

Enter the description that you would like to display in the column header when the report is run.  If you don't enter anything, PMWeb will automatically populate this field with the common name of the field.

The symbol in the field indicates that the field is a calculated field.  Press on the symbol to view or modify the calculation.

This field will default to "None".  If you would like to see a subtotal of this field in the grouping footer when the report is run, select the type of sum you would like to use  (ie. Sum, Min, Max, Last, First, Count, Avg., etc.).

Enter the width, in Pixels, of the column when the report is run.

Check the Show box if the field should appear in the report when it's run.

Check the Header/Footer box if you would like the field to be available to pull into the header and/or footer.

This field will be automatically populated by PMWeb with the next consecutive number.

Enter a single Left Bracket to separate sections of your filter statement,  or multiple Left Brackets if your filter statements need to be nested.

Select AND if the following statement must also be true.  Select OR if either/any statement can be true.

Enter a single Right Bracket to close a single section of your filter statement,  or multiple Right Brackets to close nested filter statements.

This field will be automatically populated with the name of the field that you chose from the Field List (as it is named in the SQL table).

Select the operator (equal to, contains etc.)that will compare the Field Name to the Value

Enter the Value that you would like to compare to the Field Name.

 

 

Note:  In the Statement DocStatusName Equal Approved, DocStatusName is the Field Name, Equal is the Operator and Approved is the Value

Use the button to Export the current report and any other custom PMWeb Reports to SQL for use in BI Reporting, Queries, etc.