Andrew will only be allowed to appear with the royal family occasionally, if at all, under King William, a new report says.