make records go left to right, not top to bottom?

[stingrae]

I have tow tables:

tabe1 and table2. for each record in table1 there can be multiple records in table2.

I am trying to write a report and instead of each of table2's rows going down the page, i want them to start at the left, and go accross to the right ( i only want 6 of them so it won't run off the page).

does this make sense? is there a way to do this?

[Split]

I would create a query(stored procedure) to combine table1 and table2, so that all records in table2 would become vertical columns
(as you said it will be 6 additional columns), then create your report against new query/stored procedure and report itself will be straightforward task.

[RobDog888]

Sounds like you need to do a Cross Tab query.
What is your db in? Access or SQL or ???

[brucevde]

The Details section can be used to print multiple columns.

Open the Section Expert (Format -> Section menu item or right-click on the details section name and choose Format Section).

Select Details in the section list.

On the Common tab check the Format with Multiple Columns option. A new tab called Layout will become visible.

Enter the required information for your needs.

[Split]

If you use SQL database, then no doubts you should modify data, by rotating table 2 and combining with table 1 and you do not have to jump through the hoops with Crystal

see info on table rotation :

http://support.microsoft.com/default...NoWebContent=1

[brucevde]

That rotating example is fine if Table2 contained the exact same number of rows for each record in Table1.

I understood the original post to mean that table2 may contain 0 to X number of rows per table1 record. There is room to place 6 table2 records on a line. So if table2 contained 30 records, instead of using 30 lines, only 5 lines would be needed.