Live Report with SQL Distinct

Nancy_Lee

I have created a Livereport to gather workflow information. I'm bringing back workflow work IDs and getting multiple entrees for some of the workflow IDs. I tried to eliminate them using Distinct. and I received a "Illegal use of Long data type" I've attached the sql for the query and a snapshot of the resultant LiveReport. I'm looking to eliminate the duplicate "Work IDs".