Report builder error : invalid token

[wavin]

Hello ,

I just did the upgrade to 3.5.1 and I tried to use Report Builder ( I've never used it in the previous version ).
When I try to edit a "custom" report ( LS report that I did directly in SQL Server db ) I always have the error :

INVALID TOKEN '(' at position 16 of line 1.

What does it mean ? If I try to edit a "standard" report , Report Builder works fine.

This is an example of "customer" report with the error in Report Builder :

USE [lansweeper31]
GO
/****** Object: View [dbo].[web30repnonitalian] Script Date: 05/11/2009 17:02:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER VIEW [dbo].[web30repnonitalian]
AS
SELECT TOP (100) PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblComputers.Domain,
dbo.tblOperatingsystem.OSLanguage AS Language, dbo.tblComputers.Lastseen AS [Last Seen]
FROM dbo.tblComputers INNER JOIN
dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE (dbo.tblOperatingsystem.OSLanguage <> '1040') AND (dbo.tblComputersystem.Domainrole = '1')
ORDER BY dbo.tblComputers.Domain, [Last Seen] DESC

[wavin]

Yes it works , thanks !

[Hemoco]

Change the view to

SELECT TOP 100 PERCENT
instead of
SELECT TOP (100) PERCENT