I do have a solution for you. Just because you think the system doesn't work right doesn't mean it's wrong. The system has been working like this since well before you joined this forum and is certainly not news. The semantics for the CDR table was publically announced with the upgrade to version 11 (IIRC) because people complained that Asterisk wasn't reporting all of the calls in the system. The assumption (once again, as I recall) was that having too much pertinent data was better than not having data someone might need.
I did, in fact, explain (not opine) to you why the system does it and offered you the solution. Here's another one: submit an Issues ticket and ask for the "duplicates" to be removed from the report. Note that you may be directed to the Call Event Logging table for relief, but apparently, you believe that your perspective is the only one possible (that last part is an opinion).
@tm1000 explained it to you and so did I, but somehow you've decided that we're wrong?
If you want the "report" fixed, you can certainly do that. The source code for the basic reports module is open source. Fix it and submit a patch.
So, to recap the possible solutions:
- You can submit an Issues Ticket for support to get a checkbox added to the reports module. Note that without a ticket, no change to the system is likely.
- You can update the software to do what you want it to do and submit patches through the same Issues interface.
- You can change your source for call information and start using CEL instead of CDR, Note that this may also require an Issues ticket if you aren't a programmer.
- You can accept the fact that Asterisk produces these entries for a reason and adjust your expectations.
So there you go - four possible solutions. Is there anything else you'd like help with?