Hello,  I am very new to using crystal reports XI.  Could someone please help me with the following query that I have regarding this particular problem as mentioned below....

This is what I would like to know..

For three data fields(X, Y and Z) in the database, I need to retrieve the data as follows...


Date               Data Field (X)       Data Field (Y)           Data field (Z)
01/06/2009          X(01)                  Y(01)                      Z(01)
02/06/2009          X(02)                  Y(02)                      Z(02)
03/06/2009          X(03)                  Y(03)                      Z(03)

29/06/2009          X(29)                  Y(29)                      Z(29)
30/06/2009          X(30)                  Y(30)                      Z(30)
01/07/2009          X(31)=Y(30)         Y(31)                      Z(31) 
02/07/2009          X(32)                  Y(32)                      Z(32)

Also, please take into consideration that:
          X(02)=X(01)+Z(02)
          X(03)=X(02)+Z(03)

          X(31)=Y(30))+Z(31) ***
          X(32)=X(31)+Z(32)

***  (THIS IS WHERE THE PROBLEM STARTS FOR ME FOR THE LATER DATA... X(32))
This should be true for all the months in a year....

Please let me know if the question is not too clear....

Thank you in advance....





Edited by Subroto - 23 Feb 2010 at 7:04am