Report not limiting to collection

[billybarty]

I have a report with statements that query software that we have listed in add remove programs and it has a prompt in it for which collection we want it run against. I have a collection for all our internal Windows servers and that is what I am running the report against.
What is happening is the report data I am getting is not limited to the collection. I am getting the counts of software installed on all the OS's from all our SMS clients.
Here is an example of the statement, I have only posted one of the statements for one of the products and followed by that is the prompt statement. Any help is appreciated.

SELECT DisplayName0 as 'McAfee VirusScan Enterprise', Count(ProdID0) AS 'Count', Version0
FROM v_GS_ADD_REMOVE_PROGRAMS
WHERE DisplayName0 like "McAfee VirusScan Enterprise"
GROUP BY DisplayName0, Version0
ORDER BY Version0
Prompt Statement
begin
if (@__filterwildcard = '')
select CollectionID, Name from v_Collection order by Name
else
select CollectionID, Name from v_Collection
WHERE CollectionID like @__filterwildcard
order by Name
end