cross tab report help

[JeffMachine]

I need to create a report that spreads the cost of a job over the life of the job.

Report should look like:

Job Amount enddate Jun09 Jul09 Aug09 etc.....
Job1 10,000 10/15/09 2000 2000 2000 until oct
job2 20,000 11/23/09 3333 3333 3333 until nov

My data is simple, I have a job, amount, and an end date. I need to spread the amount evenly (amount divided by X number of months) over X number of months until the end date. X number of months would be enddate-currentdate.

I'm using Crystal XI.

Thanks ...

 

[Madawc]

I think that's asking too much of Crosstabs. They do allow more than one field, but this applies to all cells.

Try doing it by grouping instead, group by job. Have running totals for the month per job. Or do a complete task as a 'Mock-Crosstab' - use SEARCH to get details.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10