.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Cannot filter a KPI list view

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :C#


I'm just starting work with KPI in MOSS 2007 recently. Hopefully, I'm on the right forum. Please let me know if otherwise.

So, I've created a new KPI list. Inside that KPI list, I've created several indicators using data from another custom list on the same site. All of these indicators are using "All items" view from that custom list. Next, I've added another indicator from that same custom list but using a different view.

The indicators are working fine. I'm trying to create new view on that KPI list to show me the indicators that I'm interested in. I'm able to create new view based on the default "KPI List" view, but the filter doesn't seem to work. No matter which field or value I specify, the new view always shows all the indicators.

Is that the expected behaviour? I've tried to search online, but didn't see anything that can be of help. I need to create filtered view of the KPI list, because I'm showing these indicators on a web part page as part of a dashboard. For that, I'm using the web part for "Key Performance Indicator" but I don't need to show every single indicators. Only certain indicators will suffice.

One workaround I can think of is to create a separate KPI list and separate my indicators into different lists, but that sounds like an odd workaround/over the top!!!


View Complete Post

More Related Resource Links

How to filter a List View by multiple values for one filter field?

Hi, I need to create a dynamically created link to a List View with a filter on one field, but with multiple values. Example: http://<server>/Lists/<list>/Allitems.aspx?FilterField1=Name&FilterValue1=John/Jack/Jonas which should give me all items where Name equals John, Jack or Jonas. Is this even possible?

list view connection filter doesn't work

  I have  a custom display form for documents library with two connected List View WebPart. I am trying to filter documents at the second list view with the value from the first one. Both list views contain data from the same documents library. I have configured the connection, but second list doesn’t display any item, and it doesn’t matter which field I use for filtering. Also  for another document s library’s custom  display form  it work perfect.But there second list view contain data from another documents library. Not the same as at first   case. Any ideas with my issue?

Custom List View - filter blank value



I am creating a custom list view in SPD2010 and am having some problems. I want to have 3 filters (language, country and quarter). I have set these up as ASP drop down lists that auto postback and then I have defined the paramaters and linked them into the list filter.




This works fine and all 3 drop downs filter the list. The only problem I am having is if I want to search just on one column. The way I have it set up in the filter is

Country EQUALS [Country] AND
Language EQUALS [Language] AND
Quarter EQUALS [Quarter]

If I want to show all entries from Germany and not filter on Language and Quarter how do I do this? I have tried adding a "Please Select.." entry at the top of the list and setting the value to nothing but it does not work. I have had to create 3 seperate views but I would love to get these 3 filters working at the same time.

Is there a value in SP that I can use to filter on blank values or not consider the column at all? I have tried using nothing in the value and also tried NULL but neither have worked.

I have been trying to solve this for some time with no luck :( If anyone has any

Dynamic Data Foreign Key Filter - how to limit the # of dropdowns on the list view



I have a visual basic website in VS 2010 framework 4, linx to SQL, with scafolding.... and this dataclass has about 10 foreign key fields, of which all 10 are shown in the list view of the website.  I want the ability to exclude those filters from the list view (or exclude some and keep some), but without eliminating them from the edit forms.  Using <scafoldingcolumn("False")> does the trick to remove them entirely but that will also remove them from the grid/list itself, which I don't want, and remove the column from the edit record views, which I don't want either.

Any help would be great!!!!

custom field type works in view properties, but not in list view: 3 parent fields filter child list,


My situation:

A) odd thing is that no matter where I put a stop point in my custom field type, it is NEVER hit when the items are displayed in list view.  Event with <Field Name="CAMLRendering">TRUE</Field> which causes the list to error out, but again no stop point to help me know why.

B) the value of the column in question will be different for every user who views the list, I'm querying a secondary list based on the user's loginName, and two of the fields from the list we're in. 

C) the display is customized based on whether any records were returned and the current DateTime, so possible displays would be "", "! 12/1/2010", and "7/7/2011"

D) and the text displayed links over to a form for them to do their assignment. the link url would be a config setting url + "?[one of the fields form the list we're in]"

My questions:

1) Is it possible for fieldtype code to execute while a list view is being rendered?

2) If not, then should I chase down the path of a content query webpart?  Will it be able to filter on the current users login name?

3) If not on 1 or 2, can you think of any other way to do this beyond creating a custom application page? (need to having filtering and sorting on this page)

Disable filtering on a Dynamic Data list view.


I have an entity set of NotificationTemplates, and each one of these has a collection of zero-many SmsTemplate entities. When editing or viewing a NotificationTemplate, I have a link to View SMS Templates. That link takes me to a List view for the SmsTemplates entity set, filtered for the NotificationTemplate I was viewing.

How can I prevent the user changing this filter to show SmsTemplates for another NotificationTemplate? That is, I want the filter, but it must be read only. The drop-down just mustn't drop down, it must just display the name of the NotificationTemplate that these SmsTemplates belong to. To view SmsTemplates for another NotificationTemplate, the user must click View SMS Templates from that other template.

