Please Help!! SharePoint List Customization Question
-
יום רביעי 20 יוני 2012 19:18
I am currently building an inventory solution for my job. I have 2 seperate lists.
1 List is the Available Inventory which has the current in stock inventory in it. This list can have multiple FRU Numbers (Part Number) so there could be a total of 7 items with the same FRU number which is fine.
I am trying to get the totals to show up on another list called Inventory Report. I need to somehow query the availible inventory list and ask it how many items with this (FRU) number do you have. Return myself a Count and then display in the other list.
I have not found anyone that knows how to do this. I really hope someone knows on here.
Please see attached since they explain better
.
כל התגובות
-
יום רביעי 20 יוני 2012 19:25
try this
http://sharepointlogics.com/2010/03/total-count-of-items-in-list-in.html
Ashish Ranjan (Please click "Marked As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you)
-
יום רביעי 20 יוני 2012 20:07
Thank you for your reply. There are a couple issues with doing it that way for my situation.
1: If all inventory parts are used then it wouldn't show anything at all on the count. Not even 0.
2: I still need that number to be shown up on the other list. Even if there are no FRU numbers that match I need to have the query return 0.
Is there another way to do this?
-
יום רביעי 20 יוני 2012 21:29 Does the Available Parts list have a lookup to the Inventory Reports list? If so, you should be able to use the lookup function as a count. Here is a blog post that explains how it works for blogs. http://blogs.msdn.com/b/jackiebo/archive/2007/02/23/lookup-count-related-the-magic-behind-sharepoint-s-comments-column.aspx
~Jennifer Mason ~My Blog~ ~SharePoint Support~ ~SharePoint Training~ ~Follow me on Twitter!~
- הוצע כתשובה על-ידי Stunpals יום שישי 22 יוני 2012 21:52
-
יום חמישי 21 יוני 2012 05:30
Yeah, You can edit the XSLT which is resposible for displaying the current view. Use a custom xslt to display the Listview webpart. You have to use sharePoint designer. There you can add columns in the view with your rules and conditions. There you can have logics to display columns.
for example
http://blogs.pointbridge.com/Blogs/hulse_brian/Pages/Post.aspx?_ID=2
you can get some idea from belwo video
http://www.sharepoint-videos.com/sp10xslt-list-view-web-parts-and-conditional-formatting/
Ashish Ranjan (Please click "Marked As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you)
- סומן כתשובה על-ידי Entan MingMicrosoft Contingent Staff, Moderator יום חמישי 28 יוני 2012 01:41
-
יום שישי 22 יוני 2012 16:38I am testing the responses out. I will let you know what I find.
-
יום שישי 22 יוני 2012 21:52Sounds like the "Count Related" will work, if I am understanding the question right. I have used this for a list containing Clients. I have several lists that use a lookup to get the clients name from this list. Now on the clients list I have a lookup to point back to the other list and you get a nice count on how many items in that list has that client name.
Stunpals - Disclaimer: This posting is provided "AS IS" with no warranties.
.png)
