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

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

SP Designer 2010 Conditional Formatting with Hidden Values/Columns

Posted By:      Posted Date: October 15, 2010    Points: 0   Category :SharePoint

I have a list with 30~40 columns. I want to do conditional formatting on it using SharePoint 2010 Designer (instead of creating a visual webpart with vs2010).

Of the 30-40 columns, i am only viewing 5 columns that i need (ie: first name, last name, etc...)

I can create the XSLT ListView Webpart on the page within SharePoint 2010. I can edit it with SharePoint 2010 Designer, i can also apply conditional formating to the row (ie: select row within XSLT webpart > Options > Conditional Formatting).

However, i cannot apply the conditional formatting too columns that are not listed in the <ViewFields> of the <XmlDefinition>. What gives? I want to do conditional formatting on the entire row of the item using the hidden ten or so columns and i don't want the user to see all the columns, but i want to do conditional formatting on them (its for æsthetics reasons, i don't want a grid list of 15+ columns on someones poor 1024 by 768 resolution/monitor... plus they don't need to see it until they click into the list item....)


<FieldRef Name="SomeColumnName" Hidden="True" /> does not work
<FieldRef Name="SomeColumnName" ReadOnly="True" /> does not work either

View Complete Post

More Related Resource Links

Conditional formatting on a joined subview using SharePoint Designer 2007 does not work

I have 2 SharePoint lists, one is a parent task list and the other a child task lists.  In SharePoint Designer 2007 I have created a combined datasource from these 2 lists.  From there I created a new ASPX page inserting the parent list as a dataview and the child as a subview.  So far so good, all is functioning as you would expect.    Now I need to apply conditional formatting to cells and rows in both the parent and child lists.  I can create a very simple condition on a row or cell of the parent list such as "If ID Equals '2988' format the background color as green" but no conditional formatting appears for the row where ID = 2988.  Incidentally, if I change the condition to "not equals 2988" the background changes to green. The line in the code view of Designer appears as follows:  <xsl:if test="../../../Rows/Row/@ID = '2988'">background-color: #00FF00;</xsl:if> I've seen this question asked here and in blogs but never answered.  If anyone has a solution, I would love to know what it is. Thanks; Dave  UPDATE:  it doesn't seem to matter if you add the additional fields as a joined subview or not.  If I add 2 data views, both using the linked data source which is configured to JOIN the contents of the data sources the conditional formatt

Sharepoint Designer - Conditional Formatting Problem


I've been creating some basic conditional formatting scenarios using Designer ... but I'm very new to this and need help with two topics that I can't get to work.

Problem 1:

When my condition criteria is met I want to display a graphic in the background, but the left of the actual text for that column. 

Example: I have a list of orders and when the priority column says rush, I want to display a small graphic to the left of the text for that column and shift the text to the right by the width of the 40 pixel graphic.  I've looked through all the different settings in the "modify style" dialog box and have used trial and error, but the darn graphic keeps displaying behind the text only. UGH!  I've been working on this for 2 hours now and can't figure it out. 

Can someone tell me what parameters to set so the text is shifted to the right 40 pixels so the background that is left justified is visible?


Problem 2:  

In this case, I can't figure out how to write the formula to tell   If  [DUE DATE] is less then 5 days from today I want the background cell to change color. I know how to change the color, but can't figure out the formula for the life of me.  Can someone give me the formula? 

Here's what I tried using in the xpath advanced

Sharepoint Designer 2010 - How to add custom columns to lists



When creating a new view - I would like to add an extra column which I could use as a custom hyperlink to fire up the EditForm.aspx or my on custom ediform.  I would like it.  Is there a step by step that shows hwo to do wthis with SP 2010 and SPD 2010?

Thanks in advance



SharePoint Calculated Columns with Conditional Formatting

I am working on a custom list in SharePoint 2007. I have a calculated column that is formatted as a percentage. When opened in SP Designer and converted to a XSLT data view to apply conditional formatting, the column is rendered as text and not numeric which is a known issue with SharePoint. How can I apply formatting to this column and render it as a numeric value? My conditional formatting relies on If x is <= y then apply yellow and so forth so it has to be read as a numeric value. I have attached the conditional formatting code as well as the format of the data property. Any help would be appreciated.
<TD Class="{$IDAS4QMC}">
																<xsl:attribute name="style">
		<xsl:if test="@_x0025__x0020_Variance_x0020_C &gt; '-.11' and @_x0025__x0020_Variance_x0020_C &lt;= '0'">background-color: #00FF00;</xsl:if>
		<xsl:if test="@_x0025__x0020_Variance_x0020_C &gt;= '.1'">background-color: #FF0000;</xsl:if>
		<xsl:if test="@_x0025__x0020_Variance_x0020_C &lt; '-.11' or @_x0025__x0020_Variance_x0020_C &gt; '0'">background-color: #FFFF00;</xsl:if>
		<xsl:if test="@_x0025__x0020_Variance_x0020_C &gt;= '-.11' an

How to create scrolling table for columns in a SharePoint Designer Data View


I have a fairly complex SharePoint Designer 2007 Data View they have added two more requirements.

1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place.  This is only one list not two, and because of some other requirements I have it must remain to be just one list.

2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.

The first requirement is more important than the second, but preferrably I need to do both.

I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?

I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.

So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/  or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png

I failed to mention that 3/4 of the columns are HTML Calculated fields wh

