Reports: Analyzing, Printing, and Emailing Your Data

The reporting features in Diabetes Pilot Desktop allow you to analyze your data and transfer it to other programs.

To access the reporting features, click the "Reports" icon on the left side of the Diabetes Pilot window.

Creating Reports

Creating a report in Diabetes Pilot is an easy three step process:

Step 1: Choose a Report

Select the report you would like to create from the list near the upper left corner of the Diabetes Pilot Window. There are several reports to choose from:

Average BG by Category - Shows your average glucose organized by category
Average BG by Hour - Shows your average glucose as an average for each hour of the day
Average BG by Month - Shows your average glucose by month
Glucose Graph - Graphs your individual glucose readings over time
Glucose 24 Hr Overlap - Graphs several days of glucose readings overlapped on a single 24 hour graph to help identify daily patterns in your data.
Glucose Monthly Overlap - Graphs several months of readings overlapped on a single 1-month graph to help find monthly patterns in your data
Record Listing - Lists your records in a manner similar to how they appear on the My Records page.
Record Listing (Plain) - Lists your records in a manner similar to how they appear on the My Records page in a more plain format suitable for export to spreadsheets other programs.
Record Grid - Shows your records in a grid format organized into columns for each record type
Logbook/By Category - Shows your records in a "logbook" grid format organized by category
Meal Listing - Lists the foods and nutritional content in your meal entries
Meal Listing (Plain) - Lists the foods and nutritional content in your meal entries in a format suitable for export to spreadsheets and other programs.
Daily Food Summary - Summarizes food intake by day
Medication Totals - Shows a total of the medications you've entered for each day
Exercise Totals - Shows a total of the exercises you've entered for each day
Glucose by Range - Shows the number of glucose measurements in your target range, above your "high" limit, and below your "low" limit. These ranges can be set in the preferences window (see Setting Preferences for more information)
Recent BG Averages - Shows your average glucose for various time periods.
Blood Pressure List - Lists your blood pressure readings

Step 2: Choose Records

Next, choose the records that you would like in the report using the filter controls (see Display Filters for more information). Or, click the "Show All Records" button to include all of your records. Note that if your filters do not allow any records to be selected, the report will be blank - if this happens, change the filter settings to select the dates, categories, and record types that you want to include.

Step 3: Create the Report

Click the "Create Report" button to create the report. Your records will be processed and the report will be displayed in a few moments.

Viewing the Report

Once you've created the report, use the controls above the report to view it. Hovering the mouse over a control for a few seconds will tell you what each control does.

Many reports will be more than one page - use the arrow controls above the report to move forward and backwards through the pages.
Click the printer icon to print your report.
Use the percentage drop-down list to to zoom in and out on your report.
Use the "paper" icon to switch between a printed page view and a simplified "on screen" view of the report.
Use the "disk" icon to save your report for use in other programs. (see Exporting Reports to Other Programs for more information)

Exporting Reports to Other Programs

After you create a report, you can save it for use in other programs. To do this:

Create a report (see Creating Reports for more information)
Click on the "envelope" icon in the toolbar located above the report area. A window will appear that will allow you to select the location and format of the file that you'd like to create.
Select the type of file that you'd like to create:
- Adobe Acrobat (pdf) - This format saves your report as a file that can be read by Adobe Acrobat. This can be a useful format for emailing your reports to others, since many computers have software that can read Adobe Acrobat files. This format preserves the original look of your report. You can get a free version of Adobe Acrobat reader on the web at http://www.adobe.com/products/acrobat/readstep.html.
- Microsoft Excel (xls) - This format saves your report as a Microsoft Excel spreadsheet file. This format can be read by Microsoft Excel and many other spreadsheet programs. It's useful if you'd like to do further calculations on your data using your own spreadsheet software.
Enter the filename and choose the location for saving the file, then click the Save button.

After you've saved the report, you can open it in another program, email it, or whatever else you'd like to do with it.