The object 'web30rep
nameofthereport' does not exist in database 'Lansweeper32' or is invalid for this operation.
Me and my fellow systemsmanager made a few report scripts of our own, but some of them went wrong.
Now I checked the SQL DB and the above message is correct, the object no longer exists in the DB.
Apparently when it goes wrong it erases the entire script and fails to open the report or remove the report from the builder.
But how do you remove it from the report builder when it is no longer in the DB?
Selecting and pressing delete does nothing, right clicking gives no remove option.
I already tried to find it in the DB but isn't there an easy way to remove reports that went bad?
Please help me, I made a working report but because of the bad original still in there I cant add it to the UI.
Because everything after that report goes invisible.
SELECT
dbo.tblComputers.Computername,
dbo.tblSerialnumber.ProductKey
FROM
dbo.tblComputers
INNER JOIN dbo.tblSerialnumber ON (dbo.tblComputers.Computername = dbo.tblSerialnumber.Computername)
WHERE
dbo.tblSerialnumber.Product NOT LIKE 'Internet Explorer' AND
dbo.tblSerialnumber.Product = 'Microsoft Windows XP'
As you can see, this only gives all XP serials. And its scripted correct, so I realy believe the origin comes from the original that cant be removed.