I have two tables.... one table has a FormNo (FormNumber) and information about that FormNo which include FY, location, etc...

Then I have the second table that has the Primary Key's of FormNo and a field called Fiscal...

Now there are three positions of Cash Amounts throughout the year. But during the year they can change the Year that the FormNo is in... so it should print out

FormNo Pos1 Pos2 Pos3
2003
12345 1,000 1,000 0

2004
12345 0 0 1,000

Basically what the above report shows is that the project was moved from 2003 to 2004 in Pos3. Same FormNo listed twice because it appears at some time in both Years.

That's some background, my problem is... In Crystal Reports I want to print a report identical to the one above... only problem is... its printing

FormNo Pos1 Pos2 Pos3
2003
12345 1,000 1,000 0

But not the information in 2004... just printing the FormNo once. If anybody has any idea what I can do... I'd apprechiate it.