Access 2013 has NO Stepped Layout for reporting

Posted on 2016-10-26
Last Modified: 2016-10-26
Hi Access Folks

I am using Access 2013 and running the Report Wizard against a query I made. per the requirement, the report layout should be "Stepped", but for some reasons I just can't see the option on my wizard's screen. The only options are "columnar", "tabular" and "justified".

I initially thought the reason was that the database was created with Access 2010 then moved 2013, but after I created a new database directly with 2013 and problem is still there. So I have no idea where to find the "stepped" layout. Please help!


Question by:peea
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 41861487
Did you add Grouping level in the wizard process?

Author Comment

ID: 41861493
Thanks for your quick response.

No, there is no any grouping level at all.

FYI: my wizard screen looks like below, but I notice other people's wizard looks like this.
My Access 2010/2013 Report Wizard
I have no idea about what caused the problem. :(

Author Comment

ID: 41861495
FYI - My wizard screens are the same like those at below link, just EXCEPT the layout page!
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 500 total points
ID: 41861496
you need to add grouping level, click Back and grouping level then continue and you will see the "stepped" selection
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 41861498
look for Step 3 in the page you posted above

Author Closing Comment

ID: 41861532
True! Thanks heaps for that!

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question