在 sharepoint 2007 中创建仪表板 [英] creation of dashboard in sharepoint 2007
问题描述
为了创建仪表板，我需要找出获取列表字段中项目计数的方法.如何实时获得相同的内容?
For the creation of a dashboard I need to find out the way to get the count of the items in a field of a list. How to get the same in real time?
假设我有一个包含以下字段的列表；
Let’s say I have a list with the following fields;
季度 >>>> 批次号 >>>>>> 现场/包装/发货
Quarter >>>> Batch# >>>>>> In field/Packed/Shipped
例如，如果第一个列表的条目如下所示；
For eg, if the entries for the first list is as given below;
季度 >>>>>>>>>>>>>>> 批次号 >>>>>>>>>>>>>>>>>>>>> 状态
Quarter >>>>>>>>>>>>>>>>> Batch# >>>>>>>>>>>>>>>>>>>>> Status
Q1 ---------------------B1------------------------------------ 在现场
Q1 ------------------------------------B1------------------------------------ In the field
Q1 ---------------------B2 ------------------------------------在外地
Q1 ------------------------------------B2 ------------------------------------In the field
Q1----------------------------------------B1 ------------------------------------打包
Q1------------------------------------B1 ------------------------------------Packed
Q1-----------------------------------------B2 ----------------------------------- 已发货
Q1------------------------------------B2 ----------------------------------- Shipped
Q1-----------------------------------------B2------------------------------------ 已发货
Q1------------------------------------B2------------------------------------ Shipped
现在，我需要获得一个仪表板列表，其中给出以下结果；
NOW, I need to get a dashboard list where in it give the below result;
它应该看起来像;
状态 >>>>>>>>>>>>>>>> 批次 1 >>>>>>>>>>>>>>>>> 批次 2
Status >>>>>>>>>>>>>>>>> Batch 1 >>>>>>>>>>>>>>>>> Batch 2
在现场------------------------1----------------------------------1
In the field ------------------------1----------------------------------1
打包 ------------------------- 1-----------------------------------0
Packed ------------------------- 1-----------------------------------0
已发货------------------------- 0--------------------------2
Shipped------------------------- 0----------------------------------2
请帮助了解如何创建上述仪表板.
Please help upon how to create a dashboard like the above.
推荐答案
这种类型的操作通常称为交叉制表或通常称为透视"操作.
This type of operation is generically called Cross Tabulation or often 'Pivot' operations.
您可以使用 SharePoint Designer、数据视图 Web 部件 (dvwp) 和一些非常花哨的 XSLT 来完成此操作，但这并不容易.这是 DVWP 的良好开端.
You may be able to do this using SharePoint Designer, the Data View Web Part (dvwp) and some very fancy XSLT - but its not going to be easy. This is a great start on the DVWP.
然后是 Jim Bob 的系列Howard - 扩展数据视图 web部分
否则，我认为您正在考虑开发自定义 Web 部件.
Otherwise I think you're looking at developing a custom web part.
或者，有一个商业 Web 部件可让您对 SharePoint 列表中的数据执行交叉制表和透视操作 (免责声明 - 我自己的公司出售这个，但它与所提出的问题非常相关).
Alternatively there is a commercial web part that will allow you to do cross tabulation and pivot operations on data from SharePoint lists (disclaimer - my own company sells this, but its very relevant to the question asked).
这篇关于在 sharepoint 2007 中创建仪表板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
