I have a SQL statement that I can see in MS Query returns the records that I need. I have a Crystal Report that someone else created that has the format I need. I do not want to use the database expert. I want to enter my SQL Statement directly into Crystal Reports (v10 by the way). I don't want to pick through the brooken inner and outer joins in the crystal reports database expert. I want to paste the known working query in. There has GOTTA be a way to do that.

Edited by vthomeschoolmom - 21 Jun 2012 at 6:22am

Thanks. That was enough information to get me what I need.