http://forums.method.me/cs/search/SearchResults.aspx?o=DateDescending&u=12749Search results by user ID 12749en-USCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/p/12079/35373.aspx#35373Mon, 17 Jul 2017 18:28:47 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:35373mraley<p><span id="mce_0_start" style="overflow:hidden;">Thank you...worked perfect. I knew it was something I missed.</span></p>http://forums.method.me/cs/forums/p/12079/35371.aspx#35371Mon, 17 Jul 2017 16:09:51 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:35371mraley<p><span id="mce_0_start" style="overflow:hidden;"><span id="mce_1_start" style="overflow:hidden;">Is there </span><span id="mce_1_end" style="overflow:hidden;"></span>anybody... <span id="mce_3_start" style="overflow:hidden;"></span>out there<span id="mce_2_start" style="overflow:hidden;">?</span></span></p>http://forums.method.me/cs/forums/p/12079/35368.aspx#35368Mon, 10 Jul 2017 22:40:29 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:35368mraley<p><span id="mce_0_start" style="overflow:hidden;">I am looking for the SQL code to set a font color in an ActivityStatus field that is rendering in a grid.</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>If the activity is set to &quot;Not Started&quot; then it should show in the grid red</p> <p>If the activity is set to &quot;Completed&quot; then it should show in the grid green<span id="mce_1_start" style="overflow:hidden;"></span></p> <p><span id="mce_1_start" style="overflow:hidden;"></span><span id="mce_4_start" style="overflow:hidden;">In the advanced properties of the column ActivityStatus (alias: Status) </span>I entered the folowing but get a<span id="mce_5_start" style="overflow:hidden;">n</span> error generating grid</p> <p>CASE WHEN <span id="mce_3_start" style="overflow:hidden;">viewActivity.</span>ActivityStatus = &#39;Not Started&#39; THEN &#39;&lt;font color=&quot;red&quot;&gt;&lt;b&gt;&#39; + <span id="mce_0_start" style="overflow:hidden;"></span><span id="mce_1_start" style="overflow:hidden;"></span><span id="mce_2_start" style="overflow:hidden;">ActivityStatus</span> + &#39;&lt;/b&gt;&lt;/font&gt;&#39; WHEN <span id="mce_2_start" style="overflow:hidden;">viewActivity.</span>ActivityStatus = &#39;Completed&#39; THEN &#39;&lt;font color=&quot;green&quot;&gt;&lt;b&gt;&#39; +<span id="mce_6_start" style="overflow:hidden;"></span> ActivityStatus + &#39;&lt;/b&gt;&#39; ELSE &#39;&lt;font color=&quot;black&quot;&gt;&#39; + Entity + &#39;&lt;/font&gt;&#39; END)<span id="mce_6_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;"><br /></span></p> <p><span style="overflow:hidden;"><span id="mce_10_start" style="overflow:hidden;"></span><span id="mce_0_start" style="overflow:hidden;"></span><span id="mce_9_start" style="overflow:hidden;"></span><span id="mce_8_start" style="overflow:hidden;"></span><span id="mce_7_start" style="overflow:hidden;"></span><span id="mce_6_start" style="overflow:hidden;"></span><span id="mce_5_start" style="overflow:hidden;"></span><span id="mce_4_start" style="overflow:hidden;"></span><span id="mce_3_start" style="overflow:hidden;"></span><span id="mce_2_start" style="overflow:hidden;"></span><span id="mce_1_start" style="overflow:hidden;"></span><br /></span></p>