Report Builder: Invalid Token on Select

[QNS]

I'm trying to build a report using the folowing query:

select a.computername, a.softwarename, b.computername, b.softwarename from
(select * from dbo.tblSoftware a where ComputerName = 'stsweb02' ) a
full join
(select * from dbo.tblSoftware b where ComputerName = 'ptsweb03' ) b
on a.softwarename = b.softwarename
where a.softwarename is null or b.softwarename is null
order by a.computername, b.computername desc

I'm getting an invalid token ')' at position 72 of line 2.

I'm running report builder 3.5.0.17

This query runs fine in mgmt studio against 2005.

[QNS]

So is that something that a patch could be built for or rolled into the next version?

I was hoping to build a report to compare my staging and production enviroments on an ongoing basis.

[Hemoco]

QNS wrote:
So is that something that a patch could be built for or rolled into the next version?

That's the idea.

as a temporary workaround you can create a dummy report and change the SQL code afterwards in sql management studio.

[Hemoco]

Problem confirmed.