make a report

See more:

C#

CrystalReports

Hi Are you Ok? I have a Problem that it makes me crazy.
I want to make a report between two Dates and in this time I need to show both invalid and valid data.
Let me say more about my report:
Assume we have these Data:

Year    Month      Date of pay Kind of pay Money-Pay   Money
2009    June       02.06.2009  Cheque      200 $       300$
2009    July       03.07.2009  Pecuniary   300$        300$
2009    August     ----        ----        ----        300$
2009    September  04.09.2009  Cheque      400 $       300$
2009    October    04.10.2009  Pecuniary   400 $       500$
2009    November   09.11.2009  Pecuniary   500 $       500 $
2009    December   ----        ----        ----        ----
2010    January    11.01.2010  Pecuniary   600 $       700 $
2010    February   11.02.2010  Cheque      600 $       700 $
2010    March      11.03.2010  Pecuniary   600 $       700 $
2010    April      11.04.2010  Cheque      600 $       700 $
2010    May        15.05.2010  Cheque      700 $       1000 $
2010    June       ----        ----        ----        ----
2010    July       ----        ----        ----        ----
2010    August     ----        ----        ----        ----
2010    September  10.10.2010  Pecuniary   1000 $      1000 $
2010    October    10.11.2010  Cheque      10000 $     1100 $
2010    November   10.12.2010  Pecuniary   1500  $     1100 $

Some months we have not any payments, that it is showed by ------.
I need these reports:
1. Report in year 2009

2009    January     ----------  ---------    -----   ------------
2009    February    ----------  ---------    -----   ------------
2009    March       ----------  ---------    -----   ------------
2009    April       ----------  ---------    -----   ------------
2009    May         ----------  ---------    -----   ------------
2009    June        02.01.2009  Cheque       200 $   300$
2009    July        03.07.2009  Pecuniary    300$    300$
2009    August      ----        -----        -----   300$
2009    September   04.09.2009  Cheque       400 $   300$
2009    October     04.10.2009  Pecuniary    400 $   500$
2009    November    09.11.2009  Pecuniary    500 $   500 $

2. report between 0.1.07.2009 - --until---- 31.07.2010

2009    July        03.07.2009  Pecuniary    300$    300$
2009    August      ----        -----        -----   300$
2009    September   04.09.2009  Cheque       400 $   300$
2009    October     04.10.2009  Pecuniary    400 $   500$
2009    November    09.11.2009  Pecuniary    500 $   500 $
2009    December    -----       -----        -----   -----
2010    January     11.01.2010  Pecuniary    600 $   700 $
2010    February    11.02.2010  Cheque       600 $   700 $
2010    March       11.03.2010  Pecuniary    600 $   700 $
2010    April       11.04.2010  Cheque       600 $   700 $
2010    May         15.05.2010  Cheque       700 $   1000 $
2010    June        ----        -----        -----   -----
2010    July        ----        -----        -----   -----

Please Help me. It is urgent and I have a deadline for this project.
It is better if I can produce this report by Crystal report
I attach this text as a word file here:
http://www.4shared.com/file/KK9dfwCB/Help4MyProblem.html[^]
Thanks

[edit]General tidy up and reformat to be more readable, Tags - OriginalGriff[/edit]