Jump to content

Help! Vertical Columns in a Report


This topic is 8510 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello All,

Question about creating a "Report" layout. Is there a way to list records side by side in columns, as opposed to row (ie. next to each other as opposed to one above the other)?

For example, suppose I have 3 fields (Date, Player, Coach). I want to be able view the data as follows (I've inputed fake information for the example):

Date 1/25/01 1/26/01

Player Michael Jordan Kobe Bryant

Coach Phil Jackson Phil Jaskson

Any help would be greatly, grealty appreciated!

Link to comment
Share on other sites

quote:

Originally posted by selikoff:

Hello All,

Question about creating a "Report" layout. Is there a way to list records side by side in columns, as opposed to row (ie. next to each other as opposed to one above the other)?

For example, suppose I have 3 fields (Date, Player, Coach). I want to be able view the data as follows (I've inputed fake information for the example):

Date 1/25/01 1/26/01

Player Michael Jordan Kobe Bryant

Coach Phil Jackson Phil Jaskson

Any help would be greatly, grealty appreciated!

I have been trying to solve this for 5 years. Noone has been able to supply a practical solution yet.

Chris

Link to comment
Share on other sites

Enter Layout Mode and choose "Layout Setup" from the "Layout" Menu. Place a check in the "Print in Columns" option. THen enter the number of desired columns. Then you can place the fields on the layout like this.

Date 1/25/01 1/26/01

Player Michael Jordan Kobe Bryant

Coach Phil Jackson Phil Jaskson

Then resize your Body so it is just large enough to hold those fields mayge 3inches tall. Make sure to leave enough room on the right side for the other two columns to print.

Now enter preview mode to see how it will look when printed.

Hope that helps

G

Link to comment
Share on other sites

I agree with Chris on this one. If you want the records to print:

Record 1 Record 2 Record 3

Record 4 Record 5 Record 6

there is really no easy way (export to Excel?).

The answer G gave you will produce:

Record 1 Record 46 Record 91

Record 2 Record 47 Record 92

Record 3 Record 48 Record 93

.

.

.

where the record number than appears next to Record 1 will depend upon the height of the body part and length of the page.

-bd

Link to comment
Share on other sites

Yup, you're correct. The key here is "in a report". There is a similar question in another thread about multiple columns in Browse mode (which I don't know how to do). Sorry for the brain fade.

Use the Layout setup... options, select the number of columns and "across first". -bd

[This message has been edited by LiveOak (edited January 31, 2001).]

Link to comment
Share on other sites

Using the layout/columns route works except:

You can only see the columns in preview mode and if you are using field labvels down the left side, they will appear in each of the columns.

I can get two columns side by side by creating a self-relationship with a suitable matching field and using a portal with the fields arranged vertically. I have not yet worked out how to use three or four portals showing a different record in each.

Chris

(I have just joined this forum - why am I a 'Junior member' at the age of 62??)

[This message has been edited by Chris Wood (edited February 01, 2001).]

[This message has been edited by Chris Wood (edited February 02, 2001).]

Link to comment
Share on other sites

Originally posted by Chris Wood:

(I have just joined this forum - why am I a 'Junior member' at the age of 62??)

No offence, but aren't you thrilled to be a junior at 62?

Enjoy and take advantage of it.......

------------------

Yeti

Link to comment
Share on other sites

This topic is 8510 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.