Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FoxFire Report Column Concatenation !
Message
From
12/05/1998 12:14:21
Bilal Bin Tanweer
Global Dispatch Technnologies Inc.
Calgary, Alberta, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Third party products
Title:
FoxFire Report Column Concatenation !
Miscellaneous
Thread ID:
00098786
Message ID:
00098786
Views:
72
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
Next
Reply
Map
View

Click here to load this message in the networking platform