Firepower Management Center (and even less so Firepower Device Manager) has pretty limited reports.
I've not seen anybody produce a satisfactory report of the type you are asking about using FMC. Cisco usually advises customers requiring robust reporting to consider using the WSA.