#眉標=SSRS 2008 R2、Web Services、Atom
#副標=SQL Server 2008 R2技術預覽(5)
#大標=資料庫報表轉成Atom格式摘要
#作者=文／圖 胡百敬


===<反灰>=============
=Multilookup(Split(Fields!ProductCategoryIDList.Value, ","), Fields!ProductCategoryID.Value, Fields!ProductCategoryName.value, "Categories")  
==<end>==============




===<反灰>=============
=Lookup(Fields!CustomerID.Value,Fields!CustomerID.Value,Fields!CompanyName.Value,"Jet_Customers")
==<end>==============





======程式1	<反灰>=============
=iif(
   Globals!RenderFormat.Name<>"EXCEL", 
   CStr(ReportItems!CalendarYear.Value) + " 群組" , 
Nothing) 
   + "頁數" + 
   CStr(Globals!PageNumber) + " ／" + CStr(Globals!TotalPages) +  
   iif(Globals!RenderFormat.Name="EXCEL", 
Nothing, 
"  (總頁數" + 
   Cstr(Globals!OverallPageNumber) + " ／" + CStr(Globals!OverallTotalPages) +")")
==<end>==============





=======程式2	<反灰>=============
<?xmlversion="1.0"encoding="utf-8"standalone="yes"?>
<servicexmlns:atom="http://www.w3.org/2005/Atom"xmlns:app="http://www.w3.org/2007/app"xmlns="http://www.w3.org/2007/app">
  <workspace>
	<atom:title>2DataRegionAsAtomDataFeed</atom:title>
<collectionhref="http://localhost/ReportServer?%2FNewFeatures%2F2DataRegionAsAtomDataFeed&amp;rs%3ACommand=Render&amp;rs%3AFormat=ATOM&amp;rc%3ADataFeed=xAx0x0">
	<atom:title>Tablix1</atom:title>
  </collection>
<collectionhref="http://localhost/ReportServer?%2FNewFeatures%2F2DataRegionAsAtomDataFeed&amp;rs%3ACommand=Render&amp;rs%3AFormat=ATOM&amp;rc%3ADataFeed=xAx0x1xCx0">
	<atom:title>Chart1</atom:title>
  </collection>
</workspace>
</service>
==<end>==============




=======程式3	<反灰>=============
<?xmlversion="1.0"encoding="utf-8"standalone="yes"?>
<feedxmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"xmlns="http://www.w3.org/2005/Atom">
  <titletype="text"></title>
  <id>uuid:37e60710-d697-446b-b2ac-15d383298018;id=1</id>
  <updated>2010-05-24T13:41:08Z</updated>
  <entry>
   <id>uuid:37e60710-d697-446b-b2ac-15d383298018;id=2</id>
   <titletype="text"></title>
   <updated>2010-05-24T13:41:08Z</updated>
   <author />
   <contenttype="application/xml">
	<m:properties>
	 <d:Country>France</d:Country>
	 <d:OrderDatem:type="Edm.DateTime">1996-07-04T00:00:00</d:OrderDate>
	 <d:Quantitym:type="Edm.Int16">12</d:Quantity>
	</m:properties>
   </content>
  </entry>
<entry>
  <id>uuid:37e60710-d697-446b-b2ac-15d383298018;id=3</id>
  <titletype="text"></title>
  <updated>2010-05-24T13:41:08Z</updated>
  <author />
  <contenttype="application/xml">
   <m:properties>
	<d:Country>France</d:Country>
	<d:OrderDatem:type="Edm.DateTime">1996-07-04T00:00:00</d:OrderDate>
	<d:Quantitym:type="Edm.Int16">10</d:Quantity>
   </m:properties>
  </content>
</entry>
…
======<end>==============