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
And one more thing..
if user select only monthly date then should display the last date of particular month
check date/time functions in report studio.
you have more than enough functions there for first of month, last of months etc...