One of the most effective ways to extract your valuable Cityworks data is utilizing a reporting engine like Crystal Reports or SQL Server Reporting Services (SSRS).  Many Cityworks clients have Crystal or SSRS gurus on staff.   To encourage these valuable skills and reward these hardworking individuals, we developed a fun event for clients and business partners to participate in.

This year Cityworks sponsored the first of what will be an annual report writing competition at the Cityworks User Conference in May.  With a surprising 20 contestants and over 30 report submittals, the Cityworks judges (Becky Tamashasky, Industry Practices Manager; Brian Chadwick, GIS Support Manager; and Reed Hayes, Senior Customer Support Representative) had a difficult time narrowing down the winners.

The winners of this year’s competition are as follows:

Best/Most Complex Report:

1st  William Cowart – Macon Water Authority, GA

2nd  Thomas Bulone – St. Cloud, FL

2.5  James Boergers – St. Johns County Utilities, FL

3rd  Janet Brinker and Gina Bohn – Oakland County, MI submitted by Eric Hrnecek (Woolpert)

Most Unique Report:

1st  Dawn Fletcher – White House Utility District, TN

2nd  Cindy Hintze – Coon Rapids, MN

2.5  Pattie Clayton – Danville, VA

3rd  Sandy Aragon – Ft. Collins, CO

Best SQL Report:

1st  Kyle Tjelmeland – Topeka, KS submitted by Eric Hrnicek (Woolpert)

2nd  Carrie Shockley – Bozeman, MT

Best Visual Report:

1st  John Stewart ESRI Canada submitted by Slobodan Knezevic

2nd  Ellen Prendergast – Palm Bay, FL

Competition Organizer Chris Brussow, Cityworks Client Relations Rep Western Region, said of the contest, “We were very excited to see so many participants in the first year of the competition.  The quality of reports was better than I could have imagined.  I am excited to see how this contest will grow in the years to come.”

All of the reports submitted for the competition are now available on (Resource and Download center/reports) for review and use.  For information on Crystal Reports for Cityworks training, please see the Campus.