Can I use @table variable in SQL Server Report Builder?

Posted by edosoft on Stack Overflow See other posts from Stack Overflow or by edosoft
Published on 2010-04-23T15:00:45Z Indexed on 2010/04/23 15:03 UTC
Read the original article Hit count: 298

Using MS SQL 2008 Reporting services:

I'm trying to write a report that displays some correlated data so I thought to use a @table variable like so

DECLARE @Results TABLE (Number int, Name nvarchar(250), Total1 money, Total2 money)

insert into @Results(Number, Name, Total1)
select number, name, sum(total)
from table1
group by number, name

update @Results
set total2 = total
from
(select number, sum(total) from table2) s
where s.number = number

select from @results

However, Report Builder keeps asking to enter a value for the variable @Results. It this at all possible?

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about reporting-service