Creating an Access report with multiple rows

greatcomputing
greatcomputing used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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

Author

Commented:
Access will only allow text boxes and labels to move vertically. After being moved vertically, the remaining text boxes/labels automatically align horizontally.
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
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

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
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
greatcomputing,

Try This:

JeffCoachman
db69.mdb

Author

Commented:
How can fields in an existing report be arranged so that they match the above sample?
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
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.

Author

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.
MIS Liason
Most Valuable Expert 2012
Commented:
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
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
;-)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial