[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2834
  • Last Modified:

Creating an Access report with multiple rows

In order to create an Access report with many columns on one page, some need to be moved to a second line. In design view, Access forces all header and detail fields to occupy a single row. Can header and detail fields be arranged so that each record occupies two rows?
0
greatcomputing
Asked:
greatcomputing
  • 4
  • 4
  • 2
1 Solution
 
JohnSingletonCommented:
yes, set the property "Can Grow" equal to true for both the section you wish to expand (either detail or some other group level)... also set the same property to true on the text boxes you wish to be allowed to expand.

-John
0
 
greatcomputingAuthor Commented:
Access will only allow text boxes and labels to move vertically. After being moved vertically, the remaining text boxes/labels automatically align horizontally.
0
 
JohnSingletonCommented:
AAAAAHHHH, i got you.... you want columns..... nah, only way to do it is to put 2 subreports side by side, then link by child records and kind of filer off certain records from each sub report so to not get duplicates in each column

--for example


main report, with some primary key, linked to child fields in a subreport which is cloned beside each other, the one on the left could have records (1 to recordcount / 2) or every odd one, and the right one (recordcount / 2 to recordcount) or every even one, something like that.

columns aren't easy in access reports, using the same subreport side by side is the only way i'd know to do it. but then you have to get into each one and control what sub-set of records linked to the parent are displayed.

-John
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
greatcomputingAuthor Commented:
To clarify, this is the desired output:

Date     Name     Amount
     Size     Qty
-----------------------------
2/11     Joe     $100
     Lg     1
2/12     Jane     $50
     Med     1
0
 
Jeffrey CoachmanCommented:
greatcomputing,

Try This:

JeffCoachman
db69.mdb
0
 
greatcomputingAuthor Commented:
How can fields in an existing report be arranged so that they match the above sample?
0
 
Jeffrey CoachmanCommented:
Create a blank report
Set the RecordSource to the table
Drop in all the table Fields
Cut the labels and Paste them into the Page Header
Arrange the Headers and footers.
Click: File Page Setup-->Columns
Then copy these settings from my sample to your database.
0
 
greatcomputingAuthor Commented:
After creating a new blank report, Access will not allow the label and its corresponding text box to be separated; for example putting the label in the page header and the text box in the detail area does not work--the label follows the text box and vice versa. This is different from the original report, created using the wizard, where labels are in the page header and text boxes are in the detail area.
0
 
Jeffrey CoachmanCommented:
Regardless of the version, when you first create a simple textbox in Access, the textbox is alway "Joined" to the Label.
In this case you can simply "Cut" the label, and paste it anywhere you like, then they can each be moved independently.

Now, if you create a report from the wizard, the Report's layout may contain textboxes in one section, and the lables in another.
In this case that are separate, and can be moved independently.

You did not specify what version of Access you are/were using, but in Access 2007 there is something called the "Layout" that joins texboxes and labels "across" sections.
If this is what you are referring to, then you have to clear this layout.

Select all the "Linked" controls then click: Arrange-->Control Layout-->Remove
Screenshot attached.

JeffCoachman

untitled.JPG
0
 
Jeffrey CoachmanCommented:
;-)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now