Custom report not working after 4.0 upgrade.

[Ismail]

Hello,

I have a few reports that are not working due to the upgrade.


This was a report that displayed computers that had Custom department field empty

Select Top 100 Percent dbo.tblComputers.Computername, dbo.tblComputers.LastknownIP, dbo.tblComputers.Lastseen As [Last Seen], dbo.tblComputers.Firstseen As [First Seen], dbo.tblCompCustom.Department From dbo.tblComputers Inner Join dbo.web30repallcompstates On (dbo.tblComputers.Computername = dbo.web30repallcompstates.Computername) Left Outer Join dbo.tblCompCustom On (dbo.web30repallcompstates.Computername = dbo.tblCompCustom.Computername) Where dbo.tblCompCustom.Department Is Null Or dbo.tblCompCustom.Department = '' Order By dbo.tblComputers.Computername

Please Advise

[Hemoco]

Select Top 1000000 dbo.tblComputers.Computername, dbo.tblComputers.LastknownIP,
  dbo.tblComputers.Lastseen As [Last Seen], dbo.tblComputers.Firstseen
  As [First Seen], dbo.tblCompCustom.Department, dbo.tblComputers.ComputerUnique
From dbo.tblComputers Left Join
  dbo.tblCompCustom On dbo.tblCompCustom.Computername =
    dbo.tblComputers.Computername
Where (dbo.tblCompCustom.Department Is Null) Or
  (dbo.tblCompCustom.Department = '')
Order By dbo.tblComputers.Computername

[Ismail]

Okay then how can I get a report that shows "Department" field in "Custom fields"
as empty ?

[Ismail]

Report has an invalid syntax:
Invalid object name 'dbo.web30repallcompstates'.

[Hemoco]

Ismail wrote:
Report has an invalid syntax:
Invalid object name 'dbo.web30repallcompstates'.

dbo.web30repallcompstates doesn't exist anymore

[Hemoco]

What is the exact error?