Report Creator crash corupts database

[NSG]

Today I was asked to print out some reports on how many laptops we have on our network and now many desktops and what there numbers where. When trying to create a rapport to do so report creator crashed and I had to use task manager to stop it's process. But it seems this has somehow impacted the database beyond the one report.

Now when trying to get any information about laptops if it's: Laptops without VPN Patch ore All portable computers the pages just stops.

Is there any way you could help me whit this problem whit out losing all data maybe a default report table? please keep in mind that my SQL knowledge is limited

[Hemoco]

You can change this setting using the configuration utility.

[NSG]

Super that fixed my problem. Only thing is that there are no percentages but those will return I hope?

[Hemoco]

try to execute this code

create view web30repallportables as SELECT     TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblComputerSystemProduct.Vendor, 
                      dbo.tblComputerSystemProduct.Name, dbo.tblComputers.Lastseen AS [Last scanned], dbo.tblComputerSystemProduct.Lastchanged
FROM         dbo.tblComputers LEFT OUTER JOIN
                      dbo.tblComputerSystemProduct ON dbo.tblComputers.Computername = dbo.tblComputerSystemProduct.Computername LEFT OUTER JOIN
                      dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE     (dbo.tblComputers.Computername IN
                          (SELECT     tblportablebattery.computername
                            FROM          tblportablebattery))
ORDER BY dbo.tblComputers.Computername

[NSG]

No I get the fallowing error: invalid object name 'web30repallportables' when I try to open the report

[Hemoco]

Could you open the report builder and edit this report?