#眉標=SSRS 2008 R2、Report Builder 3、ESRI shape
#副標=SQL Server 2008 R2技術預覽(2)
#大標=SSRS 2008 R2空間資料的取得與呈現
#作者=文／圖 胡百敬


===<反灰>=============
=Fields!Special.Value & vbcrlf & "地址：" & Fields!Address.Value & vbcrlf & "電話：" & Fields!Tel.Value & vbcrlf & "傳真：" & Fields!Fax.Value
==<end>==============






==程式1	<box>===========
USE Tempdb
GO
CREATE TABLE t(
PK INT IDENTITY PRIMARY KEY,
Year SMALLINT,
Month VARCHAR(10),
Sales INT)

DECLARE @i INT=1,@j INT=1
WHILE @i<4
BEGIN
  WHILE @j<13
  BEGIN
  	INSERT t VALUES(2006+@i,DATENAME(M,DATEADD(M,@j,GETDATE())),CONVERT(INT,RAND()*1000))
  	SET @j+=1
  END
  SET @j=1
  SET @i+=1
END
==<end>==============