If Commands are available for your database, "Add Command" will appear inside the Database Connection after you connect.  Click on it and either enter or paste in your SQL.  If your SQL has parameters, create the parameter inside the Edit Command box NOT the way you normally do parameters for the report (they won't work otherwise.)

 

You can then create your report based on the fields in the SQL.

 

-Dell

This is more of a SQL question than a Crystal question, but I'll give it a shot.

 

 

If there is a query that is giving the correct results when run in a query tool like Toad, use that query.

 

You could also use sub-queries in your From clause.  The format might look something like this:

Select
  <fields, calculations...>
from
  (Select <fields>
   from Fact1
      inner join Dimensions on ...
   where ...) as qry1
  full outer join
  (Select <fields>
   from Fact1
     inner join Dimensions on...
   where ...) as qry2 on ...
where ....