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.
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 *
WHERE formattypecode = 'REMOVEDISTINCT');[/code]
Hopefully this information helps! If not please feel free to reach out again.
Have a great day.
The Yellowfin Support Team
Community Forum: www.yellowfinbi.com/YFForum.i4