Building DataMiner Platinum (DMP) Reports – 5 – Review Data and Export
The Review Data and Export tab allows you to review the results of the query, sort and filter using the grid, and ultimately export the data to Excel. You can also schedule the report to be delivered by email on a regular basis.
Filter the Results
One of the most significant tools are the filters. Apply additional filters to the grid to further enhance your query and fine tune your data selection. Type your filter in the text box above the corresponding column and then select the type of filter by clicking the small arrow to the right of it.
For example, in the screenshot below we’ve added a filter of “Greater Than 200” in the DonationAmount field.
Sort the Results
Just like every other grid in DonorSnap, click the column heading to sort by that field. Clicking a second time will reverse the sort order. A third click will remove the sort altogether. You can apply multiple levels of sorting by clicking on multiple field headings in the order that you would like the sort to take place.
Fine Tune the Results
The second selection control is to specifically omit certain records. You can uncheck the box to the left of any specific record to signify that you do not wish for that item to be included in the final export. (Remember to save the page if you’ve changed any of the specific selections before you navigate to another page in the grid).
Clear Sort and Filters
To clear all your queries or sorts, click the appropriate “Clear Filters” or “Clear Sort” buttons. If you ever have an issue exporting the results, try clicking both of these buttons and then save the changes. This fixes most problems on this page.
Export the Results
Click the button in the upper right “Export to Excel” to download a spreadsheet of the data. Make sure you click the Save Changes button first if you have added any sorting/filtering/unchecking.
Schedule the Report to be Emailed
Have the report delivered to your email inbox on a regular basis by clicking the “Schedule Email Report” button to the right of the Export button. Choose a one-time, daily, weekly, monthly, or quarterly email schedule. The results of the report will be updated each time the email is sent giving you the most current view of your data. Reports can be scheduled for up to two years at a time.