Category
Report Builder
Product Version
9.0
Supressing Duplicates
Awaiting Reply
Is there a way to suppress duplicates globally I have a report with 286 columns. I would like to turn on "suppress duplicates" for all of them at the same time. Is this possible?
The same question
Hi Byron,
Thanks for reaching out to support with your question. Typically this setting is adjusted through the GUI per column, I don't see a documented API call for these types of settings changes currently, but I could make a request if you'd like to see this type of functionality in the future.
Another potential method of achieving this would be to find the YF configuration DB column for 'suppress duplicates' and adjust the field values; this could potentially cause unexpected results and can't be officially supported, but you can monitor DEBUG logs to find the SQL on the UI action, or just browse table data and likely make short work of this.
Hope this helps, let me know if you have any additional questions.
Thanks,
Eric
Hi Byron,
Thanks for reaching out to support with your question. Typically this setting is adjusted through the GUI per column, I don't see a documented API call for these types of settings changes currently, but I could make a request if you'd like to see this type of functionality in the future.
Another potential method of achieving this would be to find the YF configuration DB column for 'suppress duplicates' and adjust the field values; this could potentially cause unexpected results and can't be officially supported, but you can monitor DEBUG logs to find the SQL on the UI action, or just browse table data and likely make short work of this.
Hope this helps, let me know if you have any additional questions.
Thanks,
Eric
Replies have been locked on this page!