Default Software Report shows no data

[ESIT]

Trying to run the built in Software Report in lsbuilder and it's coming up with no data. We have plenty of data and I've run other reports with success. Here is the the SQL and I haven't done any kind of modification to it:

SELECT
web30repsoftwaretotal.Software,
web30repsoftwaretotal.Version,
web30repsoftwaretotal.Publisher,
web30repsoftwaretotal.Total,
tblADusers.Username
FROM
tblADusers
INNER JOIN web30repsoftwaretotal ON (tblADusers.Username = web30repsoftwaretotal.Version)

This looks like what I'm trying to get, but again, no results. I created one that kind of works, but it displays multiples of the same software and version resulting in way too many rows. I need a report that displays something similar to this:

Adobe Reader 9.0.0 total: 450
Adobe Reader 9.5.0 total: 100
Adobe Photoshop 12.0.0 total: 45

That would list all software, the version, and the totals.

Thanks.

[Hemoco]

What about : "Select * From web30repsoftwaretotal"

[Hemoco]

Your join is wrong "ON (tblADusers.Username = web30repsoftwaretotal.Version)"
You need to join the same fields in the tables.

[ESIT]

Lansweeper wrote:
Your join is wrong "ON (tblADusers.Username = web30repsoftwaretotal.Version)"
You need to join the same fields in the tables.

I guess I don't exactly understand what I need to change. Any way you could post an example code based off what I need from the original post?

Thanks!