Comparing current YTD to last ytd and future ytd
Posted on 2006-05-03
I am so lost it is not even funny. I have been a Crystal Reports Guru now for 12 whole hours. I guess because I can spell it. My boss needs a report by Friday. I have to give him a line graph for proposal fees by month for last year compared to current ytd and if possible plot anticipated goals for next year.
I have generated a report grouped by proposal.submittal_date. I have made the proposal.proposal_fee the summary and have chosen only the records in which the Proposal.submittal_date > 01/01/2005 12:00:00AM
I have a beautiful line graph now that starts at 01/2005 continuing through 5/2006 and I am quite pleased I have gotten this far. However, I am stuck now.
How do I compare this YTD to last years proposal fees to date. I have tried desperately to figure it out using "Teach Yourself Crystal Reports 9 in 24 hours" and reading all of the responses here - but I am no closer now than I was this morning at 9am when I was told I would be responsible for this report. If you cannot give me specifics, can someone PLEASE point me in the right direction!?!? I will be leaving work soon as it is nearly 10pm and I have to stop and get Tylenol on the way home before my head explodes, but I will be back at this in the morning and would be MOST grateful to any help anyone can extend. FOREVER IN YOUR DEBT!