Luke L (9/21/2010)
Some sample data and required output would be very valuable here. See the first link in my signature for more info.You need to figure out if you'll do the group in the SQL query or at report rendering. Also, if you're doing aggregations on the data and you want to do it in the dataset not at rendering you'll need to use a GROUP BY Clause not the DISTINCT Keyword.
-Luke.
If possible, I want to do everything at rendering. I just want the records that I need returned in the dataset. Distinct only on columnA.
PS. I was wondering when you'd get to my post. 🙂 I saw your sig moving up the list of posts.:-P