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. Depending on what is desired there are several things users can do in this example. - Use the filter "Is Current Appointment" - as this will restrict results to each records with current/active appointments.
- Use select dates (like appointment "Start Date"/"End Date") - as it will restrict results to a specific range of time.
|