Weatherfield's biggest-ever whodunnit has been underway for weeks after the solicitor's body was found