Printable View
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?
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.
Sounds like you need to do a Cross Tab query.
What is your db in? Access or SQL or ???
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.
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
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.