Discussions

Expand all | Collapse all

How Do I Create A Report In Outline Format

  • 1.  How Do I Create A Report In Outline Format

    Posted 05-11-2017 19:14
    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


  • 2.  RE: How Do I Create A Report In Outline Format

    Posted 05-12-2017 05:11
    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.


  • 3.  RE: How Do I Create A Report In Outline Format

    Posted 05-15-2017 15:22
    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