Jump to content


wannabe

Member Since 02 Jul 2014
Offline Last Active Jul 18 2014 09:43 AM
-----

Posts I've Made

In Topic: Running report create duplicate results

10 July 2014 - 09:33 AM

Great, how do i upgrade?


In Topic: Running report create duplicate results

07 July 2014 - 08:22 PM

Perhaps the image below is a better example

 

Report below is created on NOTES instead of OPPORTUNITIES.

 

On my system I have exactly the same problem. How do I filter redundant notes out? or fix the problem , bcs clearly it is a problem. Pay attention to some of the lines which are connected to an opportunity and some are not.... whats that about? and pay attention to opportunities ID, it jumps from a negative number to a positive one.. ??

 

h_1404764630_4547751_6bfc6ca55d.png

 

 

 


In Topic: Running report create duplicate results

07 July 2014 - 08:15 PM

there are duplicates, and on my system I also have 'unnamed' user, and I for sure have NO unnamed user.

 

For example, opportunity ID #5 has duplicates. Same owner, same modified user with same description (twice) on exactly the same date and hour and minute. On my own system I have 1 opportunity with 1 note, which is repeated several times.

 

screenshot below is from demo site.

 

h_1404764144_2721958_c489d86be4.png

 

 


In Topic: Running report create duplicate results

07 July 2014 - 06:06 PM

Well, look at the first column "ID" many ID's are repeating. If you would add Notes-> Description, this will be repeated 2-3 and sometimes 4 - times. Or just show empty results..

 

ID #1  is repeating 7 times .. there are your duplicates. 

 

And who and what is 'unnamed' user ??


In Topic: Running report create duplicate results

07 July 2014 - 02:02 PM

Hi speixoto,

 

I already gave exact details on how to recreate the duplicates. But I will give it once more, please use demo site and create a new report on opportunities.

 

* add filter last 7 days

then in columns add the following

 

Owner

ID

Notes >> ID

Notes >> Created By User

 

You will notice that the report will create duplicate results

 

rgds,

 

J.