Versions Compared

Old Version 4

changes.mady.by.user Jason Reel (Deactivated)

Saved on

compared with

New Version 5

changes.mady.by.user Jason Reel (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Panel

Always try to define your set of data very specifically. By default, ad hoc reports is going to try reporting on all records in the territory and users will need to be careful to limit the results strategically. It is suggested to always start by using the following filters:


Filter NamePurposeExample Data
Person TypeUse to restrict your report to specific types of records"Officer", "Cadet" etc
Person StatusUse to restrict your report to records with a specific status"Active", "Retired" etc


Section
ScreenshotImage Added



...

Too Many Results

Panel

The data returned in a report is dependent on the selected columns. When a column is selected the ad hoc report will try to return as much information as possible for the type of data (column). For example, if a user chooses to include the column "Command Name" the report will try to return the command for all appointments in the users OMS territory.

Section
ScreenshotImage Added

Depending on what is desired there are several things users can do in this example.

  1. Use the filter "Is Current Appointment" - as this will restrict results to each records with current /active appointments.
  2. Use the filter "Is Primary?" - as this will restrict results to only primary appointments.
  3. Use select dates (like appointment "Start Date"/"End Date") - as it will restrict results to a specific range of time.


Section

ScreenshotImage Added



Info
Try things and keep in mind that you can always remove a filter and try again. 

...