Can you get a report with just tables instead of a command to work in the viewer?
Is the viewer application also located on your workstation (or a computer with the Crystal Designer app on it) or is it on a separate server? If it's on a seperate server, can the server "see" the database? (i.e., Does it have the right database client software (if needed.) If you're using ODBC, is the same ODBC DSN set up on the server as on your workstation? Etc.)
-Dell