This was originally asked by myself on SatckOverflow at: http://stackoverflow.com/questions/3514373/disable-filtering-on-a-dynamic-data-list-view

Issue in Infopath 2007 browser form - cascading dropdown using owssvr.dll filter view


Referring the below link, I created a cascading dropdown. The parent dropdown has sharepoint list as datasource and the child dropdown has xml datasource that points to owssvr.dll filter view. The cascading drop down works fine in preview but throws error after publishing as admin approved form - "form cannot run the specified query" exception when trying to execute xml datasource i.e., when a value is selected in parent dropdown. The security is 'Full Trust". In the event viewer the error message states "401 unauthorised" for the user a/c. the xml data source is an approved udcx file and in central admin, have enabled cross domain for infopath service. I have tried different solution provided in tech forums but issue still exists. Not sure whether Im missing something. Can someone guide me in fixing this issue?

Link Reffered:



Is it possible to filter KPI list in order to display only relevant KPIs


I  have created a KPI list and I want to show sections of the list on various parts of my site, however, I dont seem to be able to filter the list. Has anyone tried this and had any success?

Filter web parts in new form page of a list



I've created 2 custom lists. The 2nd list has a lookup column from the 1st list. In the new form page for this 2nd list, I've added the 1st list as a web part. Now, I want to connect the 2 web parts, but it's not available. Basically, what I wanted is that when I select an item on the lookup column, the webpart containing 1st list would show that item on the same page.

I think I'll need to use Sharepoint Designer to implement something like this, but just wanted to check if anyone has done something like this using browser only.



Filter items with a date column with parameters start date and end date on a sharepoint list?

If I have alist with a view that has the columns Title, Status and Status Date and the view has some items. How Can I add a filter with two parameters, start date and end date, to only show records with status date equal to or greater than parameter start date and status date is less than or equal to parameter end date? This is a sharepoint online site and I can't create and deploy custom code, can use SPD though. Do I need to use SPD or is this something I can do in the list settings? Thanks in advance.   Edit: I had a look here http://www.endusersharepoint.com/2009/09/29/sharepoint-date-filter-filtering-a-list-by-greater-than-or-equal-to-date/ but I don't have the Date Filter web part.

Calculated date field displays differently in List View and Data View web parts

In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

list webpart, not using the sourse url, but referring back to the library view on close.

i have a webpart which brings a list in to my front page. -when user clicks, it shows  the item, and when he clicks on close,it takes him back to the library view. not back to the page,from where the request has initiated. we are using f5 load balancer, and our webapplications are extended. is there somesetup i am missing, so that i can make the sourse url's refer back to the originating page.        

List view - inline editing with read only fields

I'm new to sharepoint and using SP2010. I would like to use the inline editing feature of list view and at the same time to lock some of the fields. Is there a simpler way to achieve this like adding some field property using SP designer?

List View Permissions and Views for Web Parts

My fellow developers and I are going in circles a bit with our new Sharepoint 2010.  This question probably has several different answers.   I have a list of grades and comments that our Team Leaders want to create and save on Sharepoint.  When saved, the user who was graded should be able to see their own grades.  Its a pretty simple requirement and I'm 90% of the way there.   I created a list with the required fields, and two separate views.  The first view filters the list by the user's name so they see on their grades.  The second view shows all grades in a grouped order by the person who assigned the grade.  To make this second view more readable, I added some formatting with Sharepoint Designer 2010.  It looks nice.   Here's where the speed bump occurs.  I create a web parts page for each view.  The page showing only the user grades works as expected.  The other page, however, shows the list in a view that I didn't create.  No matter what view I select from the "Edit Web Part" menu, it always shows this strange view.  If I select the list, it says its current view is "Default".  The second view I created is set as default, but its not the view I see.  If I change the current view from list menu to the second view specifically, it shows up correctly. &n

How to filter view using ListViewXML with group by option?

I try to filter my view in list using ListViewXml property. The view has group by section. After implementing a filter for the view data under groups are the same(not filtered), but group rows show quantity of rows for each group  like filter is implemented. So it works well without group by.    XmlDocument document = new XmlDocument();  document.LoadXml(webPart.ListViewXml);  XmlNode queryNode = document.SelectSingleNode(".//Query");  XmlNode whereNode = queryNode.SelectSingleNode(".//Where");    if (whereNode != null)     {        whereNode.InnerXml = query.Query;      }   else       {        queryNode.InnerXml += "<Where>" + query.Query + "</Where>";        }  webPart.ListViewXml = document.InnerXml;    

Develop consumer which receiving data from list view

In my page I want to display a list view. Each time a user is clicking  on an item the relevant data of the current item will be passed to a consumer web part that I will develop. What interface the list view WP inherit from? Can you give send me an example of such implementation?   Tnx Keren  
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend