only one value from each month

[pooja]

i have a table like this

date-----montlyfees-------transaction

jan-14      20                     fees
jan-30      20                      fees
feb-4        20                     fees
feb-8        20                     fees
feb28        20                     fees 
march-7     20                     fees
march-31    20                     fees
april-17      20                     fees
april30       20                     fees           
dec-21       20                        fees
dec-31      20                          fees

I have prompt page with date range
what we need to get is last date of everytmonth ...amount and transaction
like if we put the yearly date form jan-dec then it should display like
Jan30
feb28
march-31
april-30
dec-31

anybody please have some hits/idea.....please

pj

[pooja]

And one more thing..
if user select only monthly date then should display the last date of particular month

[Suraj]

check date/time functions in report studio.
you have more than enough functions there for first of month, last of months etc...