web30repneverscanned Report error

[Ismail]

I tried to edit the predifined report "Never Scanned OS" by adding LastknownIP to the report. After adding and trying to save it gave out an error of me not able to save since the ORDER is not correct. I did document the error message since this usually happens when I try to save predifined reports with my my own additions I get that message. Thinking it was I could rectify by just closing the report and reponing I get this message when I try to edit or even view the report with the report builder.

Sadly I did not take a backup of my database the day earlier and I would like to rectify this problem as soon as possible. Any insight on how I can do this please let me know.

[Ismail]

Great, thanks

[Hemoco]

This is the original sql of the view

SELECT     TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblComputers.Username, dbo.tblComputers.Domain, 
                      dbo.tblComputers.Firstseen AS [First seen], dbo.tblComputers.Lastseen AS [Last seen], 
                      CAST(dbo.tblComputers.Lastseen - dbo.tblComputers.Firstseen AS bigint) AS [days alive]
FROM         dbo.tblComputers LEFT OUTER JOIN
                      dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE     (dbo.tblOperatingsystem.Computername IS NULL)
ORDER BY dbo.tblComputers.Domain, CAST(dbo.tblComputers.Lastseen - dbo.tblComputers.Firstseen AS bigint) DESC

If you want to do "order by" in a view you need the "SELECT TOP 100 PERCENT"