The public and police see local partnership schemes as key to cutting rates of alcohol-related crime that have fallen significantly in recent years, new research shows