<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/atom10full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><feed xmlns="http://www.w3.org/2005/Atom" xmlns:openSearch="http://a9.com/-/spec/opensearch/1.1/" xmlns:georss="http://www.georss.org/georss" xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr="http://purl.org/syndication/thread/1.0" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" gd:etag="W/&quot;DEQER3Yyeyp7ImA9WhRaGU4.&quot;"><id>tag:blogger.com,1999:blog-10550379</id><updated>2012-02-22T13:45:06.893-05:00</updated><category term="install" /><category term="google+" /><category term="building a build process" /><category term="IO APIC" /><category term="keyboard shortcuts" /><category term="sysadmin" /><category term="phones" /><category term="Business Objects XI" /><category term="bug" /><category term="development" /><category term="hashes" /><category term="crystal" /><category term="cleanliness" /><category term="technique" /><category term="IEZoneAnalyzer" /><category term="10.10" /><category term="disk" /><category term="settings" /><category term="odbc" /><category term="wmata" /><category term="windows 7" /><category term="troubleshooting" /><category term="SAP" /><category term="encryption" /><category term="queries" /><category term="Robocopy" /><category term="iphone" /><category term="tls" /><category term="rdp" /><category term="printer" /><category term="lies" /><category term="tide to go" /><category term="parking" /><category term="grocery list" /><category term="shared variables" /><category term="packages" /><category term="business" /><category term="reports" /><category term="fields" /><category term="security" /><category term="CentOS" /><category term="success" /><category term="VDI" /><category term="brute force" /><category term="apt" /><category term="plain english" /><category term="Nerd toys" /><category term="joy" /><category term="ideas" /><category term="links" /><category term="oracle" /><category term="707" /><category term="crystal reports 2008" /><category term="beta" /><category term="suppress" /><category term="build" /><category term="opinion" /><category term="notepad++" /><category term="collapsed section" /><category term="errors" /><category term="database connection" /><category term="Microsoft Outlook" /><category term="remote desktop" /><category term="tomcat 6.0" /><category term="Internet Explorer" /><category term="crystal reports" /><category term="ubuntu" /><category term="error" /><category term="SOPA" /><category term="google" /><category term="Excel" /><category term="legislation" /><category term="virtualization" /><category term="datasource" /><category term="formulas" /><category term="google chat" /><category term="suppression" /><category term="VirtualBox" /><category term="passwords" /><category term="SQL Server" /><category term="investments" /><category term="maverick" /><category term="tomcat" /><category term="preferences" /><category term="business intelligence" /><category term="tables" /><category term="background send" /><category term="chat" /><category term="windows" /><category term="suntrust; good experiences; auto; customer service" /><category term="google apps; google; governance; google docs; permissions; questions" /><category term="group names" /><category term="business objects" /><category term="whining" /><category term="database" /><category term="tlsv1" /><category term="presentations" /><category term="observation" /><category term="powerpoint" /><category term="gtd" /><category term="HP" /><category term="tech" /><category term="Microsoft Office" /><category term="extensions" /><category term="stored procedures" /><category term="feldthoughts" /><category term="personal" /><category term="howto" /><category term="politics" /><category term="views" /><category term="subreports" /><category term="refresh" /><category term="backups" /><category term="lifehacker" /><category term="issue" /><category term="SAP BusinessObjects XI" /><category term="desktop computer" /><category term="google chrome" /><category term="tip" /><category term="Field Notes" /><category term="BO" /><category term="data types" /><category term="sql" /><category term="wireless" /><category term="food" /><category term="trick" /><category term="battery life" /><category term="server" /><category term="IE" /><category term="web site" /><category term="social media" /><category term="mail checker plus" /><category term="brad feld" /><category term="pipa" /><category term="questions" /><category term="gmail" /><title>SeanKilleen.com</title><subtitle type="html">Ramblings on Life and Bytes From a Digital Twenty-Something</subtitle><link rel="http://schemas.google.com/g/2005#feed" type="application/atom+xml" href="http://www.seankilleen.com/feeds/posts/default" /><link rel="alternate" type="text/html" href="http://www.seankilleen.com/" /><link rel="next" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default?start-index=26&amp;max-results=25&amp;redirect=false&amp;v=2" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><generator version="7.00" uri="http://www.blogger.com">Blogger</generator><openSearch:totalResults>65</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/atom+xml" href="http://feeds.feedburner.com/Seankilleencom" /><feedburner:info uri="seankilleencom" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><entry gd:etag="W/&quot;DEUEQ30-fSp7ImA9WhRaGU4.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-6497741831094467800</id><published>2012-02-22T13:43:00.000-05:00</published><updated>2012-02-22T13:43:22.355-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-02-22T13:43:22.355-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="Internet Explorer" /><category scheme="http://www.blogger.com/atom/ns#" term="IE" /><category scheme="http://www.blogger.com/atom/ns#" term="howto" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="security" /><category scheme="http://www.blogger.com/atom/ns#" term="IEZoneAnalyzer" /><title>How To: Compare Two Sets of Internet Explorer Security Settings [Field Notes]</title><content type="html">&lt;span style="font-size: large;"&gt;&lt;b&gt;The Problem&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
A web application doesn't work correctly for a user, and from the description of the issue I think it might have to do with security settings. The application works fine for me.&lt;br /&gt;
&lt;br /&gt;
How do I see what settings I have that the user doesn't?&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;The Solution&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
Enter &lt;a href="http://blogs.msdn.com/b/aaron_margosis/" target="_blank"&gt;Aaron Margosis&lt;/a&gt;'s excellent &lt;a href="http://blogs.technet.com/b/fdcc/archive/2011/09/22/iezoneanalyzer-v3-5-with-zone-map-viewer.aspx" target="_blank"&gt;IEZoneAnalyzer utility&lt;/a&gt;. It allows you to do just that: view, export, and compare Internet Explorer Zone settings.&lt;br /&gt;
&lt;br /&gt;
The steps I generally use are below:&lt;br /&gt;
&lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;&lt;b&gt;Download the utility&lt;/b&gt;: visit the &lt;a href="http://blogs.technet.com/b/fdcc/archive/2011/09/22/iezoneanalyzer-v3-5-with-zone-map-viewer.aspx" target="_blank"&gt;IEZoneAnalyzer 3.5 page&lt;/a&gt;, or use &lt;a href="http://blogs.technet.com/cfs-file.ashx/__key/communityserver-components-postattachments/00-03-45-50-87/IEZoneAnalyzer.3.5.0.3.zip" target="_blank"&gt;this direct download link&lt;/a&gt; (from the page).&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Unzip the utility&lt;/b&gt;: It is a standalone .exe file; no installation necessary.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Run the utility&lt;/b&gt;. It will analyze some things as it starts up.&lt;/li&gt;
&lt;li&gt;From the &lt;i&gt;File&lt;/i&gt;&amp;nbsp;menu, select &lt;i&gt;Export Local Settings...&lt;/i&gt;&amp;nbsp;and save under the filename of your choosing.&lt;/li&gt;
&lt;li&gt;I usually then repeat this process on my machine so I have a snapshot to compare it to.&lt;/li&gt;
&lt;li&gt;From the &lt;i&gt;File &lt;/i&gt;menu, select &lt;i&gt;Import saved Settings...&lt;/i&gt;&amp;nbsp;and select the file with the snapshot. Repeat this for the user's snapshot and your own. &lt;b&gt;Pro Tip: &lt;/b&gt;You can use CTRL+Click to select multiple files to import.&lt;/li&gt;
&lt;li&gt;Under the "View / Compare Entire Collections of Settings" section, select your settings and click the &lt;i&gt;Add Set to Comparison List&lt;/i&gt; button. Repeat the process for the user's settings.&lt;/li&gt;
&lt;li&gt;Click the &lt;i&gt;View/Compare Sets&lt;/i&gt;&amp;nbsp;button.&lt;/li&gt;
&lt;/ol&gt;
&lt;div&gt;
At this point, the program will pop up a window with all the different zone settings, and any differences will be highlighted in yellow. You can export to CSV or Excel at this point.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
And that's it! Thank you to Aaron for providing such an excellent utility.&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-6497741831094467800?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/eSZYragz7D_hqB85T3sGXpWD7tE/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/eSZYragz7D_hqB85T3sGXpWD7tE/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/eSZYragz7D_hqB85T3sGXpWD7tE/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/eSZYragz7D_hqB85T3sGXpWD7tE/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/6fqAeQt-fnQ" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/6497741831094467800/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/02/how-to-compare-two-sets-of-internet.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6497741831094467800?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6497741831094467800?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/6fqAeQt-fnQ/how-to-compare-two-sets-of-internet.html" title="How To: Compare Two Sets of Internet Explorer Security Settings [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/02/how-to-compare-two-sets-of-internet.html</feedburner:origLink></entry><entry gd:etag="W/&quot;DEQGQn05eip7ImA9WhRbGUQ.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-4826145692433375217</id><published>2012-02-11T16:38:00.001-05:00</published><updated>2012-02-11T16:38:43.322-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-02-11T16:38:43.322-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="sql" /><category scheme="http://www.blogger.com/atom/ns#" term="data types" /><category scheme="http://www.blogger.com/atom/ns#" term="howto" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="database" /><category scheme="http://www.blogger.com/atom/ns#" term="oracle" /><title>How To: Convert an Oracle FLOAT Value to A Time Span [Field Notes]</title><content type="html">&lt;span style="font-size: large;"&gt;&lt;b&gt;The Problem&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
We have a bunch of "durations" stored in Oracle as FLOAT datatypes (as day intervals, meaning they are an interval that includes days).&lt;br /&gt;
&lt;br /&gt;
This makes sense. from a database storage perspective. However, I didn't know how to get those values into the more human-comprehensible hh:mm:ss format.&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;The Solution&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
An Oracle function called &lt;b&gt;NUMTODSINTERVAL&lt;/b&gt;&amp;nbsp;is exactly what we need here. As the name suggests, it converts a number to a DateStamp interval (which is to say, interprets a number as a time span). We can tell it the type of time span (days in this case), and then extract the appropriate time values.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Syntax:&amp;nbsp;&lt;/b&gt;NUMTODSINTERVAL ([&lt;i&gt;yourvalue]&lt;/i&gt;, '&lt;i&gt;[typeofinterval]&lt;/i&gt;')&lt;br /&gt;
&lt;b&gt;Basic Example:&lt;/b&gt;&amp;nbsp;NUMTODSINTERVAL (tablename.durationfield, 'DAY')&lt;br /&gt;
The above example takes my field named 'durationfield' and tells oracle it's a DAY interval.&lt;br /&gt;
&lt;br /&gt;
From here, we use the &lt;b&gt;EXTRACT&lt;/b&gt;&amp;nbsp;function to get what we want.&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;Solution Examples&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;Gets the number of hours (and converts all day values to 24 hours each):&lt;/b&gt;&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
EXTRACT(DAY FROM NUMTODSINTERVAL(TABLENAME.DURATIONFIELD, 'DAY')) * 24&lt;br /&gt;+ EXTRACT(HOUR FROM NUMTODSINTERVAL(
TABLENAME.DURATIONFIELD&amp;nbsp;, 'DAY'))&amp;nbsp;&lt;/blockquote&gt;
&lt;blockquote class="tr_bq"&gt;
AS DURATIONHOURS&lt;/blockquote&gt;
&lt;br /&gt;
&lt;b&gt;Gets the minutes in the same fashion:&lt;/b&gt;&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
EXTRACT(MINUTE FROM NUMTODSINTERVAL(
TABLENAME.DURATIONFIELD&amp;nbsp;, 'DAY')) &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp;&lt;/blockquote&gt;
&lt;blockquote class="tr_bq"&gt;
AS DURATIONMINUTES&lt;/blockquote&gt;
&lt;br /&gt;
&lt;b&gt;Gets the seconds in the same fashion:&lt;/b&gt;&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
EXTRACT(SECOND FROM NUMTODSINTERVAL(
TABLENAME.DURATIONFIELD, 'DAY')) &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&lt;br /&gt;AS DURATIONSECONDS&lt;/blockquote&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-4826145692433375217?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/Ijs6IL0SWG7LgrLjtUb5CuY_QBI/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Ijs6IL0SWG7LgrLjtUb5CuY_QBI/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/Ijs6IL0SWG7LgrLjtUb5CuY_QBI/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Ijs6IL0SWG7LgrLjtUb5CuY_QBI/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/b1zBj0YPKk4" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/4826145692433375217/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/02/how-to-convert-oracle-float-value-to.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4826145692433375217?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4826145692433375217?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/b1zBj0YPKk4/how-to-convert-oracle-float-value-to.html" title="How To: Convert an Oracle FLOAT Value to A Time Span [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/02/how-to-convert-oracle-float-value-to.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEIMR3s8fSp7ImA9WhRbFkg.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-6355671627815051575</id><published>2012-02-07T11:32:00.002-05:00</published><updated>2012-02-07T17:09:46.575-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-02-07T17:09:46.575-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="sql" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="trick" /><category scheme="http://www.blogger.com/atom/ns#" term="oracle" /><title>SQL Tricks: The Not-Equals Join [Field Notes]</title><content type="html">&lt;span style="font-size: large;"&gt;&lt;b&gt;The Problem&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
I needed to pull back a list of dates in a certain range for each employee, but didn't have a common join criteria, as I wanted all the dates but they did not come from a table.&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;The Solution&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
I knew that the dates would never equal the employee name, so in this case, I could actually use a "not-equal" join to connect the two. I always forget about this one, but it's handy.&lt;br /&gt;
&lt;br /&gt;
I did something along the following (edited for brevity):&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;i&gt;select &amp;nbsp;* from (...) ActiveLabor left outer join (...)DateRange on (activelabor.laborcode != to_char(DateRange.DateItem))&lt;/i&gt;&lt;/blockquote&gt;
&lt;br /&gt;
This allows the left outer join only if the items are not equal (which we happen to know will always be the case).&lt;br /&gt;
&lt;br /&gt;
The end result? As I expected -- the full list of dates showed up for each employee, just as I'd hoped.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;A Note:&amp;nbsp;&lt;/b&gt;Because I was comparing a date to a string, I had to cast the date as a varchar2 in the join statement. The date value itself still comes back as a date, but during the comparison we need to make sure we're giving Oracle an apples-to-apples comparison.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-6355671627815051575?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/6UtWgWnpoqFzX9bW1yEyfkhvYE4/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/6UtWgWnpoqFzX9bW1yEyfkhvYE4/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/6UtWgWnpoqFzX9bW1yEyfkhvYE4/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/6UtWgWnpoqFzX9bW1yEyfkhvYE4/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/pNjq_Rg4xAw" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/6355671627815051575/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/02/sql-tricks-not-equal-join-field-notes.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6355671627815051575?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6355671627815051575?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/pNjq_Rg4xAw/sql-tricks-not-equal-join-field-notes.html" title="SQL Tricks: The Not-Equals Join [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/02/sql-tricks-not-equal-join-field-notes.html</feedburner:origLink></entry><entry gd:etag="W/&quot;Dk4AQnw9eCp7ImA9WhRbFUo.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-4954149254293952868</id><published>2012-02-06T19:35:00.000-05:00</published><updated>2012-02-06T19:35:43.260-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-02-06T19:35:43.260-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="personal" /><category scheme="http://www.blogger.com/atom/ns#" term="grocery list" /><category scheme="http://www.blogger.com/atom/ns#" term="food" /><title>February 6, 2012 [The Grocery List]</title><content type="html">Stopped by Giant and picked up:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Baby bella mushrooms&lt;/li&gt;
&lt;li&gt;Peppers (assorted red, green, yellow)&lt;/li&gt;
&lt;li&gt;2 Peaches&lt;/li&gt;
&lt;li&gt;6 apples&lt;/li&gt;
&lt;li&gt;A spaghetti squash (god, I love that spaghetti squash)&lt;/li&gt;
&lt;li&gt;Spinach&lt;/li&gt;
&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-4954149254293952868?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/NQFwUrZqMVO-GtZh7lGrMaQAOHc/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/NQFwUrZqMVO-GtZh7lGrMaQAOHc/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/NQFwUrZqMVO-GtZh7lGrMaQAOHc/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/NQFwUrZqMVO-GtZh7lGrMaQAOHc/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/UmRezbXuOGU" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/4954149254293952868/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/02/february-6-2012-grocery-list.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4954149254293952868?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4954149254293952868?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/UmRezbXuOGU/february-6-2012-grocery-list.html" title="February 6, 2012 [The Grocery List]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/02/february-6-2012-grocery-list.html</feedburner:origLink></entry><entry gd:etag="W/&quot;DkcEQXo-fyp7ImA9WhRbFUs.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-4308924140012419930</id><published>2012-02-06T16:33:00.000-05:00</published><updated>2012-02-06T16:33:20.457-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-02-06T16:33:20.457-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="howto" /><category scheme="http://www.blogger.com/atom/ns#" term="tech" /><category scheme="http://www.blogger.com/atom/ns#" term="oracle" /><title>How To: List all Dates for sysdate +/- 30 in Oracle</title><content type="html">Discovered an answer to &lt;a href="http://stackoverflow.com/q/9166877/316847" target="_blank"&gt;a StackOverflow question I'd posted&lt;/a&gt;, and wanted to share.&lt;br /&gt;
&lt;br /&gt;
I needed to, within a view, dynamically generate a list of dates before or after sysdate. I wanted to do this so that I could limit some of the records coming back (we have millions but the date range will always be between 31 days before sysdate or 31 says after.&lt;br /&gt;
&lt;br /&gt;
In Oracle, the SQL to do this is as follows:&lt;br /&gt;
&lt;br /&gt;
&lt;pre class="lang-sql prettyprint" style="background-attachment: initial; background-clip: initial; background-color: white; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; line-height: 18px; margin-bottom: 10px; max-height: 600px; overflow-x: auto; overflow-y: auto; padding-bottom: 5px; padding-left: 5px; padding-right: 5px; padding-top: 5px; text-align: left; vertical-align: baseline; width: auto;"&gt;&lt;code style="background-attachment: initial; background-clip: initial; background-color: #eeeeee; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;SELECT&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; &lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;*&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;
&lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;FROM&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; &amp;nbsp; &lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;(&lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;SELECT&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; TRUNC&lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;(&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;SYSDATE &lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;-&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; ROWNUM&lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;)&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; DateItem
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;FROM&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; &amp;nbsp; DUAL
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONNECT &lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;BY&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; ROWNUM &lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&amp;lt;&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; &lt;/span&gt;&lt;span class="lit" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: maroon; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;32&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;UNION&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;SELECT&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; TRUNC&lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;(&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;SYSDATE &lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;+&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; ROWNUM&lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;)&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; DateItem
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;FROM&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; &amp;nbsp; DUAL
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; CONNECT &lt;/span&gt;&lt;span class="kwd" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: darkblue; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;BY&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; ROWNUM &lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;&amp;lt;&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; &lt;/span&gt;&lt;span class="lit" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; color: maroon; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;32&lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;)&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;DATERANGE&lt;/span&gt;&lt;span class="pun" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt;;&lt;/span&gt;&lt;span class="pln" style="background-attachment: initial; background-clip: initial; background-color: transparent; background-image: initial; background-origin: initial; border-bottom-width: 0px; border-color: initial; border-image: initial; border-left-width: 0px; border-right-width: 0px; border-style: initial; border-top-width: 0px; margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0px; padding-bottom: 0px; padding-left: 0px; padding-right: 0px; padding-top: 0px; vertical-align: baseline;"&gt; &lt;/span&gt;&lt;/code&gt;&lt;/pre&gt;
This SQL does the following:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Uses the dual table (a special table in Oracle as I understand) to scroll through x amount of rows (in this case, 32, because we want to make sure it includes 31 days)&lt;/li&gt;
&lt;li&gt;For each of those, it returns the sysdate - the number of rows, or sysdate + the number of rows in the case of the second query. It calls this column "DT".&lt;/li&gt;
&lt;li&gt;It unions those two queries together, to give the full range of values. This also has the nice effect of removing duplicate dates from the results.&lt;/li&gt;
&lt;li&gt;I then wrap it in a select * statement so I can call it what I want and refer to it later.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
Learning Oracle as I go, and I'm enjoying discovering these little tricks.&lt;/div&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-4308924140012419930?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/GRyWQ4VYSNWcADOqj9AHukIKzjM/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/GRyWQ4VYSNWcADOqj9AHukIKzjM/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/GRyWQ4VYSNWcADOqj9AHukIKzjM/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/GRyWQ4VYSNWcADOqj9AHukIKzjM/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/htRBB-MbMRk" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/4308924140012419930/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/02/how-to-list-all-dates-for-sysdate-30-in.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4308924140012419930?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4308924140012419930?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/htRBB-MbMRk/how-to-list-all-dates-for-sysdate-30-in.html" title="How To: List all Dates for sysdate +/- 30 in Oracle" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/02/how-to-list-all-dates-for-sysdate-30-in.html</feedburner:origLink></entry><entry gd:etag="W/&quot;C0ECR3wyeyp7ImA9WhRbEk4.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-8411346152470816539</id><published>2012-02-02T20:14:00.002-05:00</published><updated>2012-02-02T20:14:26.293-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-02-02T20:14:26.293-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports 2008" /><category scheme="http://www.blogger.com/atom/ns#" term="tech" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports" /><title>How To: Swap Views/Tables Within the Same Database Using Crystal Reports 2008 Designer [Field Notes]</title><content type="html">&lt;span style="font-size: large;"&gt;&lt;b&gt;Background&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
I have a database with a few different views. They all return the same fields in copies of the same exact report, but those fields are calculated differently (hence the views).&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;The Problem&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
I wanted to be able to swap these views out without losing my fields, but couldn't seem to find a way to do it.&lt;br /&gt;
&lt;br /&gt;
Crystal has a method for changing data sources, and for setting tables up to be overridden in this way, but there didn't seem to be any way to swap out a view that was already in the same database.&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;The Solution&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;b&gt;NOTE:&lt;/b&gt; The solution below depends on the fact that your new tables or views should be returning the exact same fields (the new one can have additional fields, but not vice versa, which makes sense).&lt;br /&gt;
&lt;br /&gt;
After some playing around, I figured it out. The best solution I've been able to come up with is:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;While in your report, right-click on the &lt;i&gt;Database Explorer&lt;/i&gt;&amp;nbsp;and select &lt;i&gt;Set Datasource Location.&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;In the bottom pane, select the datasource from your list as if it is a new datasource.&lt;/li&gt;
&lt;li&gt;In the bottom pane, navigate to the table or view you'd like to replace.&lt;/li&gt;
&lt;li&gt;In the top pane, click the table or view you'd like to replace.&lt;/li&gt;
&lt;li&gt;In the bottom pane, click the table or view you'd like to replace the original table/view.&lt;/li&gt;
&lt;li&gt;Click &lt;i&gt;Update.&lt;/i&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
This will work, but it will appear to fail. That's because &lt;b&gt;Crystal Reports keeps the same alias in its list of datasources.&lt;/b&gt; To double-check this, you can go select &lt;i&gt;Show Query...&lt;/i&gt;&amp;nbsp;from the &lt;i&gt;Database &lt;/i&gt;menu and you'll be able to see that the SQL is just covering up your new data source with the old alias name.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
This might be fine for some folks, but it drives me up a wall. To fix that issue and get the names back in sync:&lt;/div&gt;
&lt;div&gt;
&lt;ul&gt;
&lt;li&gt;Right-click on the database and select&amp;nbsp;&lt;i&gt;Database Explorer&lt;/i&gt;.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;In the panel on the right, right-click the improperly named datasource and select "Rename".&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Enter the name of the table or view it is currently pointing to.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
At this point, you'll have successfully completed the swap, with all your report fields making it out alive.&lt;/div&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-8411346152470816539?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/KDgd20O7PYaddyZZfI6VGOcCtKA/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/KDgd20O7PYaddyZZfI6VGOcCtKA/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/KDgd20O7PYaddyZZfI6VGOcCtKA/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/KDgd20O7PYaddyZZfI6VGOcCtKA/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/IXbDrXsxfuY" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/8411346152470816539/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/02/how-to-swap-viewstables-within-same.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/8411346152470816539?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/8411346152470816539?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/IXbDrXsxfuY/how-to-swap-viewstables-within-same.html" title="How To: Swap Views/Tables Within the Same Database Using Crystal Reports 2008 Designer [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/02/how-to-swap-viewstables-within-same.html</feedburner:origLink></entry><entry gd:etag="W/&quot;AkAHRH86fip7ImA9WhRbEEQ.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-355283874602639839</id><published>2012-02-01T07:18:00.004-05:00</published><updated>2012-02-01T07:18:55.116-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-02-01T07:18:55.116-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="personal" /><category scheme="http://www.blogger.com/atom/ns#" term="grocery list" /><category scheme="http://www.blogger.com/atom/ns#" term="food" /><title>January 31, 2012 [The Grocery List]</title><content type="html">&lt;i&gt;[A &lt;a href="http://www.seankilleen.com/2012/01/new-tradition-grocery-list-grocery-list.html" target="_blank"&gt;new tradition&lt;/a&gt; where I keep myself honest by posting the things I buy at the grocery store.]&lt;/i&gt;&lt;br /&gt;
&lt;br /&gt;
Picked up from Giant:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;6 Apples&lt;/li&gt;
&lt;li&gt;1 spaghetti squash&lt;/li&gt;
&lt;li&gt;Asiago cheese&lt;/li&gt;
&lt;li&gt;Razors&lt;/li&gt;
&lt;li&gt;Shower cleaner&lt;/li&gt;
&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-355283874602639839?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/0gcKKpcs8jaq612Vt9-4yp1Sn-I/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/0gcKKpcs8jaq612Vt9-4yp1Sn-I/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/0gcKKpcs8jaq612Vt9-4yp1Sn-I/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/0gcKKpcs8jaq612Vt9-4yp1Sn-I/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/IBQJnnPmjtc" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/355283874602639839/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/02/january-31-2012-grocery-list.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/355283874602639839?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/355283874602639839?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/IBQJnnPmjtc/january-31-2012-grocery-list.html" title="January 31, 2012 [The Grocery List]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/02/january-31-2012-grocery-list.html</feedburner:origLink></entry><entry gd:etag="W/&quot;DE8HR38-eSp7ImA9WhRbEEs.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-2502650798757648561</id><published>2012-01-31T22:27:00.001-05:00</published><updated>2012-01-31T22:27:16.151-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-01-31T22:27:16.151-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="google+" /><category scheme="http://www.blogger.com/atom/ns#" term="tech" /><category scheme="http://www.blogger.com/atom/ns#" term="social media" /><category scheme="http://www.blogger.com/atom/ns#" term="google" /><category scheme="http://www.blogger.com/atom/ns#" term="observation" /><title>Crafty, Google+. Very Crafty.</title><content type="html">A quick observation: on most social networks (LinkedIn, Facebook, etc.) you'll see the option to connect with folks that you know.&lt;br /&gt;
&lt;br /&gt;
Google+ applies this intuitive concept, but with a twist to its own benefit.&lt;br /&gt;
&lt;br /&gt;
On the right-hand side of the Google+ home page, I noticed the option to add folks, and (wrongly) made the quick assumption that these folks are already on the network, despite the fact that some buttons are instead labeled "Add and Invite". Picture below:&lt;br /&gt;
&lt;br /&gt;
&lt;table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style="text-align: center;"&gt;&lt;a href="http://4.bp.blogspot.com/-LWSelM0OzjQ/TyiwBFrb0yI/AAAAAAAABB8/IrxWxNTQ4M4/s1600/2012-01-31_ss_GPlus_AddAndInvite.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"&gt;&lt;img border="0" height="320" src="http://4.bp.blogspot.com/-LWSelM0OzjQ/TyiwBFrb0yI/AAAAAAAABB8/IrxWxNTQ4M4/s320/2012-01-31_ss_GPlus_AddAndInvite.png" width="225" /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class="tr-caption" style="text-align: center;"&gt;Notice the difference? You might not at first glance.&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
It's not the end of the world or anything, but if G+ just duped me into inviting 10+ people unwittingly, it likely has gotten &lt;i&gt;many &lt;/i&gt;more sign-ups this way.&lt;br /&gt;
&lt;br /&gt;
A subtly shady tactic on Google's part. They might argue that they've streamlined the process, but to me, inviting someone actively to a social network (i.e. telling them they should join) is a much different vibe than adding them if they are already on the network.&lt;br /&gt;
&lt;br /&gt;
I just made this mistake with a few former co-workers and friends I haven't connected with in a while (sorry if you got a weird invite, all!), so I wanted to make note of the design difference.&lt;br /&gt;
&lt;br /&gt;
Makes me appreciate all the more that sites like LinkedIn make it clear with an icon who is a member and who isn't yet.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-2502650798757648561?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/eIQEpZiiyTKs9lkVs59tiT14vLk/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/eIQEpZiiyTKs9lkVs59tiT14vLk/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/eIQEpZiiyTKs9lkVs59tiT14vLk/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/eIQEpZiiyTKs9lkVs59tiT14vLk/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/H6BrZIQPp1Y" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/2502650798757648561/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/01/crafty-google-very-crafty.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/2502650798757648561?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/2502650798757648561?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/H6BrZIQPp1Y/crafty-google-very-crafty.html" title="Crafty, Google+. Very Crafty." /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://4.bp.blogspot.com/-LWSelM0OzjQ/TyiwBFrb0yI/AAAAAAAABB8/IrxWxNTQ4M4/s72-c/2012-01-31_ss_GPlus_AddAndInvite.png" height="72" width="72" /><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/01/crafty-google-very-crafty.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEICQ3g5fip7ImA9WhRUFEg.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-7570095632475237002</id><published>2012-01-24T19:49:00.003-05:00</published><updated>2012-01-24T19:49:22.626-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-01-24T19:49:22.626-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="personal" /><category scheme="http://www.blogger.com/atom/ns#" term="grocery list" /><category scheme="http://www.blogger.com/atom/ns#" term="food" /><title>New Tradition: The Grocery List. [The Grocery List]</title><content type="html">&lt;i&gt;Ed. Note: This is a post category I'm trying to start, as a form of public disclosure, listing items I bought at the grocery store, available publicly for your reference or critique.&lt;/i&gt;&lt;br /&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;br /&gt;
Alright, since this is the first one of these, I haven't quite figured out how I'm going to do it all the time. I'll likely scan my lists, but for now, I'll list the items.&lt;br /&gt;
&lt;br /&gt;
I think this is an okay start:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;A green pepper&amp;nbsp;&amp;amp; a yellow pepper&lt;/li&gt;
&lt;li&gt;Sliced baby bella mushrooms (I'm lazy, sue me)&lt;/li&gt;
&lt;li&gt;6 &amp;nbsp;apples&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Dozen eggs&lt;/li&gt;
&lt;li&gt;An onion&lt;/li&gt;
&lt;li&gt;A tomato&lt;/li&gt;
&lt;li&gt;1/2 Gallon Fat-Free Milk&lt;/li&gt;
&lt;li&gt;Crumbled Feta cheese&lt;/li&gt;
&lt;li&gt;Boatland Farms Strawberry / Banana Juice&lt;/li&gt;
&lt;li&gt;Celery Sticks&lt;/li&gt;
&lt;li&gt;Asparagus&lt;/li&gt;
&lt;li&gt;A Cucumber&lt;/li&gt;
&lt;li&gt;Garlic&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
My Plan&lt;/div&gt;
&lt;div&gt;
&lt;ul&gt;
&lt;li&gt;Apples for Snacks&lt;/li&gt;
&lt;li&gt;Tonight: Orzo (package some up for lunch tomorrow with an apple, celery sticks, &amp;amp; sliced pepper to snack on throughout the day)&lt;/li&gt;
&lt;li&gt;Tomorrow morning: Eggs and leftover tomato &amp;amp; onion with garlic&lt;/li&gt;
&lt;li&gt;Tomorrow evening: Asparagus and mushrooms with chicken &amp;amp; garlic (with planned leftovers for lunch)&lt;/li&gt;
&lt;li&gt;Glass of milk each morning&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
This is mainly my "keeping me honest" thing, but your thoughts &amp;amp; suggestions are always welcome in the comments.&lt;/div&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-7570095632475237002?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/NDlVoaBklm1nAu8mw4-Lai4DDE0/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/NDlVoaBklm1nAu8mw4-Lai4DDE0/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/NDlVoaBklm1nAu8mw4-Lai4DDE0/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/NDlVoaBklm1nAu8mw4-Lai4DDE0/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/_nNrSuQxf5M" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/7570095632475237002/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/01/new-tradition-grocery-list-grocery-list.html#comment-form" title="2 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7570095632475237002?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7570095632475237002?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/_nNrSuQxf5M/new-tradition-grocery-list-grocery-list.html" title="New Tradition: The Grocery List. [The Grocery List]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>2</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/01/new-tradition-grocery-list-grocery-list.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEcCRH8yeSp7ImA9WhRUFEg.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-7843860572752280969</id><published>2012-01-24T19:41:00.000-05:00</published><updated>2012-01-24T19:41:05.191-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-01-24T19:41:05.191-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="personal" /><category scheme="http://www.blogger.com/atom/ns#" term="grocery list" /><category scheme="http://www.blogger.com/atom/ns#" term="food" /><title>Some Things I've Been Bad at, and What I'm Going to do to Change it.</title><content type="html">&lt;i&gt;Ed. Note: This is one of those weird public-disclosure blog posts. If you only come here for tech stuff, then move along; nothing to see here. :)&lt;/i&gt;&lt;div&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div&gt;
&lt;i&gt;Ed. Note 2: This isn't a "new years resolution" post. It's an "I waited way too effing long to do this stuff already" post.&lt;/i&gt;&lt;br /&gt;&lt;div&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/div&gt;
&lt;div&gt;
&lt;i&gt;Ed. Note 3: I'm clearly my own editor.&lt;/i&gt;&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
I had an epiphany in the middle of the night last night. I realized two things simultaneously:&amp;nbsp;&lt;/div&gt;
&lt;div&gt;
&lt;ol&gt;
&lt;li&gt;I suck at taking care of myself in lots of ways, and&amp;nbsp;&lt;/li&gt;
&lt;li&gt;in that regard, I'm very good at tricking myself by letting things become excuses.&lt;/li&gt;
&lt;/ol&gt;
&lt;div&gt;
Some ways in which I'm guilty of this:&lt;/div&gt;
&lt;div&gt;
&lt;ul&gt;
&lt;li&gt;I don't sleep enough.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;I don't eat well at all (or eat well enough regularly enough).&amp;nbsp;&lt;/li&gt;
&lt;li&gt;I let tasks pile up. Not work things or big things, but little things. Laundry, returning a package, cleaning my room, buying supplies.&lt;/li&gt;
&lt;li&gt;Don't even get me started on exercise.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;I let work fill in the cracks of my life because I feel responsible or it's necessary or it feels good/rewarding.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
But overall, there was one major theme: &lt;b&gt;instead of making time to keep myself healthy and take care of myself, I've been letting the bullshit of being "busy" take away too much from some important things&lt;/b&gt;.&amp;nbsp;Generally, I havent' been respecting the time it takes to do these important things, and as a result have been trying to minimize them or shortcut them.&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
So I decided to knock it off. Cold turkey. I'm not phasing it in, because I've let "busy" distract me from the things I need to do for so long. I'm just doing it, and I'm going to do my best to stop making excuses not to do these things, because there is no excuse not to take better care of myself.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;So, What am I Going to Do About It?&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
&lt;b&gt;For Starters:&lt;/b&gt;&lt;/div&gt;
&lt;div&gt;
&lt;ul&gt;
&lt;li&gt;&lt;b&gt;Quit Nutrisystem&lt;/b&gt;. Wait, what? This sounds counter-intuitive, I know. I've lost some weight on nutrisystem. But its' is full of sodium, processed, etc. etc. Most importantly in my situation, it became a crutch. I'd cram a bunch of Nutrisystem because I didn't have time. I'd stop buying fresh food and subsist on their food which is only half of what they tell you to do anyway. So I consumed too much of their food. The effect started reversing itself. And honestly, it just didn't feel natural. The combination of my methods and the food made me feel like I was eating food for machines. I want to eat food for people, because I want to be more of a person.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Not rushing to work and instead prepping for my day&lt;/b&gt;. I get to work earlier than most people every day anyway. But I wake up, rush, neglect breakfast, taking time to center myself, relaxing, etc. I love the morning, but I don't appreciate it nearly enough.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Replace my after-work Starbucks trip with an after-work trip to Giant&lt;/b&gt;. They're in the same damn parking lot, and yet I've been neglecting healthy food for its short-term energy supplement.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Buy fresher things&lt;/b&gt;. One technique I'm using is to attempt to spend all my time at Giant in the fresh food sections. If I don't stray too far from that except for items I know I need, then the stuff I discover should generally be better for me.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Plan meals better, and plan them for leftovers&lt;/b&gt;. I'm one dude. I need better organization for the food I make. I suck at this now, but it'll be a good challenge. For starters, I'll attempt to be packing a lunch before work every day.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Exercise 30 minutes a day&lt;/b&gt;. A bare-minimum requirement, but one I haven't been meeting.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Drink more water&lt;/b&gt;. I received a nice water vessel &amp;nbsp;for Christmas, yet I haven't used it. Ridiculous. It's 70% of my body but I've been drinking coffee like it's water. Only water is water.&lt;/li&gt;
&lt;li&gt;&lt;b&gt;Take vitamins&lt;/b&gt;. It's easy as hell to take a vitamin a day.&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;b&gt;&lt;span style="font-size: large;"&gt;But most importantly:&lt;/span&gt;&lt;/b&gt;&lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;&lt;b&gt;Hold myself to these things as publicly as possible&lt;/b&gt;. You'll be seeing more blog posts like these, with different themes. I hope you'll indulge me and feel free to comment if you see fit. Be critical, encourage me to do better things. See a better choice I could have made? Add your thoughts. I can fool myself, but I can't fool you smart people.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
Well, now that that's all out in the open, let's start this adventure, shall we?&lt;/div&gt;
&lt;/div&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-7843860572752280969?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/ut7OWTKaKXBkX7Mas97MNZ4USNU/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ut7OWTKaKXBkX7Mas97MNZ4USNU/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/ut7OWTKaKXBkX7Mas97MNZ4USNU/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ut7OWTKaKXBkX7Mas97MNZ4USNU/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/VD9KtshwUes" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/7843860572752280969/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/01/some-things-ive-been-bad-at-and-what-im.html#comment-form" title="1 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7843860572752280969?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7843860572752280969?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/VD9KtshwUes/some-things-ive-been-bad-at-and-what-im.html" title="Some Things I've Been Bad at, and What I'm Going to do to Change it." /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>1</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/01/some-things-ive-been-bad-at-and-what-im.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEYBSHYyeyp7ImA9WhRUEU8.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-8976175449939935799</id><published>2012-01-20T19:57:00.001-05:00</published><updated>2012-01-21T00:02:39.893-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-01-21T00:02:39.893-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="SOPA" /><category scheme="http://www.blogger.com/atom/ns#" term="legislation" /><category scheme="http://www.blogger.com/atom/ns#" term="pipa" /><category scheme="http://www.blogger.com/atom/ns#" term="politics" /><title>A Metaphor for SOPA / PIPA</title><content type="html">I just thought it up -- taken from an e-mail response I just wrote to Al Franken:&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;span style="background-color: rgba(255, 255, 255, 0.917969); color: #222222; font-family: arial, sans-serif; font-size: 13px;"&gt;"They would protect an stagnant industry that wants to pour its own cement shoes while complaining that the water is rising."&lt;/span&gt;&lt;/blockquote&gt;
&lt;span style="background-color: rgba(255, 255, 255, 0.917969); color: #222222; font-family: arial, sans-serif; font-size: 13px;"&gt;I think it brings home what the industry is doing to itself. By refusing to evolve and instead fighting innovation under the guise of lost profits (the battle over the VCR, anyone?), helping the industry with legislation is stopping it from helping itself.&lt;/span&gt;&lt;br /&gt;
&lt;span style="background-color: rgba(255, 255, 255, 0.917969); color: #222222; font-family: arial, sans-serif; font-size: 13px;"&gt;&lt;br /&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span style="color: #222222; font-family: arial, sans-serif; font-size: x-small;"&gt;Am I completely off base? Do you agree? I'd love to hear in the comments.&lt;/span&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-8976175449939935799?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/Sspb5f5Ix--pVUGclFYur-WRcFQ/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Sspb5f5Ix--pVUGclFYur-WRcFQ/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/Sspb5f5Ix--pVUGclFYur-WRcFQ/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Sspb5f5Ix--pVUGclFYur-WRcFQ/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/SjjzLer_eDc" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/8976175449939935799/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/01/metaphor-for-sopa-pipa.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/8976175449939935799?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/8976175449939935799?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/SjjzLer_eDc/metaphor-for-sopa-pipa.html" title="A Metaphor for SOPA / PIPA" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/01/metaphor-for-sopa-pipa.html</feedburner:origLink></entry><entry gd:etag="W/&quot;A0ABQnk_fip7ImA9WhRVEUk.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-9220015348063160651</id><published>2012-01-09T17:55:00.003-05:00</published><updated>2012-01-09T17:55:53.746-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-01-09T17:55:53.746-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="parking" /><category scheme="http://www.blogger.com/atom/ns#" term="wmata" /><category scheme="http://www.blogger.com/atom/ns#" term="lies" /><category scheme="http://www.blogger.com/atom/ns#" term="web site" /><category scheme="http://www.blogger.com/atom/ns#" term="observation" /><title>WMATA lies! (Or: "In which I make a mild deal out of nothing")</title><content type="html">&lt;div class="separator" style="clear: both; text-align: left;"&gt;
&lt;i style="text-align: -webkit-auto;"&gt;[Ed. note: I'm very much aware that this is not a big deal. Just having some fun with observations.]&lt;/i&gt;
&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: left;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: left;"&gt;
Is it:&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://2.bp.blogspot.com/-OWRy350pv3U/Twtv9P4_S1I/AAAAAAAABBg/GzpVctFgeJI/s1600/2012-01-08_wmata1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="133" src="http://2.bp.blogspot.com/-OWRy350pv3U/Twtv9P4_S1I/AAAAAAAABBg/GzpVctFgeJI/s400/2012-01-08_wmata1.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;&lt;div&gt;
Or:&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://4.bp.blogspot.com/-ALJ0l0ckrdA/Twtv_8ZsrjI/AAAAAAAABBo/7ZG6wI7-qEk/s1600/2012-01-08_wmata2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="171" src="http://4.bp.blogspot.com/-ALJ0l0ckrdA/Twtv_8ZsrjI/AAAAAAAABBo/7ZG6wI7-qEk/s400/2012-01-08_wmata2.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Get your story straight and then get back to me, WMATA.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-9220015348063160651?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/Zx9tS577c0jNiKbryPIjTbQIJNE/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Zx9tS577c0jNiKbryPIjTbQIJNE/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/Zx9tS577c0jNiKbryPIjTbQIJNE/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Zx9tS577c0jNiKbryPIjTbQIJNE/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/efw44uKOTJc" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/9220015348063160651/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/01/wmata-lies-or-in-which-i-make-mild-deal.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/9220015348063160651?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/9220015348063160651?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/efw44uKOTJc/wmata-lies-or-in-which-i-make-mild-deal.html" title="WMATA lies! (Or: &quot;In which I make a mild deal out of nothing&quot;)" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://2.bp.blogspot.com/-OWRy350pv3U/Twtv9P4_S1I/AAAAAAAABBg/GzpVctFgeJI/s72-c/2012-01-08_wmata1.png" height="72" width="72" /><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/01/wmata-lies-or-in-which-i-make-mild-deal.html</feedburner:origLink></entry><entry gd:etag="W/&quot;A0QERnwyfip7ImA9WhRVEUk.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-5259297181271407471</id><published>2012-01-09T17:36:00.000-05:00</published><updated>2012-01-09T17:48:27.296-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2012-01-09T17:48:27.296-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="collapsed section" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports 2008" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal" /><category scheme="http://www.blogger.com/atom/ns#" term="printer" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports" /><category scheme="http://www.blogger.com/atom/ns#" term="reports" /><title>Fix: Crystal Reports 2008: "Default printer is not available" and/or Un-expandable Collapsed Sections [Field Notes]</title><content type="html">&lt;span style="font-size: x-large;"&gt;&lt;b&gt;Issue&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
In Crystal Reports 2008, when opening up a report that came from elsewhere (usually another user's machine), I see &lt;i&gt;"default printer is not available"&lt;/i&gt;.&lt;br /&gt;
&lt;br /&gt;
Oftentimes, this will be accompanied by a strange behavior that will cause reports (or subreports) to look completely collapsed, like the following image:&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://3.bp.blogspot.com/-NVxC_N7e-04/TwtqEyK-WAI/AAAAAAAABA4/NQvQAfsSnlc/s1600/CrystalReports_CollapsedSectionProblem.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="60" src="http://3.bp.blogspot.com/-NVxC_N7e-04/TwtqEyK-WAI/AAAAAAAABA4/NQvQAfsSnlc/s400/CrystalReports_CollapsedSectionProblem.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
"Oh", you say to yourself, "I'll just expand those sections manually and carry on." Well &lt;i&gt;think again, renegade &lt;/i&gt;-- Crystal Reports will have &lt;i&gt;none&lt;/i&gt;&amp;nbsp;of it. The sections appear frozen in place forever.&lt;br /&gt;
&lt;br /&gt;
&lt;table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style="text-align: center;"&gt;&lt;a href="http://1.bp.blogspot.com/-YaO5YMW_VRw/Twtqcpz7R_I/AAAAAAAABBA/h_b_bzhOyk4/s1600/han-solo-frozen-in-carbonite_2.jpg" imageanchor="1" style="margin-left: auto; margin-right: auto;"&gt;&lt;img border="0" height="318" src="http://1.bp.blogspot.com/-YaO5YMW_VRw/Twtqcpz7R_I/AAAAAAAABBA/h_b_bzhOyk4/s400/han-solo-frozen-in-carbonite_2.jpg" width="400" /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class="tr-caption" style="text-align: center;"&gt;Your report sections. It &lt;i&gt;is &lt;/i&gt;as painful as it looks.&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;b style="font-size: xx-large;"&gt;Solution&lt;/b&gt;&lt;br /&gt;
Luckily, per usual, &lt;a href="http://stackoverflow.com/questions/8714797/crystal-reports-2008-sections-are-collapsed-and-i-cant-expand" target="_blank"&gt;StackOverflow was a big help here&lt;/a&gt;.&lt;br /&gt;
&lt;br /&gt;
This solution has two different parts -- you may only need one or the other, but I've found them both to be a pretty effective one-two punch in this situation.&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;Part 1: Change Your Printer Settings&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;While in the report, click &lt;i&gt;File --&amp;gt; Page Setup&lt;/i&gt;...&lt;/li&gt;
&lt;li&gt;Check the box labeled &lt;i&gt;No Printer (optimize for screen display)&lt;/i&gt;.&lt;/li&gt;
&lt;li&gt;Check the box labeled &lt;i&gt;Dissociate formatting page size and Printer Paper Size&lt;/i&gt;.&lt;/li&gt;
&lt;li&gt;The box should look like below:&lt;/li&gt;
&lt;/ul&gt;
&lt;table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"&gt;&lt;tbody&gt;
&lt;tr&gt;&lt;td style="text-align: center;"&gt;&lt;a href="http://2.bp.blogspot.com/-fMf9WummDf4/Twtt3JidQMI/AAAAAAAABBI/FM5Ya_Hfc0A/s1600/CR+-+Page+Settings.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"&gt;&lt;img border="0" height="135" src="http://2.bp.blogspot.com/-fMf9WummDf4/Twtt3JidQMI/AAAAAAAABBI/FM5Ya_Hfc0A/s400/CR+-+Page+Settings.png" width="400" /&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class="tr-caption" style="text-align: center;"&gt;That should do it.&lt;/td&gt;&lt;/tr&gt;
&lt;/tbody&gt;&lt;/table&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;Part 2: Change Display Options&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
In case you have some sub-reports, etc. that didn't quite get the message to &lt;i&gt;thaw out, bro&lt;/i&gt;, it's likely because they were hidden before or hidden as a result of the printer situation being screwy.&lt;br /&gt;
&lt;br /&gt;
Try the following:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;While in the report, click &lt;i&gt;File&lt;/i&gt;&amp;nbsp;--&amp;gt; &lt;i&gt;Options...&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;Click the &lt;i&gt;Layout &lt;/i&gt;tab (usually visible by default in my experience)&lt;/li&gt;
&lt;li&gt;In the &lt;i&gt;Design View&lt;/i&gt;&amp;nbsp;section, check the "Show hidden sections" option. This will cause any unwieldy sections to fall in line and become visible.&lt;/li&gt;
&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-5259297181271407471?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/PR4S0gyuouAAunDAx271AzSHz_A/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/PR4S0gyuouAAunDAx271AzSHz_A/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/PR4S0gyuouAAunDAx271AzSHz_A/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/PR4S0gyuouAAunDAx271AzSHz_A/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/spvfzu_oXZw" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/5259297181271407471/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2012/01/fix-crystal-reports-2008-default.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/5259297181271407471?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/5259297181271407471?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/spvfzu_oXZw/fix-crystal-reports-2008-default.html" title="Fix: Crystal Reports 2008: &quot;Default printer is not available&quot; and/or Un-expandable Collapsed Sections [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://3.bp.blogspot.com/-NVxC_N7e-04/TwtqEyK-WAI/AAAAAAAABA4/NQvQAfsSnlc/s72-c/CrystalReports_CollapsedSectionProblem.png" height="72" width="72" /><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2012/01/fix-crystal-reports-2008-default.html</feedburner:origLink></entry><entry gd:etag="W/&quot;AkQMQXs5fCp7ImA9WhRWEE0.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-491384742223328078</id><published>2011-12-27T12:53:00.000-05:00</published><updated>2011-12-27T12:53:00.524-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-27T12:53:00.524-05:00</app:edited><title>FYI -- Potential downtime</title><content type="html">Just a quick note: I'm transferring some domains away from GoDaddy (a &lt;a href="http://gawker.com/5787676/meet-godaddys-ridiculous-elephant+killing-ceo" target="_blank"&gt;long&lt;/a&gt; &lt;a href="http://gizmodo.com/5870559/as-if-you-needed-another-reason-to-hate-fcking-godaddy" target="_blank"&gt;time&lt;/a&gt; &lt;a href="http://gizmodo.com/5871154/godaddy-may-be-delaying-domain-transfers-on-purpose" target="_blank"&gt;coming&lt;/a&gt;), and this is one of them. If you experience some downtime while I wait for things to switch over, I apologize, but we'll be back up and running soon.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-491384742223328078?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/fLP0QX8UXJPgyUNtIA8YzIgMLqA/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/fLP0QX8UXJPgyUNtIA8YzIgMLqA/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/fLP0QX8UXJPgyUNtIA8YzIgMLqA/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/fLP0QX8UXJPgyUNtIA8YzIgMLqA/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/bmuxFfpBcjk" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/491384742223328078/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/fyi-potential-downtime.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/491384742223328078?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/491384742223328078?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/bmuxFfpBcjk/fyi-potential-downtime.html" title="FYI -- Potential downtime" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/fyi-potential-downtime.html</feedburner:origLink></entry><entry gd:etag="W/&quot;C04DRHsyfip7ImA9WhRXFEo.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-7418098182042199431</id><published>2011-12-21T07:52:00.003-05:00</published><updated>2011-12-21T07:52:55.596-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-21T07:52:55.596-05:00</app:edited><title>Plaintext password offender: Yankodesign.com</title><content type="html">I recently created an account at Yanko Design (they have some neat stuff I wanted to further explore).&lt;br /&gt;
&lt;br /&gt;
The welcome e-mail I received was as follows:&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://1.bp.blogspot.com/-kmmMFrRqiiA/TvHWQy67XrI/AAAAAAAAA2M/Jz35e4xJFcw/s1600/yankodesign_plaintextoffender.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="306" src="http://1.bp.blogspot.com/-kmmMFrRqiiA/TvHWQy67XrI/AAAAAAAAA2M/Jz35e4xJFcw/s400/yankodesign_plaintextoffender.png" width="400" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
Yep, that's my password, in plaintext. Luckily I used a throwaway, but still, come on. What's it going to take for merchants and e-commerce platforms to do better than this?&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-7418098182042199431?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/Sv6BsgXpWOq9dZZ_G3epkZ_WChw/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Sv6BsgXpWOq9dZZ_G3epkZ_WChw/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/Sv6BsgXpWOq9dZZ_G3epkZ_WChw/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/Sv6BsgXpWOq9dZZ_G3epkZ_WChw/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/R3XCqHc5UzY" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/7418098182042199431/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/plaintext-password-offender.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7418098182042199431?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7418098182042199431?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/R3XCqHc5UzY/plaintext-password-offender.html" title="Plaintext password offender: Yankodesign.com" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://1.bp.blogspot.com/-kmmMFrRqiiA/TvHWQy67XrI/AAAAAAAAA2M/Jz35e4xJFcw/s72-c/yankodesign_plaintextoffender.png" height="72" width="72" /><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/plaintext-password-offender.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEMGQ38-eSp7ImA9WhRXE08.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-401319562971918061</id><published>2011-12-19T14:20:00.002-05:00</published><updated>2011-12-19T14:20:22.151-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-19T14:20:22.151-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports 2008" /><category scheme="http://www.blogger.com/atom/ns#" term="group names" /><category scheme="http://www.blogger.com/atom/ns#" term="fields" /><category scheme="http://www.blogger.com/atom/ns#" term="tip" /><category scheme="http://www.blogger.com/atom/ns#" term="howto" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports" /><title>How To: Insert Group Name Text into a Crystal Reports 2008 Section [Field Notes]</title><content type="html">&lt;span style="font-size: x-large;"&gt;&lt;b&gt;Problem&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
I accidentally deleted the group name text from a section of my Crystal Report in Crystal Reports 2008, and now I would like to re-insert the text.&lt;br /&gt;
&lt;br /&gt;
&lt;span style="font-size: x-large;"&gt;&lt;b&gt;Solution&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
This is embarrassingly simple, and yet I found it to be surprisingly counter-intuitive. Maybe it's just me..&lt;br /&gt;
&lt;br /&gt;
In the &lt;i&gt;Field Explorer &lt;/i&gt;section, expand the "Group Name Fields" section and drag the name onto the report.&lt;br /&gt;
&lt;br /&gt;
&lt;div class="separator" style="clear: both; text-align: center;"&gt;
&lt;a href="http://1.bp.blogspot.com/-KcDxOTyJTUA/Tu-N3Ce1RfI/AAAAAAAAA2E/tuKOKQvT0io/s1600/FieldExplorer_GroupName.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"&gt;&lt;img border="0" height="320" src="http://1.bp.blogspot.com/-KcDxOTyJTUA/Tu-N3Ce1RfI/AAAAAAAAA2E/tuKOKQvT0io/s320/FieldExplorer_GroupName.png" width="260" /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
It's not under insert, not as a menu shortcut, etc. -- as far as I can tell, the only place to drag a Group Name field from is there.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-401319562971918061?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/8XhtjvV3a7UlTbmqgiCkJjsu3WY/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/8XhtjvV3a7UlTbmqgiCkJjsu3WY/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/8XhtjvV3a7UlTbmqgiCkJjsu3WY/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/8XhtjvV3a7UlTbmqgiCkJjsu3WY/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/aWT6QIblVD0" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/401319562971918061/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/how-to-insert-group-name-text-into.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/401319562971918061?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/401319562971918061?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/aWT6QIblVD0/how-to-insert-group-name-text-into.html" title="How To: Insert Group Name Text into a Crystal Reports 2008 Section [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="http://1.bp.blogspot.com/-KcDxOTyJTUA/Tu-N3Ce1RfI/AAAAAAAAA2E/tuKOKQvT0io/s72-c/FieldExplorer_GroupName.png" height="72" width="72" /><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/how-to-insert-group-name-text-into.html</feedburner:origLink></entry><entry gd:etag="W/&quot;A0MHSX84cSp7ImA9WhRXE0w.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-5117591536765443162</id><published>2011-12-19T13:30:00.004-05:00</published><updated>2011-12-19T13:30:38.139-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-19T13:30:38.139-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="suppress" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports 2008" /><category scheme="http://www.blogger.com/atom/ns#" term="suppression" /><category scheme="http://www.blogger.com/atom/ns#" term="fields" /><category scheme="http://www.blogger.com/atom/ns#" term="tip" /><category scheme="http://www.blogger.com/atom/ns#" term="howto" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports" /><title>How To: Toggle Fields in a Crystal Report Based on Whether Records are Returned [Field Notes]</title><content type="html">&lt;span style="font-size: x-large;"&gt;&lt;b&gt;Problem&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
In a Crystal Report, you would like to show or hide sections based upon whether the report contains results or not.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;&lt;span style="font-size: x-large;"&gt;Solution&lt;/span&gt;&lt;/b&gt;&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;Step 1: Create a Shared Variable and Increment it&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Create a formula with a shared variable in your report -- for the sake of this example, we'll call it v_RecordCount.&lt;/li&gt;
&lt;li&gt;The contents of the formula should look like this:&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;i&gt;//Excute this formula as records are read into the report&lt;br /&gt;WhileReadingRecords;&lt;br /&gt;//define a variable that is available throughout the 'main' report&lt;br /&gt;Global Numbervar RecordCount;&lt;br /&gt;//increment the variable&lt;br /&gt;RecordCount := RecordCount+1;&lt;/i&gt;&lt;/blockquote&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;Step 2: Place the Variable in the Report header and Suppress it&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Drag the formula into the "Report Header A" section.&lt;/li&gt;
&lt;li&gt;Right-click on the formula you added in the report and select &lt;i&gt;Format Field...&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;Click the &lt;i&gt;Common &lt;/i&gt;tab.&lt;/li&gt;
&lt;li&gt;Check the &lt;i&gt;Suppress &lt;/i&gt;button.&lt;/li&gt;
&lt;li&gt;Click &lt;i&gt;OK&lt;b&gt;.&lt;/b&gt;&lt;/i&gt;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;Step 3: Craft the Proper Suppression Formula for the Sections&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
Note that the formula we have created will return &lt;i&gt;null&lt;/i&gt;&amp;nbsp;when there are no records. This is key to crafting the formula.&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Right-click on the section you would like to show or hide based on having results.&lt;/li&gt;
&lt;li&gt;Click &lt;i&gt;Section Expert...&lt;/i&gt;&lt;/li&gt;
&lt;li&gt;Next to the &lt;i&gt;Supress (No Drill-Down)&lt;/i&gt;&amp;nbsp;option, click the Formula button.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
If you want to hide a section if there are no results, enter the following:&lt;/div&gt;
&lt;div&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;i&gt;If IsNull({@RecordCount}) then true&lt;br /&gt;else false&lt;/i&gt;&lt;/blockquote&gt;
This tells Crystal to hide the section if the RecordCount is null (i.e. there are no results), and to show it otherwise.&lt;br /&gt;
&lt;br /&gt;
If you want to show a section if there are no results, enter the following:
&lt;br /&gt;
&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;i&gt;If IsNull({@RecordCount}) then false&lt;br /&gt;else true&lt;/i&gt;&lt;/blockquote&gt;
Or&lt;br /&gt;
&lt;blockquote class="tr_bq"&gt;
&lt;i&gt;If (Not(IsNull({@RecordCount}))) then true&lt;br /&gt;else false&lt;/i&gt;&lt;/blockquote&gt;
&lt;br /&gt;
These both say "if the record count is not null" (i.e. there are records), suppress this field. Otherwise, show it (if there aren't any results).&lt;br /&gt;
&lt;br class="Apple-interchange-newline" /&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-5117591536765443162?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/ele1ctf1ADH25fgk6_THzsMrO9U/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ele1ctf1ADH25fgk6_THzsMrO9U/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/ele1ctf1ADH25fgk6_THzsMrO9U/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ele1ctf1ADH25fgk6_THzsMrO9U/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/s1Pm_j34PZ4" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/5117591536765443162/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/how-to-toggle-fields-in-crystal-report.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/5117591536765443162?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/5117591536765443162?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/s1Pm_j34PZ4/how-to-toggle-fields-in-crystal-report.html" title="How To: Toggle Fields in a Crystal Report Based on Whether Records are Returned [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/how-to-toggle-fields-in-crystal-report.html</feedburner:origLink></entry><entry gd:etag="W/&quot;A04EQXY4eSp7ImA9WhRQGUg.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-7266182945405093216</id><published>2011-12-15T09:38:00.001-05:00</published><updated>2011-12-15T09:38:20.831-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-15T09:38:20.831-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports 2008" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="crystal reports" /><title>Crystal Reports 2008 Gotcha: Subreports with multiple parameter values [Field Notes]</title><content type="html">&lt;span style="font-size: large;"&gt;&lt;b&gt;The Setup&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;I have a report in Crystal Reports 2008.&lt;/li&gt;
&lt;li&gt;The report uses a few different sub-reports.&lt;/li&gt;
&lt;li&gt;The report links the subreports to the main report by passing the main report parameter to the subreport parameter.&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;The Problem&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;When calculating totals, it works correctly if I pass in a single parameter value to the main report.&lt;/li&gt;
&lt;li&gt;However, if I pass in multiple values for a parameter to the main report (think multiple work order numbers for a WONUM parameter), the subreport calculates totals for all the fields&amp;nbsp;&lt;/li&gt;
&lt;/ul&gt;
&lt;br /&gt;
&lt;span style="font-size: large;"&gt;&lt;b&gt;The Solution&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
At first, it seemed like the issue was due to me not resetting the subreport total calculations on each page. But, I knew that I was doing this, and doing it correctly according to multiple reference points.&lt;br /&gt;
&lt;br /&gt;
However, the issue (and thus, the solution) was simpler.&lt;br /&gt;
&lt;br /&gt;
Because I was passing the main report parameter to the sub-report, Crystal was passing all parameters that I passed into the main report into the subreport, so the subreport was being told to calculate across all those values each time.&lt;br /&gt;
&lt;br /&gt;
Instead, I changed the link to the subreport parameter. Instead of passing it the main report's parameter, I passed it the main report field that contained the work order number, thus assuring that it would only receive that one work order as a parameter.&lt;br /&gt;
&lt;br /&gt;
See &lt;a href="http://stackoverflow.com/questions/8514709/crystal-reports-2008-trouble-resetting-a-shared-variable" target="_blank"&gt;the StackOverflow discussion&lt;/a&gt; for more references and comments.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-7266182945405093216?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/KsGx9XwFhn4jraikqvYBC7qPVGM/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/KsGx9XwFhn4jraikqvYBC7qPVGM/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/KsGx9XwFhn4jraikqvYBC7qPVGM/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/KsGx9XwFhn4jraikqvYBC7qPVGM/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/PJmBw_oKZdE" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/7266182945405093216/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/crystal-reports-2008-gotcha-subreports.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7266182945405093216?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7266182945405093216?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/PJmBw_oKZdE/crystal-reports-2008-gotcha-subreports.html" title="Crystal Reports 2008 Gotcha: Subreports with multiple parameter values [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/crystal-reports-2008-gotcha-subreports.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CkYERX88eCp7ImA9WhRQGEQ.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-6377070135857277427</id><published>2011-12-14T14:15:00.000-05:00</published><updated>2011-12-14T14:15:04.170-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-14T14:15:04.170-05:00</app:edited><title>A brief video on the dangers of SOPA / Protect-IP</title><content type="html">And this barely begins to cover it. There's a lot beyond this, too.&lt;br /&gt;
&lt;br /&gt;
&lt;iframe allowfullscreen="" frameborder="0" height="225" mozallowfullscreen="" src="http://player.vimeo.com/video/31100268?byline=0&amp;amp;portrait=0" webkitallowfullscreen="" width="400"&gt;&lt;/iframe&gt;&lt;br /&gt;
&lt;a href="http://vimeo.com/31100268"&gt;PROTECT IP / SOPA Breaks The Internet&lt;/a&gt; from &lt;a href="http://vimeo.com/fightforthefuture"&gt;Fight for the Future&lt;/a&gt; on &lt;a href="http://vimeo.com/"&gt;Vimeo&lt;/a&gt;.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-6377070135857277427?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/pOznyoa02WPvJ0ncVngwROPRPj8/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/pOznyoa02WPvJ0ncVngwROPRPj8/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/pOznyoa02WPvJ0ncVngwROPRPj8/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/pOznyoa02WPvJ0ncVngwROPRPj8/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/LsJPhaRlN-k" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/6377070135857277427/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/brief-video-on-dangers-of-sopa-protect.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6377070135857277427?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6377070135857277427?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/LsJPhaRlN-k/brief-video-on-dangers-of-sopa-protect.html" title="A brief video on the dangers of SOPA / Protect-IP" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/brief-video-on-dangers-of-sopa-protect.html</feedburner:origLink></entry><entry gd:etag="W/&quot;A0ADSX49fip7ImA9WhRQGEU.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-7607555352295922220</id><published>2011-12-14T14:09:00.001-05:00</published><updated>2011-12-14T14:09:38.066-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-14T14:09:38.066-05:00</app:edited><title>Please act on this before it's too late for the internet. [Not Hyperbole]</title><content type="html">Important enough that I'm giving it space here. PLEASE take action on this.&lt;br /&gt;
&lt;br /&gt;
&lt;iframe border="0" height="625" src="http://americancensorship.org/callwidget" width="588"&gt;&lt;/iframe&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-7607555352295922220?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/ZZ0tc1lK5hN3wk3mynjc1BJznAc/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ZZ0tc1lK5hN3wk3mynjc1BJznAc/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/ZZ0tc1lK5hN3wk3mynjc1BJznAc/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/ZZ0tc1lK5hN3wk3mynjc1BJznAc/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/gExzhQRqFbE" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/7607555352295922220/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/please-act-on-this-before-its-too-late.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7607555352295922220?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/7607555352295922220?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/gExzhQRqFbE/please-act-on-this-before-its-too-late.html" title="Please act on this before it's too late for the internet. [Not Hyperbole]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/please-act-on-this-before-its-too-late.html</feedburner:origLink></entry><entry gd:etag="W/&quot;C04NQHc6eSp7ImA9WhRXE08.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-6004565163806221558</id><published>2011-12-13T08:18:00.004-05:00</published><updated>2011-12-19T14:13:11.911-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-19T14:13:11.911-05:00</app:edited><title>Another Underwhelming Experience With UPS MyChoice</title><content type="html">&lt;b&gt;UPDATE&lt;/b&gt;: &lt;b&gt;This is entirely my fault. I leave the text below only as a reference and to shame myself&lt;/b&gt;. The issue is that UPS sent me an e-mail at 12:07 saying a package would be delivered the next day. Because it was Sunday night, I thought it would be Monday, but it was technically Tuesday at that point because the e-mail had been sent 7 minutes after midnight.&lt;br /&gt;
&lt;br /&gt;
You win this one, UPS. But maybe batch those e-mails to 4 in the morning or so?&lt;br /&gt;
&lt;br /&gt;
&lt;hr /&gt;
Normally, when you pay for extra convenience despite the fact that a service business's reputation is normally based on that coming standard, you would expect a little something extra, right? UPS MyChoice doesn't seem to think so.&lt;br /&gt;
&lt;br /&gt;
I paid $40 for the year to join the service, which promises more convenient options such as holding shipments at the UPS store, delivering shipments to another address, picking a 2-hour delivery timeframe window, etc. This is great, considering &lt;a href="http://www.seankilleen.com/2011/04/free-million-dollar-idea-package.html" target="_blank"&gt;the problems I've had with package carriers&lt;/a&gt;.&lt;br /&gt;
&lt;br /&gt;
And at first, the service does seem promising. You receive e-mails that tell you when a package is en route to your address, and when it is expected to arrive -- even if you didn't have a tracking number. This e-mail allows you to change options for the package, etc.&lt;br /&gt;
&lt;br /&gt;
So when I received an e-mail Sunday night saying that my winter gloves would be delivered the next day, I was thrilled. I would be at work, and so I needed to have them hold it at a store.&lt;br /&gt;
&lt;br /&gt;
The e-mail said it would be delivered the next day (Tuesday) between 1:15 and 5:15. I received the e-mail at 12:07am, and at 12:08am I had chosen to have it held at the store. I was very excited that this was working out the way it's supposed to. More than I should be, really.&lt;br /&gt;
&lt;br /&gt;
Fast-forward to Tuesday at 4:15pm. I show up at the store where I'd asked the package to be held, but they didn't get any deliveries for the day. I knew it wasn't supposed to be until 5:15 at the latest, so I asked them to track the package -- only to find out that it had experienced a "delivery exception" (a.k.a "we changed your stuff on you, sorry!"). Why? Apparently when I selected the convenient option of having it delivered to the store that day, they conveniently also added an extra day onto the delivery time.&lt;br /&gt;
&lt;br /&gt;
This is exactly what I was trying to avoid. Get an e-mail at 12am saying a package will be delivered at 5pm. Ask them to hold it at the store down the street, but they need an extra day to figure out how to do that? Also, no notification about an updated delivery date, and no e-mail about a package exception at all. So I still made the extra trip, and I still had the package delayed, only this time I was supposed to feel like it was convenient, and pay them $40 a year for the privilege.&lt;br /&gt;
&lt;br /&gt;
Doubt I'll be renewing that subscription, UPS.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-6004565163806221558?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/25_gNlZrhSIwHM3GYiPUnLy1E8Y/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/25_gNlZrhSIwHM3GYiPUnLy1E8Y/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/25_gNlZrhSIwHM3GYiPUnLy1E8Y/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/25_gNlZrhSIwHM3GYiPUnLy1E8Y/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/1pCFMLUxZgA" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/6004565163806221558/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/another-underwhelming-experience-with.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6004565163806221558?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6004565163806221558?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/1pCFMLUxZgA/another-underwhelming-experience-with.html" title="Another Underwhelming Experience With UPS MyChoice" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/another-underwhelming-experience-with.html</feedburner:origLink></entry><entry gd:etag="W/&quot;DE8ARns4eSp7ImA9WhRQF0o.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-4997481045932250152</id><published>2011-12-13T06:47:00.003-05:00</published><updated>2011-12-13T06:47:27.531-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-13T06:47:27.531-05:00</app:edited><title>[Redacted]</title><content type="html">████ to ████ on my █████ █████ ████. ███████ ███████ to it! But for now, ████ is ████ █████████. ██████ ████ ████ to ████ on the ████████ and ████████ ███████████ of ████. ██████. ████ ████ ████████. And ████, ████ you (█████████) ███████ ████ I did ████ ████ ███████████ is ███████ of, █████ ████ ████ ████████ it. ███████ █████████, ████ ███████████ ████ ████ won't █████ ███████.&lt;br /&gt;
&lt;br /&gt;
&lt;a href="http://americancensorship.org/posts/400/uncensor"&gt;http://americancensorship.org/posts/400/uncensor&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-4997481045932250152?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/lH_4Ag9crzAv9zXd0VKXXryWKDo/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/lH_4Ag9crzAv9zXd0VKXXryWKDo/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/lH_4Ag9crzAv9zXd0VKXXryWKDo/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/lH_4Ag9crzAv9zXd0VKXXryWKDo/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/AECzUM_4azA" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/4997481045932250152/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/redacted.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4997481045932250152?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/4997481045932250152?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/AECzUM_4azA/redacted.html" title="[Redacted]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/redacted.html</feedburner:origLink></entry><entry gd:etag="W/&quot;DkUBQXwyfSp7ImA9WhRQFU0.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-301933643730479684</id><published>2011-12-09T23:15:00.001-05:00</published><updated>2011-12-10T03:04:10.295-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-10T03:04:10.295-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="building a build process" /><title>Building a Build Process, Part 1: Introduction</title><content type="html">&lt;i&gt;[This is the first article in a series of articles I'll be doing about building a Build Process for an application. You can refer here at any point for all of the published articles in the series.&lt;/i&gt;&lt;br /&gt;
&lt;i&gt;&lt;b&gt;&lt;br /&gt;&lt;/b&gt;&lt;/i&gt;&lt;br /&gt;
&lt;i&gt;&lt;b&gt;Under Construction: &lt;/b&gt;The language in these posts may be a little terse at first, but I'll be fleshing it out over time -- be sure to check back!]&lt;/i&gt;&lt;br /&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;br /&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;b&gt;Articles in This Series&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Part 1: Introduction (this article)&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;b&gt;Why Undertake This (Plus: Look at my Presentation!)&lt;/b&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
I've seen too many instances in various jobs and projects where the build/integration process is not afforded due diligence (or &lt;i&gt;any&lt;/i&gt;&amp;nbsp;diligence, really).&lt;br /&gt;
&lt;br /&gt;
I decided I needed to do something about it. Part experiment, part challenge, part reference guide. I'm going to see if I can put together an entire continuous integration / build process for .NET environments from scratch.&lt;br /&gt;
&lt;br /&gt;
Below, you can find some slides from a presentation I gave at work (and yes, the design ideas are at times ripped directly from &lt;a href="http://zachholman.com/posts/slide-design-for-developers/" target="_blank"&gt;Zach Holman's article&lt;/a&gt; as I tried to emulate his style. He's awesome, and I'm shameless. Credit was given.) This talk highlighted the benefits of inte"great"ion and what I was about to undertake.&lt;br /&gt;
&lt;div id="__ss_10484958" style="width: 425px;"&gt;
&lt;br /&gt;
&lt;div style="padding: 5px 0 12px;"&gt;
&lt;b style="font-size: x-large;"&gt;My Goal&lt;/b&gt;&lt;/div&gt;
&lt;/div&gt;
In short, dear reader, my end desire is to have a completely integrated build process for .NET using (almost) free and/or open-source tools, and to share my process with you.&lt;br /&gt;
&lt;br /&gt;
The build process so far will include the following:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Subversion repository on CentOS VM&lt;/li&gt;
&lt;li&gt;An ASP.NET MVC Project Added to the Source control&lt;/li&gt;
&lt;li&gt;Trac web site connected to Subversion repository on CentOS VM&lt;/li&gt;
&lt;li&gt;Build Server VM (Windows Server 2008 R2)&lt;/li&gt;
&lt;li&gt;CruiseControl.NET running on the Build Server&lt;/li&gt;
&lt;li&gt;Building the Project with MSBuild via CCNet&lt;/li&gt;
&lt;li&gt;Building a Release build via CCNet; if successful, publishes to AppHarber via a cloned git repository&lt;/li&gt;
&lt;li&gt;NUnit Tests&lt;/li&gt;
&lt;li&gt;NCover code coverage metrics&lt;/li&gt;
&lt;li&gt;SpecFlow User Acceptance Test / Feature Test coverage&lt;/li&gt;
&lt;li&gt;Selenium Server as a web driver to execute specflow tests&lt;/li&gt;
&lt;li&gt;Selenium Grid executing tests on multiple OSes / platforms&lt;/li&gt;
&lt;li&gt;Adding FxCop to the mix to check my coding standards&lt;/li&gt;
&lt;li&gt;Adding StyleCop to the mix to make sure the code is consistently written.&lt;/li&gt;
&lt;li&gt;Utilizing Nuget packages and Octopus to transform releases for different environments.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
&lt;span class="Apple-style-span" style="font-size: large;"&gt;&lt;b&gt;Hoo-boy, Here We Go&lt;/b&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div&gt;
It's a lofty goal -- especially for someone who's not a pro developer -- but I'm excited for everything I'm about to learn during this process.&lt;/div&gt;
&lt;div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div&gt;
Onward and Upward!&lt;/div&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;/ul&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-301933643730479684?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/3ozKu72xzBdCecmmtQ_6xLoaIkE/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/3ozKu72xzBdCecmmtQ_6xLoaIkE/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/3ozKu72xzBdCecmmtQ_6xLoaIkE/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/3ozKu72xzBdCecmmtQ_6xLoaIkE/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/h5D5t3j-PD8" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/301933643730479684/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/building-build-process-part-1.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/301933643730479684?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/301933643730479684?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/h5D5t3j-PD8/building-build-process-part-1.html" title="Building a Build Process, Part 1: Introduction" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/building-build-process-part-1.html</feedburner:origLink></entry><entry gd:etag="W/&quot;CEYGSH49fSp7ImA9WhRQFEQ.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-2941818830281594729</id><published>2011-12-08T09:21:00.001-05:00</published><updated>2011-12-09T23:42:09.065-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-09T23:42:09.065-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="google+" /><category scheme="http://www.blogger.com/atom/ns#" term="tip" /><category scheme="http://www.blogger.com/atom/ns#" term="google chat" /><category scheme="http://www.blogger.com/atom/ns#" term="google" /><category scheme="http://www.blogger.com/atom/ns#" term="chat" /><title>Tip: Does your workplace block Google Chat? Use Google+ to talk to people in your circles</title><content type="html">&lt;i&gt;[&lt;b&gt;Ed. Note&lt;/b&gt;: For the record, I discovered this by accident, and don't particularly intend to use it unless absolutely necessary.]&lt;/i&gt;&lt;br /&gt;
&lt;br /&gt;
While circumventing your workplace's chat policy is never necessarily a wise thing, if your office place blocks Google Chat, you can (partially) circumvent this to allow Google Chat with folks in your Google+ circles.&lt;br /&gt;
&lt;br /&gt;
To do so:&lt;br /&gt;
&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;Sign into Google+.&lt;/li&gt;
&lt;li&gt;On the home tab, you should see a notification about being able to chat with your circles.&lt;/li&gt;
&lt;li&gt;Click &lt;i&gt;OK&lt;/i&gt;, and your contacts will appear on the home screen with standard gchat-like indicators.&lt;/li&gt;
&lt;/ul&gt;
&lt;div&gt;
Some things of note so far:&lt;/div&gt;
&lt;div&gt;
&lt;ul&gt;
&lt;li&gt;Your friends' job titles take the place of chat statuses within Google+ chat.&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-2941818830281594729?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/knKut2Q_D2aTwQhQtDQuFqSARGU/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/knKut2Q_D2aTwQhQtDQuFqSARGU/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/knKut2Q_D2aTwQhQtDQuFqSARGU/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/knKut2Q_D2aTwQhQtDQuFqSARGU/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/GxcFws1r1zs" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/2941818830281594729/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/tip-does-your-workplace-block-google.html#comment-form" title="1 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/2941818830281594729?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/2941818830281594729?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/GxcFws1r1zs/tip-does-your-workplace-block-google.html" title="Tip: Does your workplace block Google Chat? Use Google+ to talk to people in your circles" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>1</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/tip-does-your-workplace-block-google.html</feedburner:origLink></entry><entry gd:etag="W/&quot;A0cERnk4eip7ImA9WhRQEUU.&quot;"><id>tag:blogger.com,1999:blog-10550379.post-6055695297648892879</id><published>2011-12-06T11:15:00.001-05:00</published><updated>2011-12-06T11:30:07.732-05:00</updated><app:edited xmlns:app="http://www.w3.org/2007/app">2011-12-06T11:30:07.732-05:00</app:edited><category scheme="http://www.blogger.com/atom/ns#" term="presentations" /><category scheme="http://www.blogger.com/atom/ns#" term="powerpoint" /><category scheme="http://www.blogger.com/atom/ns#" term="Microsoft Office" /><category scheme="http://www.blogger.com/atom/ns#" term="tip" /><category scheme="http://www.blogger.com/atom/ns#" term="Field Notes" /><category scheme="http://www.blogger.com/atom/ns#" term="backups" /><title>Tip: When presenting, ALWAYS have backup formats [Field Notes]</title><content type="html">A brief anecdote:&lt;br /&gt;
&lt;br /&gt;
I prepared a presentation yesterday to present today to colleagues on subjects such as Continuous Integration, Unit / Spec Testing, Source management, etc.&lt;br /&gt;
&lt;br /&gt;
I created the presentation in MS PowerPoint 2010, and saved it with some embedded fonts in .pptx format. It runs great. I open it on my work PC this morning, and it runs great. I save it to a thumb drive, and it opens fine.&lt;br /&gt;
&lt;br /&gt;
We get into the conference room late, I log onto the PC that's there, I open the presentation..&lt;br /&gt;
...&lt;i&gt;and PowerPoint crashes&lt;/i&gt;.&lt;br /&gt;
&lt;br /&gt;
I try copying it from the USB Drive to the Desktop, I open it ...&lt;i&gt;and PowerPoint crashes again&lt;/i&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Luckily, &lt;/b&gt;I saved a version in .ppt format so that it would be backwards compatible with PowerPoint 2000-2003. I open that&amp;nbsp;...&lt;i&gt;and PowerPoint crashes again&lt;/i&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;b&gt;Luckily, &lt;/b&gt;I also uploaded the presentation to SlideShare. I attempt to open that&amp;nbsp;...&lt;i&gt;and the computer has trouble connecting to the internet.&lt;/i&gt;&lt;br /&gt;
&lt;i&gt;&lt;br /&gt;&lt;/i&gt;&lt;br /&gt;
&lt;b&gt;Luckily, &lt;/b&gt;I had also exported the presentation to a PDF file. I open that in Adobe Acrobat Reader, put it in full-screen mode, &lt;b&gt;and gave the presentation&lt;/b&gt;.&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
I hope that illustrates the point well enough without further explanation.&lt;br /&gt;
&lt;br /&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/10550379-6055695297648892879?l=www.seankilleen.com' alt='' /&gt;&lt;/div&gt;
&lt;p&gt;&lt;a href="http://feedads.g.doubleclick.net/~a/fLk7CjnQ3ty6wNmtyUDmQQHFmD4/0/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/fLk7CjnQ3ty6wNmtyUDmQQHFmD4/0/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;br/&gt;
&lt;a href="http://feedads.g.doubleclick.net/~a/fLk7CjnQ3ty6wNmtyUDmQQHFmD4/1/da"&gt;&lt;img src="http://feedads.g.doubleclick.net/~a/fLk7CjnQ3ty6wNmtyUDmQQHFmD4/1/di" border="0" ismap="true"&gt;&lt;/img&gt;&lt;/a&gt;&lt;/p&gt;&lt;img src="http://feeds.feedburner.com/~r/Seankilleencom/~4/XNbonWFPWdU" height="1" width="1"/&gt;</content><link rel="replies" type="application/atom+xml" href="http://www.seankilleen.com/feeds/6055695297648892879/comments/default" title="Post Comments" /><link rel="replies" type="text/html" href="http://www.seankilleen.com/2011/12/tip-when-presenting-always-have-backup.html#comment-form" title="0 Comments" /><link rel="edit" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6055695297648892879?v=2" /><link rel="self" type="application/atom+xml" href="http://www.blogger.com/feeds/10550379/posts/default/6055695297648892879?v=2" /><link rel="alternate" type="text/html" href="http://feedproxy.google.com/~r/Seankilleencom/~3/XNbonWFPWdU/tip-when-presenting-always-have-backup.html" title="Tip: When presenting, ALWAYS have backup formats [Field Notes]" /><author><name>Sean Killeen</name><uri>https://profiles.google.com/117744814877524699868</uri><email>noreply@blogger.com</email><gd:image rel="http://schemas.google.com/g/2005#thumbnail" width="32" height="32" src="//lh4.googleusercontent.com/-EpicBToI_74/AAAAAAAAAAI/AAAAAAAAA0s/GOFa408fdj4/s512-c/photo.jpg" /></author><thr:total>0</thr:total><feedburner:origLink>http://www.seankilleen.com/2011/12/tip-when-presenting-always-have-backup.html</feedburner:origLink></entry></feed>

