Hi, All.
I have a problem in Crystal Report. I have a database field like this:
ID Creation Budget Actual
1 2007-1 30 45
2 2007-2 30 38
3 2007-3 30 42
4 2007-4 30 Null
5 2007-5 30 Null
.......
12 2007-12 30 Null
This database storage the info about budget and actual
when the first month of each year, we input all the budget of the full year.
and we input actual data every month.
We hope our line chart can show a line about sum(budget) of the full year:
and another segment of line indicate the actual of the summary to current month. (eg. the data of 2007, this line will hide after 2007-4, but the budget will show all 2007 sum data)
| /budget(sum2007-12=360)
| /
| /
| /
|/-/act(sum2007-3=125)
*----
What should I do? Please Help!!
Thanks.
Seraph