Page Comparison

This article describes how to add a new report profile using similar base/field criteria of an existing report.

Step-by-step guide

Firstly, open up your reports whilst in the production management module (Open the report section of Framework, by either pressing the report button on the toolbar, or by pressing CTRL + R).This will take you to the below screen:

Image RemovedImage Added

After you are in this screen, you can select the report which you would like to make a new profile for and select 'preview'.Alter the base criteria, including major work flow stages, job status, division

Base Criteria

Image Added

a) Major/minor workflow stage selection. Select one, many or none. E.g. if I only wanted jobs in construction, I would need only select the construction stage.
b) Job status. Can be particularly important, depending on which kind of job you are trying to show. Standard is Active/On-hold.
c/d/e) Division, region and region/division:

Image Removed

Next, change the field criteria to reflect the changes you require for this profile, i.e. to only show administrator Mr John Smith's jobs:

Image Removed

...

. Used for companies that operate as separate regions or divisions. Selecting one region division will only generate jobs in that region division.

Field Criteria

In this example, we'll add the Administration Complete date where it is not empty.

Image Added

To do this:

1. Select the Field Criteria tab.
2. Select the field you require (in this occasion Administrator)fields are organised into groups - the field you are after will most likely be in it's logical grouping).
   a) For finding fields, think of where the field 'lives' in Framework. E.g. most Admin fields are in Administration, Pre-Admin/Sales are in PreAdministration, Job details in Job and so on.
3. Click the >> button to push this across to required criteria
4. Choose the Administrator from the list provided
5. Select OK

   Select the criteria for the field pushed across. If this is a date field, the options relate to the field and either the date that exists in the field, or something about the date itself (e.g. if it's happened within a date range).
   a) A date range can be helpful in cases such as, "show me jobs in the last year that have construction completed". You would then use a 'in a period' to select within a date range for your appropriate report.
   b) An entity list criteria can be helpful when we only want to show jobs where a particular member of staff has worked on them. For example, give me a list of jobs that Josh Jones has worked on as a Construction Supervisor.
   
   

   Tip
   A combination of date/entity/list fields can be used to narrow down the result set to exactly what you are after. E.g. Show me a list of jobs that had a construction complete (actual) date in 2019, where the construction supervisor was Josh Jones and the house type was the Oxley 25.

   
   

6. Select OK on the field criteria dialog.
7. This will now show in the 'Required Criteria' as shown by 6.

Groups/Grouping

Similar to the field criteria, we want to select a field then push it across using the >> button.

Image Added

1. Select the folder from the groups, then find the field.
2. Select the field.
3. Press the >> button.
4. The report grouping will now update.

Move to the advanced Tab.

1. Similarly to adding a field criteria, we just want to select the field we want to group by.

Alter the Title of the report, ensuring to conform to normal naming conventions pre-established within previous profiles.

Image RemovedImage Added

1. Change the title to reflect your profile the name of this report, Ee.g. Wf Analysis Admin Completes 2019 - Admin Ovw (John Smith)Press save to create a new report profileby Admin.
2. Add in a description of what it is that this report is going to show.
3. Press the save button to save this report profile, for later use or reuse.

After you are happy with the title / fields, select the save button. When given the below dialog, select 'yes' to create a new profile, and 'no' to overwrite a previous report profile. 

Image RemovedImage Added