How to use display Text in Hyperlink For SharePoint 2010 Designer Workflow


In SharePoint 2007 Designer, I have used the Hyperlink column to store the link "http://www.sharepoint.com/Default.aspx, Details". The details text will be shown in the Hyperlink column. Everything works fine in sharepoint 2007 Designer workflow.

In SharePoint Designer 2010 Workflow, I used the same method but the hyperlink column is displaying the full text "http://www.sharepoint.com/Default.aspx, Details" instead of only Details


Creating SharePoint Server 2010 External Content Type Associations with SharePoint Designer 2010

Learn how to use Business Connectivity Services (BCS) to create associations between external content types in SharePoint Designer 2010 without using code.

Quick Note: Using SharePoint Designer 2010 to Work with Web Parts

Learn to create an XSLT List View Web Part within SharePoint Designer 2010 that displays a list of employees on the Home page of local web site.

Microsoft SharePoint Designer 2010 Beta (32-bit) - Now Available!

Using SharePoint 2010 Designer, advanced users and developers alike can rapidly create SharePoint solutions in response to business needs. In addition, developers can use SharePoint Designer 2010 to get a quick start on SharePoint development projects.

Microsoft SharePoint Designer 2010 Beta (64-bit) - Now Available!

Using SharePoint 2010 Designer, advanced users and developers alike can rapidly create SharePoint solutions in response to business needs. In addition, developers can use SharePoint Designer 2010 to get a quick start on SharePoint development projects.

Video: Microsoft Visio 2010 and Microsoft SharePoint Designer 2010 Workflow

Learn the specific roles Visio 2010 and SharePoint Designer 2010 play in the development process and how these tools can be used in concert to create a workflow. (Length: 13:22)

Video: Creating Workflows in SharePoint Designer 2010

This demonstration shows how to create a powerful list workflow with code-style logic by using SharePoint Designer 2010. (Length: 8:15)

WPF Designer (in VS 2008 and VS 2010) crashes with Visual Studio

Good day all. I have the following question: WPF designer in both VS 2008 and VS 2010 crashes with Visual Studio when I try to edit UI form. Moreover, it crashes even when I try to save .xaml.cs file. Meanwhile, Winforms and Dataset UI editors work as usual. Are there other people met this issue? And how could I fix up this problem? Deleting the .suo file, uninstalling silverlight, repairing visual studio, and further googling did not help me. Thanks in advance.

VS 2010 Designer InvalidOperationException after using Blend 4 VSM

Working on an WPF 4 app today and noticed the VS 2010 Designer won't load after using Blend 4 Visual State Manager. Basic info that I did. 1. Had a Button.  Would display in both VS10 Designer and Blend 4. 2. In Blend 4, I right clicked Button -> Edit Template -> Create Empty. 3. Added ContentPresenter to Grid. 4. Back in Window.xaml, added Image to Button's ContentPresenter.  Still works in both VS10 and Blend 4. 5. In Blend 4, went back to Edit Template and modified some of the States.     - Disabled: Grid Opacity 50%     - MouseOver: Grid Scale X/Y to 1.1     - Pressed: Grid Angle 15. 6. Save and go back to VS10, the designer won't load.  Get the Yellow bar at top stating something like... InvalidOperationException was thrown on "button": Property does not point to a DependencyObject in path...... The button now has an X with red circle in it. Is this a know issue?  Is there a fix? It still works in Blend 4 and I can run the WPF app in both VS10 and Blend 4. Thanks in advance.

gridview help on each dynamic row solve this show values based on all columns

<asp:GridView style="Z-INDEX: 101; LEFT: 1px; POSITION: absolute; TOP: 183px" id="Gridview1" runat="server" Width="613px" Height="127px" ForeColor="Teal" Font-Size="12pt" Font-Names="Palatino Linotype" Font-Bold="True" Visible="False" BorderColor="Transparent" AutoGenerateColumns="false" CellSpacing="2" GridLines="None" OnRowCreated="Gridview1_RowCreated" SelectedIndex="5" ShowFooter="true" OnRowDataBound="Gridview1_RowDataBound"><Columns>  <asp:TemplateField HeaderText="ItemCode"><ItemTemplate> <asp:DropDownList id="DropDownList1" tabIndex=16 runat="server" AutoPostBack="True" DataValueField=" ItemCode " DataTextField=" ItemCode" ></asp:DropDownList></ItemTemplate></asp:TemplateField>  <asp:TemplateField HeaderText="ItemName"><ItemTemplate> <asp:DropDownList id="DropDownList2" tabIndex=16 runat="server" AutoPostBack="True" DataValueField="ItemName" DataTextField="ItemName" ></asp:DropDownList> </ItemTemplate> </asp:TemplateField>  <asp:TemplateField HeaderText="Category"&

Use Dashboard designer in Sharepoint Foundation 2010

Hi, I want to Install Dashboard Designer in Sharepoint Foundation 2010(WSS 4). I can only find articles on insatllation in Sharepoint Server 2010..like this one.. http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx?wa=wsignin1.0 Can you please let me know how I can use Performance Point in Sharepoint Foundation?   Thanks  

How to get User group in SharePoint Designer 2010 within workflow?

Hi, How to get user group in sharepoint designer within workflow? Basically I have to compair that current user is belongs to particular group or not.  How can I get check user group in workflow's if condition? G. Goyal
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