Forum

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.

Thanks
Supun


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)
SELECT DISTINCT reportid, 'REPORT', 0, 'REMOVEDISTINCT', 'true', 0,
'', 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,

Dustin

Best regards,

The Yellowfin Support Team

Contact Us:
Email: support@yellowfin.bi
Wiki: wiki.yellowfin.com.au/display/USER71/Home
Community Forum: www.yellowfinbi.com/YFForum.i4

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.