Mulptiple Entrys in Report

[tdecenso]

Hello,

I have a slight problem when I built a report based of table tblSerialnumber, the SQL Query looks like this:

SELECT
tblSerialnumber.Computername,
tblSerialnumber.Product,
tblSerialnumber.ProductKey
FROM
tblSerialnumber
WHERE
tblSerialnumber.Product NOT LIKE '%internet%'


So when I run the report every single computer has two entrys for Microsoft Office 2003 Professional Edition.

Please advise on if there is something wrong on my side, but if there is something wrong on my side is there a way in Report builder to filter multiply entrys.

[Hemoco]

Could you try

SELECT distinct
tblSerialnumber.Computername,
tblSerialnumber.Product,
tblSerialnumber.ProductKey
FROM
tblSerialnumber
WHERE
tblSerialnumber.Product NOT LIKE '%internet%'

:

[Hemoco]

Your report looks ok, could you post a screenshot of this behaviour and the config of your scanned keys please.

[tdecenso]

Lansweeper wrote:
Your report looks ok, could you post a screenshot of this behaviour and the config of your scanned keys please.

Attached photo to orininal post

[tdecenso]

Lansweeper wrote:
Your report looks ok, could you post a screenshot of this behaviour and the config of your scanned keys please.

How do I post a picture?