Live Meetings quotes “travel stress” statistics to market their service

Business People Liken Stress of Travel to Trip to Dentist, According to New Survey Released by Microsoft

Company Is Introducing New Microsoft Office Live Meeting Service In Series of Events to Dramatize Unnecessary Hardships of Business Travel

(http://www.microsoft.com/presspass/press/2003/sep03/09-15BizTravelPR.asp)

This caught my eye because I am in the throes of trying to decide whether or not to accept an unsolicited invitation (request really) to speak at the Mobile Devcon. It would mean 3 trips to the west coast in the course of two months (MVP Summit in April and TechEd in May). I live in Vermont. I am stressed out just contemplating this and I really owe them an answer.

Gotta go gotta go gotta go gotta go

Have you seen these funny commercials for people with [I assume] mild incontinence? The lady in the jury box in the middle of a trial, the lady stuck in her car with the grandkids at a drive through safari?

It makes my husband laugh and tease me. Why? Why am I even writing about this? No,  I don’t have that particular problem. However, I do seem to sit in front of the computer, knowing I gotta go, but… just gotta finish this last thought in my blog or… try this last line of code to see if it does the trick etc. Hours can go by. God forbid I have to sneeze! (hee hee) Rich is always amazed. He think Microsoft should stop sending me t-shirts and mugs and maybe send me Depends instead.

I have a sneaking suspicion that there are probably a lot of geeks who do this, too.

Oh well, gotta go… 🙂

Crystal Reports Workaround

There is a barely documented problem with Crystal Reports for .NET that occurs if you try to pass a dataview as a datasource to a report. The report has been built via a project dataset (XSD).

Here is the tech support entry. It has a tracking id of “CR ADAPT00117088”. I probably don’t have the latest patch but there is no reference anywhere else to this track id.

The work around is just to pull the dataview data into a new datatable. Crystal doesn’t give a sample so here is one for anyone who may be looking.

First here is the long way around if you need a table to move into a dataset.

Dim tbl As DataTable = myDataView.Table.Clone
Dim iRow As Int32
For iRow = 0 To dv.Count – 1
   
tbl.ImportRow(dv.Item(iRow).Row)
Next
mycrystalreport.SetDataSource(tbl)  ‘this assumes you only have one table for your datasource

(I need to make a confession – I have been so stung by the problem of trying to move a table from one dataset into another that I didn’t stop and think that I was sending a datatable not a dataset, so I did this the long way around. Thanks to Mike below for pointing out my silliness…see his comment for the easy way.)

Conference evals from PASS

Interesting post from 2003 PASS track chair, Roman Rehak, on the evals from the conference. Besides been a .NET developer, Roman is an absolute whiz with SQL Server and has been doing a lot of talks for developers on what they should really know about working with SQL Server. Keep an eye on his weblog for some great pointers and insights – and occasional recipes. He happens to be an awesome cook – I have been fortunate to partake in some of his wonderful meals.