2 Replies Latest reply on Jul 20, 2009 10:39 AM by mmccarty

    Report with only a portion of the records hidden

    mmccarty

      Title

      Report with only a portion of the records hidden

      Post


        Hello,
                I want to create a report that sums the money received for all tasks. Every task is from one for five Areas. So I create a layout that pulls from tasks with a subsummary by Areas and a summary field in the the subsummary part. My boss doesn't want to see all the tasks just the summary. Normmaly that would be easy ( no body) but he does wants to see the tasks for Area 5. More specifically:

      Area 1: 33,222
      Area 2: 67,089
      Area 3: 65,879
      Area 4: 84,494
      Area 5:
           Task 1  7,900
           Task 2  8,978
           Task 3  4,988
                     21,866

      If I try to hide the other tasks with conditional formating, I will have a report with a lot of white space. If I omit the other tasks then the sums for Areas 1-4 will be incorrect.
      Any ideas would be helpful.