General information
Category:
Third party products
Title:
FoxFire Report Column Concatenation !
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only