Solved

Access 2013 has NO Stepped Layout for reporting

Posted on 2016-10-26
6
25 Views
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!

FYI

thanks,
P
0
Comment
Question by:peea
  • 3
  • 3
6 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 41861487
Did you add Grouping level in the wizard process?
0
 
LVL 7

Author Comment

by:peea
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. :(
0
 
LVL 7

Author Comment

by:peea
ID: 41861495
FYI - My wizard screens are the same like those at below link, just EXCEPT the layout page!

http://www.gcflearnfree.org/access2013/advanced-report-options/1/
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 119

Accepted Solution

by:
Rey Obrero 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
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 41861498
look for Step 3 in the page you posted above
0
 
LVL 7

Author Closing Comment

by:peea
ID: 41861532
True! Thanks heaps for that!
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

708 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now