>Hi every One :
>
>Well, I'm using FoxFire for my reporting purposes, I've a report in which I've 0ne to many relationship for example : A Dispatch Zone No & then under this Dispatch Zone we have Multiple Transportation Zones in another table called TRANZONE, the report right now looks some thing like that:
>
>Group : Dispatch Zone # :312
>Addres: 12th Avn, S.W
>
>Tranport
>Zones
>------
> 132
> 143
> 156
> 200
> etc...
>
>My question is, I want my report to look like that:
>
>Group : Dispatch Zone # :312
>Addres: 12th Avn, S.W
>
>Tranport
>Zones
>--------
>132,143,156,200,etc...
>
>
>Group : Dispatch Zone # :316
>Addres: 68100 8th street, N.E
>
>Tranport
>Zones
>--------
>600,643,756,800,etc...
>
>
>Instead of printing the details in a ROW format, I need to concatenate all the details in one column.
>
>Please let me know if anyone needs any further information
>
>Thanx !
>
>BILAL Bin TANWEER

Hi Bilal

Sorry so slow to respond... been at DevCon.

There are a couple of ways you could accomplish the concatenation. The simplist is to add a "custom" data item to FF!'s data dictionary, where the data item expression simply concatenates the desired fields from the many table. Check out the sample data set that shipped with the product for examples how to do this.

Another possibility, when creating the custom data item, is to create a UDF that contenates the fields, and use the UDF in the data item expression. This makes the SQL expression alot more compact, especially if you are concatenating many fields.

A third possibility, which is not very flexible, but may result in faster queries, is to create a Request with all the fields to be contenated as selected to be included in the query. Then, modify the report layout and delete all the individual field expressions, and create a new field expression that concatenates the fields. IOW, do the catenation in the report form, not the SQL query.

Bill