Reports Module
Reports How To Documents
-
How To: Reporting Module
OVERVIEW On the module panel, click on the Reports module on the left side. Select the type of report you want (e.g., Project, Opportunity, Company, etc) to create. Select the All Reports tab to view all available reports for that report type. Report Fields Definitions Icons Select the Customize icon to customize the report Reports with an Excel icon, can be exported into a .csv or native Excel file by selecting the icon Reports with a Public icon status are available to view across the organization Reports with a Private icon status are only available to you The Delete icon can be used to delete a report you no longer want to see (the delete function is not available for most users) Report Link To run a report, click on the report title (will be hyperlinked) when you hover over it. Generating the report may take a little while depending on the search parameters and the amount of results displayed (e.g., 100 results will be much faster than 1000 results). The Time column provides an approximate run time to generate the report and it is also contingent on internet speed. Avoid refreshing the page when the report is loading. Feel free to work in a different tab if your report is taking longer to run. My Last Viewed Reports Are a mix of both public and private reports that you recently viewed or customized. My Private Reports Are reports that you save as private and unavailable to the public eye. Use this when testing reports or if you want to save custom template reports for personal use. Note, only your Unanet CRM Administrators can view these reports. My Reports Reports that you have added to your reports home. These reports will appear as a widget on your dashboard if saved as "My Report". All Reports All template reports and any public custom reports are aggregated and listed under this section. CUSTOMIZE AN EXISTING REPORT TEMPLATE (RECOMMENDED) Before attempting to customize your own report, always search for an existing report template to see if it contains the desired or similar data you need. Click on the Customize icon next to the report and a field selection screen will appear to customize your report. Select the fields you want in your report. Please review the attached guide to understand what fields are commonly used and which fields can be used in Boolean & Advanced Filters. IMPORTANT NOTES AND RECOMMENDATIONS Never use your back button – the report doesn’t retain anything until the report generates. After the report runs, you can still customize it. Since there are many fields options, use Ctrl + F to search the page for the field you're looking for. Running Unanet on two monitors is recommended when customizing a report – one showing a project record, and one showing the reports field selection list so that you can see which data fields exist Export to Excel Cartesian – when you have multiple lines of data in a category, each line will repeat the rest of the project data (e.g., if you have multiple consultant firms showing, each firm will appear in a separate line). If not Cartesian = 1 cell will contain all data (e.g., consultant firms) When you want to save a report, it must be a new name. You can edit an existing report and modify the name. Keep in mind the available report fields vary depending on the report type. For example, Company Reports and Project reports will have completely different field selections. REPORT FIELD RECOMMENDATIONS (SEE ATTACHED GUIDE) Selection fields are populated from CMiC and Unanet. The following fields are recommended and frequently used for most reports and report types. You are welcome to select as many additional fields as you want depending on requirements. For Construction Dates, select Construction Schedule - Calculated Start and Completion Date. For Firm Orgs, select both Firm Org Division/Office and Firm Org Department. Select Client - Company (the Owner field is often empty) For Primary Market Type, select: Firm Org Primary Market (e.g., Aviation, Residential, Education, Hospitality, etc.) For Secondary Market Type, select Secondary Market (e.g., Aviation-Airside, Residential-For Rent, Education-K-12, Hospitality-Accommodations, etc.) For specific market category, select: Product Type (e.g., baggage handling, apartments, high school, hotel, etc.) For Project Cost, select: Project Cost - Final Contract ACTUAL. If you are using an Opportunity or Project report, select the Name and Number fields. For Project reports, select Publishable Project, Publishable Reason, and Published Project Name so you can identify whether a project can be marketed/used externally. BOOLEAN SEARCH After you've selected all the fields for your report, scroll down after the available fields selection. You can customize your report further by using date limit (if available) and/or Boolean search. Optional: Conduct a Boolean search by selecting the field you want to search on and the parameters, then click ‘Save & Continue’. Caution: Boolean search constrains your data to pull only results listed in your parameter so keep in mind results will be very limited ADVANCED FILTER PANEL The following panel is the Advanced Filter for how you want the report to look. It allows you filter down your field selections further as well as order and group data. If you want your report to only display your Division’s projects, go into the ‘Filter By: Firm Org Division/Office’ and select your Division and check the ‘include in main query constraint’ box: Order of Fields Display – you can rearrange the order of your fields so the report displays in the order you arranged. Click on the field and click on the up and down arrows until the field is in its desired location. Select Sort Order – click on the drop down arrows to sort specific fields in an ascending or descending fashion. Group By Fields – you can group your report with up to two groupings (primary and secondary). However, grouping selections will NOT remain when you export the report to an Excel file. One you are ready to move forward, click Save and Continue, the report will take a few seconds to a few minutes to generate. When the report has loaded, scroll on the page horizontally and the total number of records will display on the upper right hand corner. If you want to save this report template, select Save Report in the top right of the screen. In the future, if you want to export that report to Excel or modify the template, you can go back to the Reports Home screen and select the Excel Icon or the Clipboard icon next to the report template. To modify the title of an existing template, open the report and click Edit on the top right of the screen.
-
How To: Create a Custom Report
STEPS TO CREATE A CUSTOM REPORT Note: It's always easier to find an existing template report that is close to what you want, then customize the fields and parameters, rather than creating an entire new report. Step 1: In Report Home, click on the type of report you wish to create. For example, to create a Project report, navigate to the Project tab then click on 'Create Custom Report' in the upper right hand corner. Step 2: An Available Fields selection menu will appear. Choose your categories (a few recommended standard fields are shown below) and customize your report. Please review the attached guide to learn more about what report fields are commonly used and whether Boolean or Advanced Filters can be used. Use Ctrl + F to search for the page and find the field you are looking for Step 3: If you need to search for data within a certain date, you can use the Limit by Date feature. In the example below, the report will be limited to projects that have been completed within the past 5 years. Step 4: Use the Boolean Search to further narrow down the results if you are looking for a more specific set of data. In the example below, the report will be limited to projects with the Client - Company name containing anything with the word "Apple". Review the attached guide to learn more about the fields that can be used in Boolean vs. Advanced Filters. Step 5: After the selections are made, click 'Save & Continue' at the bottom of the screen Step 6: The next page allows you to filter fields and sort the order of fields displayed on your report. This would the area to constrain your report if you were searching for data within a specific Division/Office, Market. etc. Please use 'include in main query constraint' with caution as selecting this check box will only give you results if and only if the project record includes those specific designations included. Click 'Save and Continue' when you are done with selections and ready to generate the report. Step 7: Depending on the amount of data, the report may take a few seconds to a few minutes to generate. Do not refresh the screen as the system is working to pull the information you need. When the report populates, you can export to excel, save the custom report (see below for Naming Conventions), or re-customize the report if you made a mistake or need to pull different results. SAMPLE REPORT GENERATED: Apple Projects in the Bay Area Building & Special Projects Division completed in the past 5 years. NAMING CONVENTIONS If the report is associated with a Division: Firm Org Division/Office_Firm Org - Primary Market If the report is associated with a Market Sector: Firm Org_Primary Market + any other descriptors If the report is associated with all of a Sector or Division: Healthcare_ALL
-
How To: Knowledge
The Knowledge Module is the place where we store our boilerplate narratives, firm documentation and statistics, safety information, community involvement, financials; and National SOQs. The home page of the Knowledge Module show the "knowledge tree" that displays links to available knowledge categories. Each category shows the number of Knowledge records entered within that category. Information and images stored in the Knowledge Module can be used to generate documents in the Publisher Module. Add Images, Documents, Projects Step 1: Click Knowledge Step 2: Click the Category or Unassigned Knowledge Step 3: Click on the Title Step 4: Click Add on the section necessary Step 5: Click Save Search Knowledge Use the Quick Search on the top of the Unanet CRM page and select Knowledge from the drop down on the right or try advanced search from within the Knowledge Module.