If possible, I would advise using a stored procedure as this will give you maximum versatility.  Barring that, I would try to write the SQL select yourself as you seem to be looking for something like:

SELECT Account, year FROM sometable WHERE year = currentYear - 1 OR year = currentYear

 

Hope this helps

 

However, Crystal will allow you to pull multiple copies of the same table into a report.  In the Database Expert, when you select a table that is already on the report, Crystal will notify you and ask you if you want to "alias" it.  If you say Yes, it will add a second copy of the table with "_1" added to the end of the name.  For this example, I'll call them Table and Table_1.

 

Link from Table to Table1 based on account number or whatever unique field or set of fields identify an account.  If you want all of the accounts with amounts from this year to appear on the report regardless of whether they have values from the previous year, right-click on the link and select Link Options.  Select "Left Outer Join" and click on OK.

 

In the Select Expert, set whatever your various non-year-based selection criteria is for Table only.  Set the year criteria for Table to the current year.  Set the year criteria for Table_1 to the prior year.

 

In your report, group on {Table.Account_Number}.

 

-Dell