Running Reports on Sales

PRINT THIS DOCUMENT - RUNNING REPORTS ON SALES (PDF)

Click here to go Back to the Main Help Page.

SEARCH FOR SALES

Start the process by searching through your sales for appropriate sales for your land analysis and improvement analysis reports. The first search should be for sales with no improvements, between 100 and 1,000 acres, and limited to four (4) counties for the Land Analysis Report. I found 14 sales within the given criteria.

The second search should be for sales with improvements, less than 500 acres, and limited to four (4) counties for the Improvement Analysis Report. I found 17 sales.

LAND ANALYSIS REPORT

Once you have your sales selected for the land analysis report, click on the button Reports > Analyze Land. A screen will come up with three (3) tabs along the top: Summary, Sales, and Land Data.

The ‘Summary’ tab summarizes the land use information held within the sales selected. If you click on the plus sign next to a ‘Type’ of land use, a ‘Distribution Chart’ appears, along with another tab next to it called ‘Distribution Data’. The Distribution Data is a summary of what the Distribution Chart illustrated. If you right click anywhere in this screen, a two option menu will appear offering ‘Jump to Low Sale’ or ‘Jump to High Sale’. If you select ‘Jump to Low Sale’, you will be moved to the Sales tab and the lowest sale in your selection using price/acre as the measurement.

The ‘Sales’ tab lists all of the sales included in the analysis, along with details about the sale such as Index #, Grantor, Grantee, Net Price, etc. Here you can select whether you want the sale included in the analysis or not. If you do not want the sale included in the analysis, uncheck the ‘Selected’ box along the left side of the screen.

The ‘Land Data’ tab lists all of the land type information from all of the sales selected. You can sort any of the columns alphabetically (or by type) by clicking on the grey title bar. Once you click on the grey title bar, a grey arrow will appear indicating whether the responses are sorted ascending or descending. You can also sort by response by clicking on the black down arrow at the far right of each column. A list of all of the responses will appear allowing you to select one to sort by.

If you right click on a particular row, an option will appear “Jump to Sale” allowing you to go back to the ‘Sales’ tab to the corresponding sale.

IMPROVEMENT ANALYSIS REPORT

Once you have the sales searched out that you want for the improvement analysis report, click on the button Reports > Analyze Improvements. A screen will come up with three (3) tabs along the top: Summary, Sales, and Improvement Data.

The ‘Summary’ tab summarizes the improvement information held within the sales selected. If you click on the plus sign next to a ‘Type’ of improvement, a ‘Distribution Chart’ appears, along with another tab next to it called ‘Distribution Data’. The Distribution Data is a summary of what the Distribution Chart illustrated. If you right click anywhere in this screen, a two option menu will appear offering ‘Jump to Low Sale’ or ‘Jump to High Sale’. If you select ‘Jump to Low Sale’, you will be moved to the Sales tab and the lowest sale in your selection.

The ‘Improvement Data’ tab lists all of the improvement information from all of the sales selected. You can sort any of the columns alphabetically (or by type) by clicking on the grey title bar. Once you click on the grey title bar, a grey arrow will appear indicating whether the responses are sorted ascending or descending. You can also sort by response by clicking on the black down arrow at the far right of each column. A list of all of the responses will appear allowing you to select one to sort by.

Printing and Exporting Reports

Once you have generated the report you want, you can print the report or you can export it to Microsoft Excel, text file, or HTML file.

Printing a Report

To print an analysis report, right click on any one of the column header bars and select "Print" at the very bottom. You will notice that, depending on the tab you are on, some of the column header bars will only come up with a menu that allows "Jump to Low Sale" or "Jump to High Sale". If this happens, simply select a different column header bar.

Once you select "Print", another screen will come up with a preview of what the printed report will look like. If you are happy with the report, click on File > Print.

If you are not happy with the look of the report (columns are too wide, cannot read the text, etc.), close out of the Print Preview and start again.

Exporting a Report

If you want to save this report for future use, you can export it to Microsoft Excel, a Text file, or an HTML file. If you save to Excel or a text file, none of the graphs/images will be exported - only the HTML file will save the graphs/images.

Exporting to Microsoft Excel

To export your report to Microsoft Excel, right click on the column header bar and select Export > Excel.

A "Save As" screen will come up asking you where you want to save your new Excel file at. Choose your location, name your file and click on "Save".

To view the file created, run Microsoft Excel and open the file. You can then edit the information in the worksheet.

Exporting to an HTML file

To export your report to an HTML file, right click on the column header bar and select Export > Html.

A "Save As" screen will come up asking you where you want to save your new HTML file at. Choose your location, name your file and click on "Save".

To view the file created, go to the location you saved the file and open it. It will open in an Internet Explorer window.

If you saved the report with the graphs, a folder should have been created in the same location as the HTML file and should be called "File name.Images". Within this folder are individual BMP files of the graphs.

Exporting to a Text file

To export your report to a Text file, right click on the column header bar and select Export > Text.

A "Save As" screen will come up asking you where you want to save your new Text file at. Choose your location, name your file and click on "Save".

To view the file created, go to the location you saved the file and open it.

The file will open using Notepad and will look something like the following image. This is a report of the first tab "Summary" with the graphs.