I am trying to supress duplicates from an SQL report

Dieter Schmerlaib shared this problem 3 years ago
Defect Logged

I am using 7.2 build 20160701. It seems that suppress duplicates in an SQL report does not work, I get no error but duplicates are not supressed. The same report works in 7.1

Comments (3)

photo
1

Hi Dieter,


Thanks for sending through the question and for including your build information. I've done a quick test on my end using your build and I can confirm that suppress duplicates does indeed work.


Do you think you might be able to send us an example of what you are experiencing? Perhaps a couple of screenshots showing your report in 7.1 and 7.2?


When I check 'Show Duplicate Records' the distinct is removed from my report SQL:


11ce7331d46b06ada7825df68fbc4353


When uncheck 'Show Duplicate Records' the below SQL is generated:

7a9c2a60222dfbc9e90d1adb23f6a08c


Can you confirm that this is what you are experiencing? Let me know what you think when you find a moment. I look forward to hearing back.


Kind Regards,


Dustin

photo
1

I am not using a drag and drop report it is a sql report so I don't get to choose the show duplicate option

photo
1

Hi Dieter,


Thanks for clarifying. You are indeed correct, the behavior in 7.1 and the most recent release of 7.2 is indeed different. This is a bug, and I have gone ahead and created a product defect to correct this:


Task ID #239445


I think in the mean time as an alternative you are going to have to use the drag and drop report builder or include 'SELECT Distinct' in your report SQL. Anyway, I apologize for the inconvenience this issue may cause in the mean time.


Please let me know if you have any follow-up questions or concerns on


this.


Kind Regards,


Dustin