| Author |
Message |
Ionut
Guest
|
 Posted:
Sun Nov 06, 2005 1:50 pm Post subject:
count in share point portal |
|
|
I have a list with the following structure
Computer Name | SO | Ip|
------------------------------
adrian | XP | 192.168.100.100
....................etc..
How can i count (and report) how many XP computers, 98 computers....
Thanks in advance ! |
|
| Back to top |
|
 |
Olaf Koestner
Guest
|
| Posted:
Mon Nov 07, 2005 9:51 am Post subject:
Re: count in share point portal |
|
|
Hi Ionut,
You can do this by switching to the Datashett-View of
the list, set a filter according to your needs and add
the totals. In the last row (totals) you can specify for
each cell the function to be used. With one of the listed
functions you can count the number of listed items.
Bye,
Olaf |
|
| Back to top |
|
|
Ionut
Guest
|
| Posted:
Mon Nov 07, 2005 9:51 am Post subject:
Re: count in share point portal |
|
|
how can i generate a report with this in another list, pivot ...
"Olaf Koestner" <not@given.yet> wrote in message
news:OD67DB34FHA.2600@tk2msftngp13.phx.gbl...
| Quote: |
Hi Ionut,
You can do this by switching to the Datashett-View of
the list, set a filter according to your needs and add
the totals. In the last row (totals) you can specify for
each cell the function to be used. With one of the listed
functions you can count the number of listed items.
Bye,
Olaf |
|
|
| Back to top |
|
|
Olaf Koestner
Guest
|
| Posted:
Mon Nov 07, 2005 1:51 pm Post subject:
Re: count in share point portal |
|
|
If you are facing the datasheet view you can click on
"Task Pane", which will be opened on the right of the
datasheet view.
You can now export the list to excel, create a pivot
table etc. |
|
| Back to top |
|
|
Ionut
Guest
|
| Posted:
Tue Nov 08, 2005 9:51 am Post subject:
Re: count in share point portal |
|
|
can i publish this on the portal...and the list remain some way connected to
this pivot table ?
"Olaf Koestner" <not@given.yet> wrote in message
news:eBXJU%2344FHA.3136@TK2MSFTNGP09.phx.gbl...
| Quote: |
If you are facing the datasheet view you can click on
"Task Pane", which will be opened on the right of the
datasheet view.
You can now export the list to excel, create a pivot
table etc.
|
|
|
| Back to top |
|
|
Chris
Guest
|
| Posted:
Wed Nov 09, 2005 9:51 am Post subject:
RE: count in share point portal |
|
|
Hi Ionut,
if you create a new view of your list, and use the "group by" option to
group by "SO", SharePoint will give you the count of items for each SO.
If you need to change the look, you can then use FrontPage to transform your
view into a data view Web Part.
Hope this helps,
Chris
"Ionut" wrote:
| Quote: | I have a list with the following structure
Computer Name | SO | Ip|
------------------------------
adrian | XP | 192.168.100.100
....................etc..
How can i count (and report) how many XP computers, 98 computers....
Thanks in advance !
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in