I made a verbal domestic violence complaint against my hushband but i want to take it back?

My husband and I were agruing about a friend coming to stay at our house I said no. He came home from work and we argued he broke his book case and told me that he would hit me with a bat if I didn't get away. I called the police the next day and made a report. The problem is I don't want him to loose his job. His work found out he is in law inforcement now he is being investigated thru them. Do you think he will be fired he didn't touch me. I just want him to go to consuling. Can I cancel a police report?