August 2, 2009

Change Data Source in Multiple Crystal Reports with Ease

I needed to change the data source in a number of Crystal reports that I developed for a client last week. I had developed the reports on my own PC, emailed them to the client and then tried to change the data source from within Crystal. Unfortunately, the client was using an older version of Crystal that apparently doesn't easily accomodate data source changes. After determining that I wasn't going to be able to mod the SQL queries to point to the client databases, I went seaching the web for a tool that would help. Gladly, I found one that quite easily changes the data source on one or multiple reports in one pass. Have a look at this website if you find yourself in the same situation - http://www.softwareforces.com/Product/ri/pro/3/rptInspector.htm.

MVP for another year

The powers-that-be at Microsoft were gracious enough to include me for another year with the best of the best GP folks. Congratulations to fellow 2009 MVPs Andrew Karasev, Charles Allen, David Patrick, Leslie Vail, Mark Polino, Mariano Gomez, Mohammad Daoud, Monzer Osama, and Victoria Yudin. Here's looking forward to another fun and interesting year in GP-land!