Report builder

[judu007]

Hello, im trying to edit the "Less than 1gb memory" report to use the value 960 instead of 1000.. alot of desktops report the memory as 960 or when part is used for video..
i cut and pasted the sql query and edited the value and was unable to save the report??

incorrect syntax near the 'AS'

why does this not work?

SELECT
dbo.tblComputers.Computername AS Computer,
dbo.tblOperatingsystem.Description,
CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) AS Memory,
dbo.tblComputers.Domain,
dbo.tblComputersystem.Model,
dbo.tblComputers.Lastseen
FROM
dbo.tblComputers
INNER JOIN dbo.tblOperatingsystem ON (dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername)
INNER JOIN dbo.tblComputersystem ON (dbo.tblComputers.Computername = dbo.tblComputersystem.Computername)
INNER JOIN dbo.tblComputersystem tblComputersystem_1 ON (dbo.tblComputers.Computername = tblComputersystem_1.Computername)
WHERE
CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) < 960
ORDER BY
dbo.tblComputers.Domain,
CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC),
dbo.tblComputersystem.Model(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC)

[Hemoco]

Did you try this with the new beta report builder? http://www.lansweeper.com/forum/yaf_postst2046_Premium-Report-builder-352-beta.aspx