Exporting a Report
While somewhat robust, the Reporting tool in HOC is not as powerful as Crystal Reports, or Excel when it comes to analyzing your data. To do Pivot Tables, grouping, and major analytics, you will need to export a file out of HOC, and in to one of these analytic tools. Remember, you can't view more than 2000 records at once in Salesforce itself.
Navigate to the Report you would like to export
In the Reports Tab, you can find the report by changing the View Folders Options, Searching in the folders below, using a keyword search, of it it something that you have worked on recently, it will appear in the recent reports tab. Use the hyperlink of the report name to open that report.
Make sure you have your parameters set correctly
Make sure you have the right options, views, and time frames set to gather the correct information for your report.
You will notice in this report that we are getting all contacts created for this year and the last 2 years. This produces 51,536 records, which we won't be able to view in Salesforce. So we'll want to export this data.
If I were summarizing
In this example, I am summarizing by organization, and I have hidden the detail.
Notice however, hat that export Details button still says "Detail".
The export function only exports details, and does not export your summaries or groupings. You can regroup in excel after the data has been exported.
Click the Export Button, and a new window appears.
You will be taken to the Export Report Screen
Always choose the ISO-8859-1 (General US & Western Europe...etc) as the Export File Encoding. This is the most commonly used coding. If, however, your analytic software needs another coding, this is where you choose that option.
Generally, we use the file format CSV. This is so that it will work with the APEX Data Loader, and other software programs. If, however, you are only using Excel, you can choose that here, as well.
When you hit Export, a screen will pop up asking you where to save this file.