how to create two columns below a line of heading

[maddoxkyle]

hello.. i want to create something like this in a report but im having
a hard time trying to do it..


LastName FirstName MI Other Info
Other Info

lab1 5 lab5 7
lab2 4 lab6 5
lab3 6 lab7 8
lab4 8


i'd like the name and some info to stay in a single line, and the lab
activities and scores to be displayed in two columns.. any help will
be very much appreciated. thanks.. =)

 

[Allen Browne]

In report design view, open the Page Setup dialog.

On the Column tab, uncheck the 'Same as Detail box.'

Set the column width to be less than half available space.
(Available = paper width less left and right margins.)

Close the dialog. You can now make the report wider, typing whatever you
need into the Page Header.

 

[maddoxkyle]

Thanks for the tip.. i hope you can help me again with this new one..
I created a main report, then inserted a subreport with two columns..
I wanted it to appear like this: (the main report and subreport are
linked by ID numbers)

1 LastName FirstName MI Other Info

lab1 5 lab3 7
lab2 4 lab4 5


2 LastName FirstName MI Other Info

lab1 5 lab3 7
lab2 4 lab4 5


3 LastName FirstName MI Other Info

lab1 5 lab3 7
lab2 4 lab4 5




but the report displays the subreport repeatedly, like this:


1 LastName FirstName MI Other Info

lab1 5 lab3 7
lab2 4 lab4 5

lab1 5 lab3 7
lab2 4 lab4 5

lab1 5 lab3 7
lab2 4 lab4 5

lab1 5 lab3 7
lab2 4 lab4 5



2 LastName FirstName MI Other Info

lab1 5 lab3 7
lab2 4 lab4 5

lab1 5 lab3 7
lab2 4 lab4 5
.........


any ideas on how i can fix this? i want the subreport to appear only
once
for each record on the main report. Thanks a lot in advance.. =)

 

[Allen Browne]

Sounds like the linking is not set up correctly.

1. Open the main report in design view.

2. Right-click the edge of the subreport, and choose Properties.

3. Fill in the Link Master Fields and Link Child Fields.