cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cbr
Engaged Sweeper
When I try to edit the Windows XP Report in report builder I get the following error:

The object 'Web30RepOSWinXP' does not exist in database lansweeperdb or is invalid for this operation.

What do I do? It seems to mess up my Digital Dashboard because this report is one of the report on this site.
5 REPLIES 5
Hemoco
Lansweeper Alumni
Please run the following sql script

CREATE VIEW dbo.web30repOSwinXP
AS
SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain,
dbo.tblOperatingsystem.Caption, dbo.tblOperatingsystem.Lastchanged
FROM dbo.tblOperatingsystem INNER JOIN
dbo.tblComputers ON dbo.tblOperatingsystem.Computername = dbo.tblComputers.Computername
WHERE (dbo.tblOperatingsystem.Version = '5.1.2600')
ORDER BY dbo.tblComputers.Domain

GO
cbr
Engaged Sweeper
Here is a screenshot after updating to latest version.
Hemoco
Lansweeper Alumni
COuld you first try upgrading to the latest version of the report builder and post a new screenshot please.
cbr
Engaged Sweeper
I have now attached a screenshot.
Hemoco
Lansweeper Alumni
Could you post a screenshot where exactly you get this behaviour.