Report: subform Want Data to go RIGHT not down

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

Hi, I have a subform on my report. Right now it goes:

Bob Gwynn
T123
T778
T922

I would like for it to go:

Bob Gwynn T123 T778 T922

There is only one field in my subform and I would like the
output to go right instead of down.

Any suggestions would be Extremely Appreciated!!
Thanks,
Christine
 
Use a report rather than a subform. Set the report columns to go across and
then down.
 
Thank You so much for your quick response. I'm still a
little confused.

I'm actually using a sub-report. That's not the problem
though. Even if I were not using any kind of subreport, it
does the same thing. Basically I only have one field in my
Details section. It's that one field I need the data to go
across rather than down.

My actual Data is:

Name Data
Bob T122
Bob T223
Bob T444
Bob T773

I want:
header:
BOB
Details Section:
T122 T223 T444 T773

Can I set the one field to go across, then down?

Thank you so much!
 
Like Duane said, you can set the subreport to use quite a
few pretty narrow columns with the data going Across then
Down (File - Page Setup - Columns menu item). Just be sure
to change the main report's record source query to something
like:

SELECT DISTINCT [Name]
FROM thetable

and set the subreport control's Link Master/Child properties
to the [Name] field.
 
Christine said:
Thank You so much for your quick response. I'm still a
little confused.

I'm actually using a sub-report. That's not the problem
though. Even if I were not using any kind of subreport, it
does the same thing. Basically I only have one field in my
Details section. It's that one field I need the data to go
across rather than down.
Click to expand...

A multi-column report will apply the column settings to all sections except the
Report Header/Footer and the Page Header/Footer. If you have a Group section that
you don't want columns in and a sub-section where you do want columns, then you have
to use a sub-report in the sub-section.

Multi-column sub-reports either have to have CanGrow disabled on the control or use
"Across, Then Down" as the column setting. Since that is what you want anyway it
should work for you.
 
Back
Top