Software version column in computer with/without specific software

I was creating a report to show me computer with a specific software and noticed that I can not display the software version. I run the report for multiple version of one software and it would be nice to see which version the computer in the report has. I can try and do this through custom report but the problem with that is that it list the same computer multiple times thus even though it only installed on maybe 10 computers the report list over thousand lines. I can filter this out in excel but it would be lot easier if either in the inventory report to be able to list version of the software the report running for or in custom report to only show 1 instance of each computer with the specified software.