Sign in
 
HomeOnline20132010Other VersionsRelated ProductsLibraryForumsGallery
TechCenter >
> 
> 
Need to simply count sharepoint list items from a query

คำตอบ Need to simply count sharepoint list items from a query

  • Thursday, June 14, 2012 5:12 AM
     
     
    Sign In to Vote
    0

    Hi,

    I only need to count different conditions for different lists and put it on a clickable item on a Page like:

    Value1: 001     Vlaue 2: 009    Value 3:  010

    These values are based on a query (filter/condition) on a list from 2 fields for instance:

    if table1.fielda <1 and table1.field4<1

    that will give me the Values above, 001, 009, etc.

    I need to have these values on lables or formated like that and linkable to the real list for their counts as in:

    Value1: 001

    Time    
    0.75

    if clicked on 009

    Value2: 009

    Time  Time1  Time2  Time3   and so on......
    0.50   0.75    0.15    0.88

    is there a way for me to do that using SharePoint Designer 2010?

    any help appreciated.

    thanks,

     

All Replies

  • Tuesday, June 19, 2012 6:33 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi TheKerb,

    May be you could use data view “total” option.

    1. Go to list, modify this view.
    2. Scroll to the bottom of the page, there will be an option called “Totals” .
    3. Click on the column which you want to show the count, select count option you want.

    Because you mentioned use SharePoint designer 2010, what is your SharePoint?

    If your SharePoint is 2010, please refer to the following link. This forum is only for pre-SharePoint 2010.

    http://sharepointlogics.com/2010/03/total-count-of-items-in-list-in.html

    Thanks,

    Jack