---
title: "Designer: Troubleshooting duplicated data"
canonical: "https://servicedesk.maxgeo.com/space/LC/1263403149/Designer%3A%20Troubleshooting%20duplicated%20data"
format: markdown
---
**Problem:**
1. I have multiple identical rows of data in my data tables - start at **Troubleshooting 1**. (NOTE: We refer to each of these rows of data as "offending datasets" such as those outlined in green in the top image below).
2. I have a value that is static throughout the report instead of changing to the relevant value - start at **Troubleshooting 1**.
**Troubleshooting:**
1. Determine the Field relevant to each Table Cell, Label and Checkbox.
- If a table cell, label or checkbox has been manually assigned, and it should be bound to data (i.e. dynamic; the data changes throughout the Report based on data contained in the database) - refer **Cause 1**.
2. Determine those Fields not used in the Report Template.
- If there is redundant data, and that redundant data can vary between each of the offending datasets - refer **Cause 2**.
3. Determine the source of each of the Fields, then review 1 and 2 above again to see if the outcome is the same.
- If the data is coming from a table/view where the offending data combination *does* occur more than once - refer **Cause 3**.
4. If you have cross-referenced tables and views, consider if you have used a value or field that can can have multiples of the data.
- If this is the case - refer **Cause 4**.
**Cause:**
1. The table cell, label or checkbox has not been data bound and therefore is a static value in the report - refer **Solution 1**.
2. The Report Designer has a row of data for each of these variations, thus the information appears multiple times (e.g. in the image above (green), the source data for the Report is based on Actions, and although the report doesn't detail it - there is a row of data for each Lease) - refer **Solution 2**.
3. The Report Designer has a row of data for each of these variations, thus the information appears multiple times (e.g. in the image above (green), the source data for the Report is based on Actions, and although the report doesn't detail it - there is a row of data for each Lease) - refer **Solution 3**.
4. The Report Designer has a row of data for each of these variations, thus the information appears multiple times (e.g. in the image above (green), the source data for the Report is based on Actions, and although the report doesn't detail it - there is a row of data for each Lease) - refer **Solution 4**.
**Solution:**
1. Bind the cell, label or checkbox to the relevant Field.
2. Remove these fields from the Report Template ***if***** **the data is not required. If it is required, consider using other features, such as grouping and sub-reports.
3. Consider using a different data source. If that is not possible, try Solution 2.
4. You will need to edit the cross-reference such that multiples are not returned. If that is not possible, try Solutions 2 and 3 above.
**Additional Info:**
- *What are "data tables" and how do I know this is one of them?* If you open up the Report Designer, you will see that your report template is broken into sections - referred to as "Bands". Usually, the information in "Detail" is setup to be a data table. To confirm, go to the "Report Explorer" window (default position is top right, under "Field List"). You will see each of your 'Bands' is listed, and by expanding each you can see what each 'Band' consists of. One of them will be a "Table". This 'Table' is what we have referred to above as a "data table".
- *How do I determine the Field relevant to each Table Cell, Label and Checkbox?* This part is easier than it seems - so don't worry. Go to each cell, label and checkbox and click on it once. A little arrow will appear in the top-right of the cell/label/checkbox. Client on this to open up a menu and look at the "data binding" field.
- If it is empty - this cell/label/checkbox has a value that was assigned manually and therefore does not relate to a Field.
- If it has data - click on the [...] button, and a dropdown menu will be displayed, with the relevant Field selected.
- *How do I determine those Fields that are not used in the Report?* Once you have determined all Fields relevant (refer above for further instruction), check also the Report Parameters (user-selected filtering) and the expressions for any calculated fields. Anything in the "Field List" window that does not form any of these things are not used in the Report.
-