tag:blogger.com,1999:blog-4721830145069718578.post8855532084793021836..comments2023-04-25T15:15:17.530+10:00Comments on SharePoint Development & Administration + InfoPath: Data View conditional formatting using SharePoint DesignerDanielShttp://www.blogger.com/profile/07274977002584498975noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-4721830145069718578.post-22512901424233838642011-11-16T20:29:02.715+11:002011-11-16T20:29:02.715+11:00Hi @sivastree,
There may be a number of possibili...Hi @sivastree,<br /><br />There may be a number of possibilities here depending on the result that you are trying to achieve. If a user should only see items from the list that are assigned to them, you may be able to use a filter instead of conditional formating, which should perform better. This would be at the item level, so a 'row' in the data view will only be included if the corresponding item in SharePoint is assigned to them. <br /><br />To do this in Sharepoint 2007, you would create a filter on the Assigned To field with the criteria as [Current User] (parameter from the Value dropdown). This will result in a user only seeing items from the list that are assigned to them.<br /><br />To achieve using conditional formatting in Sharepoint 2007, you can add conditional formatting to "Show Content...". For the condition, select the Assigned to field in the "Field Name" column, and the [Current User] parmeter for the Value column of the condition (the [Current User] parameter should be close to the bottom of the list). This is assuming that you have created the dataview from a list in SharePoint. <br /><br />In SharePoint 2010 for a XSL List View the process is the same, but the [Current User] parameter is not always available to select when applying conditional formatting criteria. To allow the [Current User] to be selected as the value for Conditional Frmatting Criteria, you may need to add the following to the list of ParameterBindings (under the existing ParameterBinding elements) for the XLV Web part:<br /><br /><ParameterBinding Name="UserID" Location="CAMLVariable" DefaultValue="CurrentUserName"/><br /><br />Once this has been added, you will be able to select [Current User] as the value for the conditional formatting criteria. Depending on the format of the value in the UserID variable, you may need to use the AssignedTo.title as the field instead of AssignedTo, which can be accessed via the "More Fields..." option or by creating the condition using the advanced editor.<br /><br />Let me know if this helps.DanielShttps://www.blogger.com/profile/07274977002584498975noreply@blogger.comtag:blogger.com,1999:blog-4721830145069718578.post-81839579203725683512011-11-14T20:53:19.762+11:002011-11-14T20:53:19.762+11:00Hi, I want to allow people to view the data using ...Hi, I want to allow people to view the data using conditional formatting,if "Assigned to" is equals to logged in user. How can I show that?sivastreehttps://www.blogger.com/profile/09377206530814681007noreply@blogger.comtag:blogger.com,1999:blog-4721830145069718578.post-21163878678542584402010-12-04T07:16:12.189+11:002010-12-04T07:16:12.189+11:0090 days does not work because what SP does under t...90 days does not work because what SP does under the covers is just push the date into a string and then convert it to a number<br /><br />so 2010-04-29 becomes 20100429. It then subtracts 90 from this value to get 20100321 when what you are really after is 20100128Unknownhttps://www.blogger.com/profile/08897154100616980331noreply@blogger.comtag:blogger.com,1999:blog-4721830145069718578.post-87368301666649314762010-04-23T16:26:11.925+10:002010-04-23T16:26:11.925+10:00hi i have used the above approach, i want to displ...hi i have used the above approach, i want to display the user specific list view with condition based style applied. i created view and applied styles based on a condition, it is working fine when i see it direct. But when i go to the corresponding list webpart and change the current view name with my custom view created, it is prompting error that"cannot save and apply this property to the webpart". please tell me the proper way to get rid of thisNGKPRASADhttps://www.blogger.com/profile/13242230963355180379noreply@blogger.comtag:blogger.com,1999:blog-4721830145069718578.post-11420587603533911322010-03-29T23:57:11.093+11:002010-03-29T23:57:11.093+11:00Is there a maximum of 20 days or something, I can ...Is there a maximum of 20 days or something, I can not get it to work with 90 days.. :)Anonymoushttps://www.blogger.com/profile/14890086641907752409noreply@blogger.comtag:blogger.com,1999:blog-4721830145069718578.post-34557035763600980902010-03-05T11:00:48.962+11:002010-03-05T11:00:48.962+11:00Hi, are you able to use conditional formatting on ...Hi, are you able to use conditional formatting on a joined subview / nested table? Nothing I am doing seems to be able to work... Thanks, AndrewUnknownhttps://www.blogger.com/profile/00111931425132497364noreply@blogger.comtag:blogger.com,1999:blog-4721830145069718578.post-337380255816416652010-01-30T11:04:04.269+11:002010-01-30T11:04:04.269+11:00Hi ThinkOnItDevotions,
You will need to modify vi...Hi ThinkOnItDevotions,<br /><br />You will need to modify views which have been converted into Data View web parts using SharePoint Designer. You can update the name of the view when editing the settings for the view using the browser interface.<br /><br />I usually use a combination of standard views (List View Web Parts) and formatted Data Views, as the standard Views can be easily changed, as well as exported when required. Views that have been converted to Data View web parts will not export the columns set in the Data View, although Web Part connections should still be available when using Data View web parts with conditional formatting.<br /><br />Thanks<br /><br />DanielDanielShttps://www.blogger.com/profile/07274977002584498975noreply@blogger.comtag:blogger.com,1999:blog-4721830145069718578.post-92180016319488173552010-01-30T04:59:54.714+11:002010-01-30T04:59:54.714+11:00Did you discover that once the conditional format ...Did you discover that once the conditional format is applied, you can no longer modify the view or export the data?ThinkOnItDevotionshttps://www.blogger.com/profile/07517366172192765766noreply@blogger.com