When a report has been created or being edited you are able to change report options. One of the report options is to alter "display options". Click on this cog and the display options form is shown:
Fig 1 - Display options
What does the "don't show repeating values for the same record" do?
Imagine you had a report that gave the name of Key Contacts for each of your contracts. Your report, when it is first built, may look something like this:
| Contract ID | Contract Title | Contact First Name | Contact Last Name |
| 101 | Bin Collection Service | Simon | Wright |
| 101 | Bin Collection Service | Fred | Wells |
| 101 | Bin Collection Service | John | Taylor |
| 102 | Fire Safety management | Paul | Willis |
| 102 | Fire Safety management | David | Fargo |
This report contains all the information you require, but because each contract has more than one person associated to it, there are "repeated values" relating to the same record (i.e. same contract). If you check the box "Don't show repeating values for the same record" for this report, the output would be altered to:
| Contract ID | Contract Title | Contact First Name | Contact Last Name |
| 101 | Bin Collection Service | Simon | Wright |
| Fred | Wells | ||
| John | Taylor | ||
| 102 | Fire Safety management | Paul | Willis |
| David | Fargo |
This has made the report easier to read. Where there are repeating value from the same record, this option will hide them
Note: Where a report is being output to CSV for further manipulation in a spreadsheet then this option should be left unchecked. Spreadsheets are easier to work with if all the data for repeating values are provided.