{"id":505,"date":"2022-02-02T16:07:58","date_gmt":"2022-02-02T21:07:58","guid":{"rendered":"https:\/\/www.pmievidencetracker.com\/manual\/?p=505"},"modified":"2022-05-19T13:30:03","modified_gmt":"2022-05-19T18:30:03","slug":"built-in-reports-2","status":"publish","type":"post","link":"https:\/\/www.pmievidencetracker.com\/manual\/blog\/built-in-reports-2\/","title":{"rendered":"Built In Reports"},"content":{"rendered":"\n

Reports Tab<\/h4>\n\n\n\n

The \u201cReports\u201d<\/em><\/strong> tab has six pre-designed reports (see figure 65) that will help the user organize and maintain the evidence\/property room. Please don\u2019t forget to set the proper permissions for users to use the application as the administrator wishes.<\/em><\/strong><\/p>\n\n\n\n

\"\"
Figure 65<\/figcaption><\/figure><\/div>\n\n\n\n
Case and custody report<\/h5>\n\n\n\n

The \u201cCase and Custody\u201d<\/em><\/strong> will present the user with (see figure 66) a window that will list all active items and case numbers for the user to choose from. The user can select \u201cReport on Selected Item,\u201d \u201cReport on Selected Case,\u201d \u201cFilter List,\u201d <\/em><\/strong>or \u201cReport from Case #.\u201d<\/em><\/strong><\/p>\n\n\n\n

Once a case number or item in a case has been selected, the user will need to select one of the previously listed options. Once the report is generated, it provides documentation that can be placed in a case file or given to an individual their records.<\/p>\n\n\n\n

\"\"
Figure 66<\/figcaption><\/figure><\/div>\n\n\n\n

The \u201cReport on Selected Item\u201d <\/em><\/strong>option will produce information regarding the item selected and its\u2019 chain of custody log. The \u201cReport on Selected Case\u201d <\/em><\/strong>option will generate a report for ALL <\/em><\/strong>items listed under the selected case number and each items chain of custody records. The \u201cFilter List\u201d <\/em><\/strong>option enables the user to filter the information displayed in the list down to a case number that might have many items related to it. The \u201cReport from Case #\u201d<\/em><\/strong> (see figure 67) option will enable the user to enter the case number they wish to view case and custody information for.<\/p>\n\n\n\n

Once the desired report is displayed and the user has all the information they need. They can choose to print the report by selecting the printer icon in the upper middle of the report screen. Another way to run the report is to highlight the desired case number and click onto the \u201cReport on Selected Case.\u201d This gives you a report of all records in the case. A third way to run the report is to click onto the \u201cFilter List\u201d button and it gives you a drop-down to select by Case Number or by Tracking Number. A fourth way to run the report is to click onto the \u201cReport from Case Number\u201d button and a case number input screen will be displayed. Enter the case number you want to run a report on and click the \u201cOK\u201d button.<\/p>\n\n\n\n

\"\"
Figure 67<\/figcaption><\/figure><\/div>\n\n\n\n

The \u201cCase and Custody\u201d<\/em> <\/strong>report (see figure 68) will show the case number, the department information, and the current date at the top of the report. Each piece of evidence will be listed numerically by tracking number and will display information on each item in the case along with all chain of custody logs.<\/p>\n\n\n\n

\"\"
Figure 68<\/figcaption><\/figure><\/div>\n\n\n\n
Archive Case and custody report<\/h5>\n\n\n\n

The \u201cArchive Case and Custody\u201d<\/em><\/strong> report (see figure 69) is structured similar to the \u201cCase and Custody\u201d<\/em><\/strong> report previously described with one exception; it only generates reports on cases that are archived. To run a report on an individual case number, the user will select \u201cReport on Selected Case.\u201d <\/em><\/strong>If the user would like a report generated by inputting a case number, they can select the bottom option \u201cReport from Case #.\u201d <\/em><\/strong>The steps are identical to the steps listed in the \u201cCase and Custody\u201d <\/em><\/strong>report.<\/p>\n\n\n\n

\"\"
Figure 69<\/figcaption><\/figure><\/div>\n\n\n\n
Case Out report<\/h5>\n\n\n\n

The \u201cCases Out\u201d<\/em><\/strong> report (see figure 70) will generate a report on an item that have been batched out from the evidence\/property room and not yet returned.<\/p>\n\n\n\n

\"\"
Figure 70<\/figcaption><\/figure><\/div>\n\n\n\n

The report (see figure 71) header will display the report title, the department information, date stamp, and page count. The report will display the information on each piece listed and the batch out information regarding to its\u2019 location. The user can generate a \u201cCases Out\u201d<\/em><\/strong> report at any time to display which pieces of evidence that are checked out of the evidence\/property room. To generate a report for all items currently logged out, the user will select the \u201cReport on All\u201d<\/em><\/strong> option, and it will display a report on all the records that are out of the evidence\/property room.<\/p>\n\n\n\n

\"\"
Figure 71<\/figcaption><\/figure><\/div>\n\n\n\n
Inactive cases report <\/h5>\n\n\n\n

The \u201cInactive Cases\u201d<\/em><\/strong> report (see figure 72) will display all cases marked as \u201cInactive\u201d<\/em><\/strong> in the \u201cEvidence Log.\u201d<\/em><\/strong> The \u201cInactive Cases\u201d<\/em><\/strong> report header displays the report title, the department information, a date stamp, and page count. The report includes the \u201cCase Number,\u201d<\/em><\/strong> \u201cTracking Number,\u201d<\/em><\/strong> \u201cEvidence Description,\u201d<\/em><\/strong>
\u201cEvidence Room Location,\u201d<\/em><\/strong> \u201cDate of Recovery,\u201d<\/em><\/strong> and \u201cRecovered By.\u201d<\/em><\/strong> The \u201cInactive Cases\u201d<\/em><\/strong> report can provide the user a list of items that can be disposed of or decide which cases can be archived.<\/p>\n\n\n\n

\"\"
Figure 72<\/figcaption><\/figure><\/div>\n\n\n\n
Review By Month Report<\/h5>\n\n\n\n

The \u201cReview by Month\u201d<\/em><\/strong> report (see figure 73) will display a window for the user to select a \u201cReview Period,\u201d <\/em><\/strong>then the user will select \u201cRun Report.\u201d<\/em><\/strong><\/p>\n\n\n\n

\"\"
Figure 73<\/figcaption><\/figure><\/div>\n\n\n\n

The report (see figure 74) will generate a list of items in the evidence\/property room with a status tagged for review based on the number of months that were selected in the record. The report is often required by Local, State, and Federal jurisdictions for maintaining an accurate count for \u201cGuns,\u201d \u201cDrugs,\u201d \u201cCash,\u201d and \u201cBiological\u201d items.<\/p>\n\n\n\n

\"\"
Figure 74<\/figcaption><\/figure><\/div>\n\n\n\n
Disposition Report<\/h5>\n\n\n\n

The \u201cDisposition\u201d <\/em><\/strong>report (see figure 75) will generate a report on items where the user selected the \u201cDispose\u201d <\/em><\/strong>checkbox. The checkbox is used to indicate the intention to dispose of the item later and is how the application will recall the items to generate the \u201cDisposition\u201d <\/em><\/strong>report.<\/p>\n\n\n\n

\"\"
Figure 75<\/figcaption><\/figure><\/div>\n\n\n\n
Cash detail report<\/h5>\n\n\n\n

The \u201cCash Detail\u201d<\/em><\/strong> report (see figure 76) is a detailed list of all pieces of evidence that have been tagged as \u201cCash\u201d<\/em><\/strong> in the \u201cEvidence Type\u201d<\/em><\/strong> field. This report gives the user a grand total of cash logged into the evidence\/property room at the top left under the department information. The information listed in the report for each case number will provide the user with a total bill count, a total coin count, and a grand total listed under the case number. This feature only works if the user inputs the necessary information in the trigger window after selecting \u201cCash\u201d <\/em><\/strong>as the \u201cEvidence Type,\u201d <\/em><\/strong>and the user inputs the correct bill and coin count. The \u201cCash Detail\u201d <\/em><\/strong>report can be used as a quick cash audit for the evidence\/property room.<\/p>\n\n\n\n

\"\"
Figure 76<\/figcaption><\/figure><\/div>\n\n\n\n
Drug Detail Report<\/h5>\n\n\n\n

The \u201cDrug Detail\u201d<\/em><\/strong> report (see figure 77) will list all pieces of evidence that are tagged as \u201cDrugs\u201d<\/em><\/strong> in the \u201cEvidence Type\u201d<\/em><\/strong> field. This report gives the user details relating to each piece of evidence including the quantity, weight, or volume.<\/p>\n\n\n\n

\"\"
Figure 77<\/figcaption><\/figure><\/div>\n\n\n\n
Gun Detail report<\/h5>\n\n\n\n

The \u201cGun Detail\u201d<\/em><\/strong> report (see figure 78) will display gun detail information about every piece of evidence in the evidence\/property room that has been categorized as \u201cGuns\u201d<\/em><\/strong> in the \u201cEvidence Type\u201d<\/em><\/strong> field. This report provides the user with detailed information including the Make, Model, Caliber, and Serial Number of each gun entered if the record creator input the information.<\/p>\n\n\n\n

\"\"
Figure 78<\/figcaption><\/figure><\/div>\n\n\n\n
Biological detail report<\/h5>\n\n\n\n

The \u201cBiological Detail\u201d<\/em><\/strong> report(see figure 79) will display a list of all pieces of evidence that are tagged as \u201cBiological\u201d<\/em><\/strong> in the \u201cEvidence Type\u201d<\/em><\/strong> field. This report provides the user with detailed information as to the type of biological substance has been recovered.<\/p>\n\n\n\n

\"\"
Figure 79<\/figcaption><\/figure><\/div>\n\n\n\n
Property reciept by tracking number<\/h5>\n\n\n\n

The \u201cProperty Receipt by Tracking Number\u201d <\/em><\/strong>(see figure 80) is a receipt the user can print that will display all the information pertaining to the tracking number they input in the search bar (see figure 81). As shown in the figure below, the receipt has two signature lines, one for “Received By\u201d <\/em><\/strong>and the other \u201cOfficer Witness.\u201d<\/em><\/strong><\/p>\n\n\n\n

\"\"
Figure 81<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Figure 80<\/figcaption><\/figure><\/div>\n\n\n\n
Property receipt by case number<\/h5>\n\n\n\n

The \u201cProperty Receipt by Case Number\u201d<\/em><\/strong> (see figure 82) is similar to the \u201cProperty Receipt by Tracking Number\u201d<\/em><\/strong> except instead of entering a tracking number, the user only enters a case number for which they want to create a receipt. One receipt will be generated listing all the pieces of evidence entered under the selected case number in the \u201cEvidence Log.\u201d<\/em><\/strong><\/p>\n\n\n\n

\"\"
Figure 82<\/figcaption><\/figure><\/div>\n\n\n\n

Express Custom Reports<\/h4>\n\n\n\n

The \u201cExpress Custom Reports\u201d<\/em><\/strong> option (see figure 83) was designed to give the user the ability to create various reports using information from any of the fields located in the \u201cEvidence Log.\u201d<\/em><\/strong><\/p>\n\n\n\n

\"\"
Figure 83<\/figcaption><\/figure><\/div>\n\n\n\n
Creating a custom report<\/h5>\n\n\n\n

To create a \u201cCustom Report,\u201d<\/em><\/strong> select \u201cReports\u201d<\/em><\/strong> located on the main screen, then select \u201cExpress Custom Reports\u201d (Ctrl+F11).<\/em><\/strong> Once the custom report screen opens (see figure 83), select an option from the \u201cFROM\u201d <\/em><\/strong>drop-down list (see figure 84); (Evidence Log, Asset Log, Archive Log, Activity Log, and Evidence Detail Log).<\/p>\n\n\n\n

\"\"
Figure 84<\/figcaption><\/figure><\/div>\n\n\n\n

After the user has selected one of the options from the drop-down list, they will then need to add field headers to the \u201cSELECT\u201d <\/em><\/strong>field (see figure 85). The user will need to select field headers from the list in the left pane that they want the information from displayed on the report. For example, if the user needs information about case number, date of recovery, evidence description, evidence type, item#, suspect, and the tracking number, they will select those field headers from the left pane. First the user will need to select \u201cSELECT\u201d <\/em><\/strong>by clicking on it with the left mouse button. Once \u201cSELECT\u201d <\/em><\/strong>is selected it will highlight in green. The user will then select, by their desired order, the field header names they wish to recall information about (see figure 86).<\/p>\n\n\n\n

\"\"
Figure 85<\/figcaption><\/figure><\/div>\n\n\n\n
\"\"
Figure 86<\/figcaption><\/figure><\/div>\n\n\n\n

If the user has specific information they wish to find, the user will use the \u201cWHERE\u201d <\/em><\/strong>field to filter the information before the information is recalled for viewing. This is accomplished by selecting \u201cWHERE\u201d <\/em><\/strong>then, selecting an option from the left pane (see figure 87). Once the user has selected a field header from the left pane, they will need to select an option from the drop-down list i.e., \u201cBETWEEN.\u201d <\/em><\/strong>There are eight options to choose from (see figure 88).<\/p>\n\n\n\n

\"\"
Figure 87<\/figcaption><\/figure><\/div>\n\n\n\n

The \u201cLIKE\u201d <\/em><\/strong>option will allow the user to use \u201cwildcards\u201d (%) to help them find information they may not know the exact spelling or information. i.e., Evidence Type LIKE [\u201c%Gen\u201d] will produce any record with an Evidence Type like General, general, or any words listed in the Evidence Type that start with \u201cgen.\u201d This can be especially useful if spelling is questioned.<\/p>\n\n\n\n

comparison and criteria<\/h5>\n\n\n\n

If the user wants to filter the selected field information to only include certain conditions are met, they will need to select \u201cWHERE.\u201d<\/em><\/strong> Next the user will select which field they want to use to filter the data. By clicking on a field header in the left pane. If the user selects the down-down, they will see a list of 8 options to choose from.<\/p>\n\n\n\n

\"\"
Figure 88<\/figcaption><\/figure><\/div>\n\n\n\n

The available comparisons are:  <\/p>\n\n\n\n

\u201c=\u201d <\/strong>Use this option for exact data. (If the user wants to set the criteria where a field is blank, they need to use the \u201c=\u201d<\/em><\/strong> for the comparison option and then leave the criteria field blank.) Not applicable for date fields.<\/em><\/strong><\/p>\n\n\n\n

\u201cNOT =\u201d <\/strong>(use date or text fields for an exact comparison).<\/p>\n\n\n\n

\u201cLIKE\u201d <\/strong>(choose the \u201cLIKE\u201d<\/em><\/strong> to search for word(s)) (see figure 89) Can also use wild cards.<\/p>\n\n\n\n

\u201cBETWEEN\u201d <\/strong>(used for date fields) <\/p>\n\n\n\n

\u201cgreater than\u201d <\/strong>(used for date fields)  <\/p>\n\n\n\n

\u201cgreater than OR =\u201d <\/strong>(used for date fields)  <\/p>\n\n\n\n

\u201cless Than\u201d <\/strong>(used for date fields)  <\/p>\n\n\n\n

\u201cless than OR =\u201d <\/strong>(used for date fields) <\/p>\n\n\n\n

\"\"
Figure 89<\/figcaption><\/figure><\/div>\n\n\n\n

Once the user has selected the type of comparison to use, they need to select what the criteria will be.<\/p>\n\n\n\n

Criteria can be but is not limited to:<\/p>\n\n\n\n