General information
Category:
Reports & Report designer
Ok, lemme see if I have this right. If every row has a value, it sums correctly? (You're sure it's not just reprinting the last row in the group footer?), but if _any_ of the rows have a 0 in them, it sums to 0?
If that's it, that's really strange, but I want to make sure I have it right before I try to figure it out. :)
Michelle
>The column in the report displays hours spent on a job. Since it is crosstabular you suggested using Evaluate(field(2)) for example. I am grouping the data on direct and indirect jobs by week in a given month. I want to sum the hours per week. Putting the Evaluate(field(2)) in the group footer does the job fine. However, when a particular week of a given month has no data a zero is printed in the group footer. How can I keep the zero from printing? I tried putting Evaluate(field(2)) > 0 in the print when true box. But this evaluates the last row only. Even if several rows have values for that week if the last row is blank no total is given.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only