![]() ![]() ![]() |
FacilitiesDesk enables you to create reports that meet your needs. To create your custom reports,
Login to FacilitiesDesk application with your user name and password.
Click Reports tab in the header pane. This opens All Reports page.
Click New Custom Report button. This opens Custom Reports page that will help you navigate through the various steps involved in the creation of a custom report.
Specify the relevant Report Title in the given text field. This is a mandatory field.
Choose the Report Type by selecting the radio buttons. You can create Tabular Reports and Matrix Reports
Choose the module (Work Request, Contracts, Purchase) for which you
Click Proceed to Report Wizard button. This opens the Display Columns page. This page differs for each report type. Each report type has to go through various steps before generating it as a customized report.
To generate Tabular Reports
Tabular reports are simple reports that allow you to list your data based on certain criteria. If you had selected the Tabular Reports option then you have five steps to create a complete customized tabular report. If you wish to skip a particular option then click the next button and move to the next step.
Display Columns
The first step to create tabular reports is to select the display columns which need to be displayed in the tabular report. Select the columns from the Available Columns list box and click >> button to move them to Display Columns list box. Click the << button if you want to remove any column from the Display Columns list box.
Click Next button. This leads you to the grouping of columns, where you can choose two levels of grouping.
Filter Options
If you are using the date/time filter criteria, select the date column name from the Select Column combo box.
Select the period for which you want to generate the report. If you would like to generate report during this week, last week, this month, last month, this quarter, last quarter or today, yesterday then select the During radio button and select the time period from the combo box. (OR) If you wish to provide a custom period, then select the From and To date using the calender button.
To use Advanced Filtering, you first need to select the radio button for matching all the selected criteria or any one of them. Then from the column listing, select the various columns from the list and set the match operator and mention the values for matching the column as (is, is not, contains and so on) from the combo box.
Click the Choose button and select the value for the column to add as a filter condition.
Click as Add to Filter button to add the filter condition to the filter set which gets listed under the Filter Set title.
Click Next button to go to the grouping of data.
Grouping Data
From the Select Column list box, select the column based on which you wish to group the data.
Click the Next button to go to the next stage.
Column Summary
You can get the column summary for all the columns in the report. If you wish to have the column summary displayed in the report, select the column summary options available for each column. The summary options differs for each column you have selected.
Click the Next button to go the next option.
Charts
In addition to the tabular chart, if you wish to have a chart displayed for a particular column then, or you can skip this option and directly run the report.
Select the chart type to be displayed from the combo box.
Select the Axis column from the combo box to be displayed in the chart . This is a mandatory field. The data will be grouped in the chart based on the column selected.
Select the Display Format from the combo box. For ex: in numbers or in percentage.
Click Run Report button.
On running the report you get a tabular report as well as the graphical view for the selected column data.
To generate Matrix Reports
Matrix reports provides the data in a grid manner (m x n format). It allows you to study different scenarios based on the chosen criteria. If you have selected matrix reports you have two steps to generate a complete matrix report. Click the Proceed to Report Wizard button to go to next page.
Grouping Data
You have simple grouping and advanced grouping option for matrix reports.
Simple Grouping
Click the Simple grouping tab. You have two options Top column information and left column information. Select the top column information from the combo box. This is a mandatory field.
Select the left column information from the combo box. This is a mandatory field.
Select the summarize column count from the combo box to get the column summary.
Normal Grouping
Click the Advanced grouping tab. You have two options Column grouping and Group by.
Select the Columns and Date format to be displayed from the combo box. Select the group by from the combo box. You have three options for group by to be displayed in the report. This is a mandatory field.
Select the summarize column from the combo box.
Select the period for which you want to generate the report. If needed you can also provide a custom period by choosing the from and to date manually.
Click Next.
To use Advanced Filtering, you first need to select the radio button for matching all the selected criteria or any one of them. Then from the column listing, select the various columns and set the match operator and mention the values for matching.
Filter Options
If you are using the date/time filter criteria, select the date column name from the Select Column combo box.
Select the period for which you want to generate the report. If you would like to generate report during this week, last week, this month, last month, this quarter, last quarter or today, yesterday then select the During radio button and select the time period from the combo box. (OR) If you wish to provide a custom period, then select the From and To date using the calender button.
To use Advanced Filtering, you first need to select the radio button for matching all the selected criteria or any one of them. Then from the column listing, select the various columns from the list and set the match operator and mention the values for matching the column as (is, is not, contains and so on) from the combo box.
Click the Choose button and select the value for the column to add as a filter condition.
Click as Add to Filter button to add the filter condition to the filter set which gets listed under the Filter Set title.
Click Run Report button. You get a matrix report
![]() ![]() ![]() |