How Do I Create A Report In Outline Format

Question

I am creating a database for our department's strategic plan. &nbsp;I have four tables:1) Priorities2) Goals3) Milestones4) OutcomesI need to create a report that looks like the outline below. &nbsp;I figured out how to do the numbering system. &nbsp;I just can't figure out how to format a report that looks like this.1. Priority&nbsp; &nbsp; 1.1 Goal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.1.1 Milestone&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.1.1.1 Outcome&nbsp; &nbsp; &nbsp;1.2 Goal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.2.1 Milestone&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.2.1.1 Outcome&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1.2.1.2 Outcome&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.2.2 Milestone&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1.2.2.1 Outcome2. Priority&nbsp; &nbsp; &nbsp;2.1 Goal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2.1.1 Milestone&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.1.1.1 Outcome

mcfneil · Answer

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.

marymary · Answer

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

Forum Discussion

How Do I Create A Report In Outline Format

Related Content

Trying to create a report with an ask users filter, but with a multiselect

AI Smart Builder for Creating Apps and Streamlining Pipelines

create pipeline to create new records based on current record

Summary Reports

Restful API Report digesting JSON