luv2bike2nv
IS-IT--Management
I am really confused on this issue.
Crystal Reports 8.5
The report is Ontime delivery report.
The formulas i have that ARE working are as follows:
@On-Time
If {Detail.CurDue} >= {Detail.Shpdte}
Then {Detail.CurDue} - {Detail.Shpdte)
@Ontimecount
If {Detail.Curdue} >= {Detail.Shpdte}
then 1
@ontime%
Sum ({@ontimecount},{Detail.Cusdue}, "monthly" / Count {{Detail.Shpdte}, {Detail.CusDue}, "monthly"}
i need to change the @ontime% to be
Sum ({@ontimecount},{Detail.Curdue}, "monthly" / Count {{Detail.Shpdte}, {Detail.CurDue}, "monthly"}
the only difference is that instead of Detail.Cusdue it needs to be Detail.Curdue and when i check for errors I get the
"the summary/running total field could not be created"
I use Detail.CurDue in the other two formulas and I do not get error messages. CurDue and CusDue are just dates. (mm/dd/yyyy)
I do not understand why i would get that error message when i subsitute CusDue with CurDue.
Can anyone explain why this is happening and what i can do to get the @ontime% to work with Curdue?
If more information is needed I will gladly supply it.
thanks so much
RI
Crystal Reports 8.5
The report is Ontime delivery report.
The formulas i have that ARE working are as follows:
@On-Time
If {Detail.CurDue} >= {Detail.Shpdte}
Then {Detail.CurDue} - {Detail.Shpdte)
@Ontimecount
If {Detail.Curdue} >= {Detail.Shpdte}
then 1
@ontime%
Sum ({@ontimecount},{Detail.Cusdue}, "monthly" / Count {{Detail.Shpdte}, {Detail.CusDue}, "monthly"}
i need to change the @ontime% to be
Sum ({@ontimecount},{Detail.Curdue}, "monthly" / Count {{Detail.Shpdte}, {Detail.CurDue}, "monthly"}
the only difference is that instead of Detail.Cusdue it needs to be Detail.Curdue and when i check for errors I get the
"the summary/running total field could not be created"
I use Detail.CurDue in the other two formulas and I do not get error messages. CurDue and CusDue are just dates. (mm/dd/yyyy)
I do not understand why i would get that error message when i subsitute CusDue with CurDue.
Can anyone explain why this is happening and what i can do to get the @ontime% to work with Curdue?
If more information is needed I will gladly supply it.
thanks so much
RI