I am creating an income statement that compares "year over year data" using Crystal (for example, I want to display Q1 2008 and Q1 2007 on the same report. Thanks to Larry Jones' hints, I am close to my goal).
My final issue is regarding the use of the F0902 table to place data from 2 years side by side. The F0902 stores period end balances by month by year in separate records. My overall selection criteria include "8" and "7" for 2008 and 2007, and I have created template field objects to summarize the monthly data. My problem is that each set of template field objects include both 2007 and 2008 data, and I can not see how to filter the data in the template field objects so that 1 column displays the 2008 data, and the other displays the 2007 data only. If someone can show me what (obviously simple!) step I am missing, I would be extremely grateful. Thanks.