O.K., new problem.
I have a qry which pulls all of the hours recorded by user, by task, by project. It processes extremely fast (6 seconds) considering how much data it pilfers through. That's because I'm doing the sums on the report (by user, by task, by project).
Now, here is the dilemma. If the sum of the hours for a task is 0, I don't want it to show on the report (and no whitespace residue...please). Same for a project...if the sum of hours for the project is 0...don't show and no residue.
I could put the logic into my sql, but then the performance hit would be unbelievable, since it would be calculating a sum for the entire project and the entire task for every row returned (and there are a lot of rows (one per taskid, per week, per user to be precise).
So, the question is, can I do this in the sql and avoid the performance hitch? Or, can I do this on the report somehow?
Thanks in advance.
I have a qry which pulls all of the hours recorded by user, by task, by project. It processes extremely fast (6 seconds) considering how much data it pilfers through. That's because I'm doing the sums on the report (by user, by task, by project).
Now, here is the dilemma. If the sum of the hours for a task is 0, I don't want it to show on the report (and no whitespace residue...please). Same for a project...if the sum of hours for the project is 0...don't show and no residue.
I could put the logic into my sql, but then the performance hit would be unbelievable, since it would be calculating a sum for the entire project and the entire task for every row returned (and there are a lot of rows (one per taskid, per week, per user to be precise).
So, the question is, can I do this in the sql and avoid the performance hitch? Or, can I do this on the report somehow?
Thanks in advance.
