2 columns Report with multiple records

[Ilya]

In my Report page setup
Columns = 2
with = 4.15"
height = 3.33'
It works OK for displaying single record fields.
Now I need to show in each column several records. Report shows only one
record per column. How to show multiple records in the column like in the
Normal Report?
Thanks in advance.

 

[Duane Hookom]

One record will display in one detail section. I can't imagine what you
expect to display. Perhaps you can type in a little sample of records and
expectations so we can understand.

 

[Ilya]

Each Report Column is Every Label 8364: 3" by 4". I need to display in each
such column :

Athlete Name
SportEvent(1) Time(1)
SportEvent(2) Time(2)
SportEvent(3) Time(3)

Each pair: (SportEvent, Time) belongs to defferent record in the table

 

[Duane Hookom]

If you want multiple records (several for one athlete) printed on a single
label, then I would create a main report of labels based on unique athlete
records. Then use a subreport in the detail section for the sport event and
times.

 

[Ilya]

Thanks for advise, is there a sample of this solution?
Nevertheless, why 3X4 column can not handle mult. recs, like normal detail
section.
The Attribute GrpKeepTogether has choices Per Page and Per Column, meaning
You can keep the group on the column. Is'nt it wright? Where is it in
documentation that column is for single record?
Thanks for help

 

[Duane Hookom]

If your detail section is 3" x 4" then each record in your report's record
source will take up that much space. I would hate to think a single detail
section would be filled with multiple records (other than by some code I
might add).

If you want multiple records than create a 4" wide subreport and add it to a
multiple column main report that is based on only the unique athlete names.
Set the link master/child properties to the athlete primary key or whatever.

 

[Ilya]

My Client is using Every 3x4 Labels for this report. I have no choice for
labels paper format (Lettel with multiple columns - labels), so I have no
choice even for subreport label format. My problem is not "to many records
for labels space". I testet just for 2 records and result is: Access put next
record into the next column(label). Is that the gray area in Microsoft ACCESS
Database? I can solve the problem converting source table into another table
where for each Athlete will be only one record with all sport event fields.
It will take more time and complicate the application. I need from the
Microsoft definite answer: Does Column in the Report support multiple records
or it support only single record?
Thanks in advance

 

[Chuck]

My Client is using Every 3x4 Labels for this report. I have no choice for
labels paper format (Lettel with multiple columns - labels), so I have no
choice even for subreport label format. My problem is not "to many records
for labels space". I testet just for 2 records and result is: Access put next
record into the next column(label). Is that the gray area in Microsoft ACCESS
Database? I can solve the problem converting source table into another table
where for each Athlete will be only one record with all sport event fields.
It will take more time and complicate the application. I need from the
Microsoft definite answer: Does Column in the Report support multiple records
or it support only single record?
Thanks in advance

Open the report in design mode.
Place everything you want, where you want it in the space available for a
single label in txt boxes. delete the labels for the txt boxes themselves.

Example:

Inside first txt box: =Trim([LastName]) & ", " & Trim([FristName])
Inside second txt box: =Trim([Address])
Inside third txt box: =Trim([City]) & ", " & Trim([City]) & " " & Trim([St])

Inside fourth txt box: =and something else
Inside fifth txt box: =and something else
etc

there is a lot of space on a 3*4 label.

Labels will print accross then down

Chuck
--

 

[Duane Hookom]

Why can't you use a subreport on a main report? Do you have questions on the
formatting of either the subreport or the main report?