How Do I Create A Report In Outline Format

  • 1
  • 2
  • Question
  • Updated 2 years ago
  • In Progress
I am creating a database for our department's strategic plan.  I have four tables:
1) Priorities
2) Goals
3) Milestones
4) Outcomes

I need to create a report that looks like the outline below.  I figured out how to do the numbering system.  I just can't figure out how to format a report that looks like this.

1. Priority
    1.1 Goal
           1.1.1 Milestone
                    1.1.1.1 Outcome
     1.2 Goal
            1.2.1 Milestone
                     1.2.1.1 Outcome
                      1.2.1.2 Outcome
             1.2.2 Milestone
                       1.2.2.1 Outcome
2. Priority
     2.1 Goal
            2.1.1 Milestone
                     2.1.1.1 Outcome
Photo of Mary

Mary

  • 240 Points 100 badge 2x thumb

Posted 2 years ago

  • 1
  • 2
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
I'm assuming they are all related in a similar cascading order.

My recommendation is to explore a table report, but focus on the sort & grouping options.  Play around with it, but you should be able to get that affect by grouping several items (low to high)

Priority, goal, milestone, outcome.
Photo of Mary

Mary

  • 240 Points 100 badge 2x thumb
Yes, I have done the best I can with that but it still repeats things or if I group by more than one field, they are listed in the grey bar at the top and that doesn't work because it doesn't show like an outline...thanks