print records in one line

rbuser

Hi,

i have the following report -

XYZ company
Client 1
Client 2
:
:
Clinet n
ABC Company
Client 1
Client 2
:
:
Clinet n

i want it like the following -

XYZ company
Client1, Client2, Client3 .... Client n
ABC company
Client1, Client2, Client3 .... Client n


if the first line fills up, the Clients for the particular company should
print on the second line and so on.

the query brings the company name and client 1 as one record, company name
and client 2 as the second record and so on.

Thanks

digitalmetaphors

This can be accomplished using a master detail report. The master can print
the company name and the subreport can be set to print small detail bands
from left to right. Set the sub detail band's ColumnTraversal property to
ctLeftToRight.

Do you have one table on the database with this data? If so, you can create
a query that returns all of the distinct companies (a master dataset). Then
create a detail query on the same table that returns the clients for each
company. Now you can create two datapipelines, one for the master report and
one for the subreport.


Cheers,

Jim Bennett
Digital Metaphors