Exporting Excel Data from Epic-Crystal Reports

To improve security of data containing PHI, users exporting files such as Epic-Crystal report data out of APeX will be prompted to enter a password to encrypt the files by default. Those passwords will be used to open files outside of APeX so that PHI can’t be assessed without the file’s password.  

Exporting Excel Data from Epic-Crystal Reports 

 

To export Excel data follow the steps listed below.  

  1. Click My Reports on the Hyperspace toolbar.  

  1. Select a report that’s Ready to View (or Viewed).  

Page Break 

  1. Click on the report and a dialog box should appear. 

 

  1. If this message pops up, please click ok 

Page Break 

  1. Select This PC.  

  1. Double-click your personal (P:) drive or any of the network drives listed under Devices and Drives.   (Note that the file now saves in a .XLSX format) 

  • you may also select the (P:) drive from the drop down menu in the Save in field 

  1. Enter the name of the file in the File name field.  

  1. Click Save.  

  • File Encryption Password window appears 

  1. Enter and verify password. 

  1. Click Accept. 

  1. If this window appears, please click on Cancel 

 

 

  1. Select Start , then Computer  and locate the Network drive you saved to in Step 6 

 

 

  1. Double-click to Open the file.   

  1. Enter the same password when prompted.  

C:\Users\diazda\AppData\Local\Temp\1\SNAGHTMLacbf242.PNG

  1. The file should open in Excel 

For questions, please contact [email protected].