hariushas
May 31st, 2004, 08:26 AM
i want to create an age wise report. it consists of
account name|total| 0-15 days|15-30 days|30-45 days|45-60 days|60-90 days|above 90 days|openeing balance
this is the format of my report. i explain it in detail
ie,
by example
the report was taking on: 1-1-2004
first comes the name of the account holder.
second comes the total present balance (current balance)
third is the balance fro 0-15 days,ie from 1-01-2004 to 16-12-2003.
next is 15-30 days,ie from 17 -12 -2003 to back 15 days
next is 30 to 45 days,ie 02-12-2003 to back 15 days
next is 45-60 days,ie 17-11-2003 to back 15 days
next is 60-90 days,ie 02-11-2003 to back 30 days
next is above 90 days ie from 03-10-2003
how can i make this report in crystal report with out using seperate queries for each one. i think it will take long time for processing.
please help me as fast as possible.
hariushas.-:wave:
account name|total| 0-15 days|15-30 days|30-45 days|45-60 days|60-90 days|above 90 days|openeing balance
this is the format of my report. i explain it in detail
ie,
by example
the report was taking on: 1-1-2004
first comes the name of the account holder.
second comes the total present balance (current balance)
third is the balance fro 0-15 days,ie from 1-01-2004 to 16-12-2003.
next is 15-30 days,ie from 17 -12 -2003 to back 15 days
next is 30 to 45 days,ie 02-12-2003 to back 15 days
next is 45-60 days,ie 17-11-2003 to back 15 days
next is 60-90 days,ie 02-11-2003 to back 30 days
next is above 90 days ie from 03-10-2003
how can i make this report in crystal report with out using seperate queries for each one. i think it will take long time for processing.
please help me as fast as possible.
hariushas.-:wave: