BAB2020
May 1st, 2009, 01:31 PM
I have a somewhat unique requirement with a user report. Rows consist of customer names, columns are dates, and the data is the amount owed. The user only wants to see 6 months worth of due dates, then the rest go into one column of remaining months. Another words
month 1 - month 6 are broken down in individual columns. Month 7 and beyond are grouped into one column called balance. To futher the difficulty each of the 6 months could have between 1 - 3 due dates. Using a cross tab I was able to display all due dates, but I am unable to combine month 7 and beyond into the balance column.
The reason for doing this is the report would be to large if all dates were listed, so they decided to show the first 6 months, and the remainder grouped into one.
Questions :
- Is Crystal the right tool ?
- If I cannot get around this, would I be able to read a comma delimited file into Crystal ?
- Is it possible to do a cross-tab for first 6 months, and maybe another sub-report for 7 months and beyond as well as the row totals ?
Thank You
BAB2020
month 1 - month 6 are broken down in individual columns. Month 7 and beyond are grouped into one column called balance. To futher the difficulty each of the 6 months could have between 1 - 3 due dates. Using a cross tab I was able to display all due dates, but I am unable to combine month 7 and beyond into the balance column.
The reason for doing this is the report would be to large if all dates were listed, so they decided to show the first 6 months, and the remainder grouped into one.
Questions :
- Is Crystal the right tool ?
- If I cannot get around this, would I be able to read a comma delimited file into Crystal ?
- Is it possible to do a cross-tab for first 6 months, and maybe another sub-report for 7 months and beyond as well as the row totals ?
Thank You
BAB2020