IT 專業人員的技術資源 >
論壇首頁
>
SharePoint - Excel Services (pre-SharePoint 2010)
>
Create where clause with parameters in Excel Services
Create where clause with parameters in Excel Services
- I'm just starting out with Excel Services, and I have what I think is a pretty straightforward question. Basically I have a set of data from SQL Server that I want to display in a workbook on MOSS, and I want to be able to control the dataset's contents with a parameter in the workbook that a user can modify on the web display. For example, year is the parameter, the user can enter a year, and the sheet shows only data for the selected year.
My question is this: can I set the workbook up so the query forms a where clause based on this user-entered parameter? Or, is there a better way to go about this altogether? Any help is appreciated. Thanks.
解答
- Excel Services does not support query tables. The best solution (portable across Excel Services and Excel) is to use a Pivot Table on the SQL datasource, and then to connect Slicer WebParts using Part to Part communication. There are also all kinds of other flavors of filtering web parts beside the one listed in the sample.
http://office.microsoft.com/en-us/sharepointserver/HA101054701033.aspx
http://blogs.msdn.com/excel/archive/2006/09/25/770961.aspx
For Excel Web App and Excel 2010 there are some even cooler filtering/visualization capabilities:
http://blogs.msdn.com/excel/archive/2009/09/23/easy-and-even-fun-data-exploration-introducing-excel-2010-slicers.aspx
Office 2010 Beta:
http://www.microsoft.com/office/2010/en/default.aspx
Hope that helps...
S/W Engineer, Microsoft Office Excel Services- 已標示為解答Lu Zou-MSFTMSFT, 版主2009年11月20日 上午 05:47
所有回覆
- Excel Services does not support query tables. The best solution (portable across Excel Services and Excel) is to use a Pivot Table on the SQL datasource, and then to connect Slicer WebParts using Part to Part communication. There are also all kinds of other flavors of filtering web parts beside the one listed in the sample.
http://office.microsoft.com/en-us/sharepointserver/HA101054701033.aspx
http://blogs.msdn.com/excel/archive/2006/09/25/770961.aspx
For Excel Web App and Excel 2010 there are some even cooler filtering/visualization capabilities:
http://blogs.msdn.com/excel/archive/2009/09/23/easy-and-even-fun-data-exploration-introducing-excel-2010-slicers.aspx
Office 2010 Beta:
http://www.microsoft.com/office/2010/en/default.aspx
Hope that helps...
S/W Engineer, Microsoft Office Excel Services- 已標示為解答Lu Zou-MSFTMSFT, 版主2009年11月20日 上午 05:47
