I have a similar problem. I am using CR8, created my report using Crystal SQL Designer (I found this to be much easier than trying to get CR to perform a UNION) and connecting to a MSSQL 6.5 database. If I choose to proceed without a dictionary, the report retrieves and presents the data with no problems. Is it possible to have CR not call for a dictionary or is this absolutely required?