General information
Category:
Reports & Report designer
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
Next
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