:


AIMS Reports

The AIMS database ships with a number of preconfigured reports. AIMS database functionality also includes a reporting tool which allows users to create their own customised reports.

As well as these standard reports, additional pre-built AIMS reports may be made available from time to time in a format that allows users to quickly and easily import them into their own AIMS database.

Commissioned reports

It is also possible for users to specify and commission customised reports for a negotiable fee.

Additional free AIMS reports for import

A small selection of AIMS Version 3.0 reports which can be imported is available below. These reports are based on standard AIMS fields so may not work fully if you have changed or removed any of these fields from your database configuration.

NOTE: The report import facility requires AIMS version 3.0 or higher.

Importing reports

When you download a report you will receive a .dat file containing the report layout and the report itself. Once you have downloaded the report please see the instructions for Importing Reports in AIMS.

More information on creating and using reports can be found in the AIMS Help Guide which should have been installed with AIMS on your machine. A copy of the AIMS Help Guide is also available on the Help Guides and Documentation page of this site.

 
 Number
 
 Report Name

 
 Description
 AIMS report downloads

  

 
Code list


Displays all the coded lists in AIMS


2

 
Subject by Outcome

 
Displays the Subjects (at the highest level) broken down by various coded outcomes. When running the report conditions include a date closed range. Further conditions could be added to specify which caseworker or a particular project if needed.

 
3

 
Address Labels CSV

 
Produces a Comma Separated Values (CSV) file that can be used in MS Word to create address labels of any size. This report will only return details for people in the database not organisations. A condition has been added to the report but you will probably want to change this to make it more useful.

 
4

 
Subjects open and closed in a period

 
This report is mainly of interest for the Report conditions, which use the Indent to select all currently open subjects as well as those that have been opened and then closed within the same reporting period.

 
5


Find a work done note containing this word

 
Uses the "Contains" condition to search for records where a particular phrase or name has been mentioned in the Work Done notes field.

 
6


London Borough client and subject contact count

 
This report displays counts for all clients who have a London Borough field completed. Note that it uses Work Done in a period therefore includes all records worked on in the period which may have been opened prior to the period.

 
7


Check for missing client data

 
This report lists clients name and Id number and looks for any record missing certain bits of data, e.g. missing ethnicity or age data. You can add other client fields to the list of indented conditions to search for additional missing data.

 
8

 
Monthly opened subject and client count

 
Using the special function facility available in report layouts this report shows all subjects opened each calendar month by caseworker and subject, counting both clients and subjects opened.

 
9

 
GAB Directory columnar style

 
The Global Address Book (GAB) is the database within the database and allows you to capture up to 250 organisations for use in mail merge and referrals. This report details those groups address book style i.e. one page per organisation.

 
10

 
GAB Directory list style
 

 
The Global Address Book (GAB) is the database within the database and allows you to capture up to 250 organisations for use in mail merge and referrals. This report details those groups line by line with circa 20 per page.

 
11

 
Lapse time between date open and closed date

 
This report uses the Date Difference Fn function in layout to calculate the time period between a subject being opened to the date it is closed. Use this layout to copy and build other reports to gain insight into subject duration.

 
12

 
Lapse time between date open and today

 
This report uses the Date Difference Fn function in layout to calculate how long open subjects have remained open.

 
13

 
AgeBand calculated from DoB grouped by Gender


 
This report uses the AgeBand Fn function in layout to calculate the actual whole number age of the selected clients on the day it is run and then places those clients into the appropriate age band categories. N.b Advanced users will be able to build different age band divisions as required by different funders and use the date of birth to populate these new age divisions.

 
14

 
AgeBand calculated from DoB

 
This report uses the AgeBand Fn function in layout to calculate the actual whole number age of the selected clients on the day it is run and then places those clients into the appropriate age band category. Use this layout to copy and build other reports to save yourself having to build the Age Band function from scratch.

 15

Carer status by gender and age

 

Enhanced Linked Client (AIMS Extra users only). Carer status by Gender and Age.

 16

Family relationships by subject

 

Enhanced Linked Client (AIMS Extra users only). Displays the Relationship status between Linked Clients against their subject.

 

 17

Lead clients carer status with subject

 

Enhanced Linked Client (AIMS Extra users only).  Displays the client marked up as the "lead" amongst all those linked together against the subject.

 

 18

Lead client relationship with carer by subject

 

Enhanced Linked Client (AIMS Extra users only). Displays Lead clients relationship with carer by subject

 

 19

Linked client care status with subject

 

Enhanced Linked Client (AIMS Extra users only). Linked clients care status'swith subject