August 2015 Tips - Exporting to Excel

Exporting Grids to Excel
 

Many of the data grids found within In-Synch RMS can be exported to Excel (.xls) documents.  This allows exported data to be sorted, filtered, or manipulated to make custom reports directly from Excel.  Exportable grids include:  Call Log, Admin Review, Query, Traffic Citations, Non-Traffic Citations, and Property.

Exporting Data Using the Right-Click Context Menu

With data populated on the Call Log, Admin Review, Citations, or Property grid, right-click and select "Export to Excel" from the context menu.

 


From the File Save As dialog window, select a save location (A), enter a file name (B), and then select the "Save" button (C).  The file will automatically be appended with the ".xls" extension upon saving.  Older versions of the RMS automatically name and save grid exports into the In-Synch folder ("C:\program files\in-synch\" - 32-bit or "C:\program files (x86)\in-synch\" - 64-bit).
 


Exporting Data from the Query Module

With data populated on the Query grid, select the "Export to Excel" button.

 


From the File Save As dialog window, select a save location (A), enter a file name (B), and then select the "Save" button (C).  The file will automatically be appended with the ".xls" extension upon saving.  Older versions of the RMS automatically name and save grid exports into the In-Synch folder ("C:\program files\in-synch\" - 32-bit or "C:\program files (x86)\in-synch\" - 64-bit).
 

 

 

Tags:

Please reload

Featured Posts

November 2019 Tips - Setting Call Type Triggers

November 18, 2019

1/5
Please reload

Recent Posts
Please reload

Archive
Please reload