This content is now out of date.

Visit Our Community

Show Duplicate Records option as a global setting

Hi Support,

Is there a way to enable "Show Duplicate Records" option in the report builder globally instead of enabling this option in each report. We need to retrieve records without DISTINCT keyword in all our reports.


Hi Supun,

Unfortunately this isn't currently possible within the Yellowfin UI. However, an enhancement request has been opened for this previously:

#105243 - Global setting for - Show duplicate records

I will go ahead and make an entry in the enhancement request to show continued customer interest in this enhancement. Hopefully it will be considered in the near future.

In the mean time, you could modify the YellowFin configuration database to enable 'Show Duplicate Records' on all of your reports. As always we recommend that you back up your Yellowfin configuration database before making configuration changes!

If you would like to enable Show Duplicate Records for all of your reports, please run the following SQL query against your SQL database:

[code]INSERT INTO reportformat (reportid, entitycode, entityid, formattypecode, formatcode, formatvalue,
description, fieldid, chartid, seriesid, axiscode)
'', 0, 0, 0, '' FROM reportformat WHERE NOT EXISTS (SELECT *
FROM reportformat
WHERE formattypecode = 'REMOVEDISTINCT');[/code]

Hopefully this information helps! If not please feel free to reach out again.

Have a great day.

Kind Regards,


Best regards,

The Yellowfin Support Team

Contact Us:
Community Forum: