Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Different print of detail lines
Message
From
27/10/2005 21:21:47
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Different print of detail lines
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01062846
Message ID:
01062846
Views:
50
I want to build a report that lists all of items of a certain kind in a continuous list then goes to next group and does same. The data is grouped by type number (1 – 4).

I need something like this:

Commodities:
COTTON & RAYON THROWS, NOS | COTTON YARN, NOS | COTTON CLOTH, NOS
COTTON MADE UPS | COTTON BAGS, NOS | COTTON BUDS, NOS
COTTON WOOL, ABSORBANT, NOS | COTTON DYED POPYLIN | COTTON PIECE GOODS,NOS
COTTON RUGS,NOS | |


Origins:
Houston, TX | Galveston, TX | New Orleans, LA
Tampa FL | |


Destinations:
ABOSHI | ABU | ABURATSU
KOBE |

Equipment:
40FT 8'6" | 45FT 8'0" | 48FT 9'6" High Cube
20 FOOT 2C |

The data comes from a flat DBF with two fields Descript, Group_type

Sample Data
COTTON GIN MACHINERY PARTS, 1
COTTON SEEDS, NOS 1
COTTON SEED, NOS 1
COTTONSEED OIL, N.O.S. 1
COTTON SEED,NOS 1
COTTON PICKING MACHINERY, NOS 1
COTTON YARN, NOS 1
COTTON GIN MACHINERY, NOS 1
COTTON, NOS 1
COTTON WASTE/ LINTERS, NOS 1
COTTON & RAYON THROWS, NOS 1
COTTON FLOOR COVERINGS,NOS 1
COTTON KNITED GARMENTS,NOS 1
HOUSTON, TX 2
Galveston, TX 2
New Orleans LA 2
Tampa FL 2
ABOSHI 3
ABOSHI 3
ABU 3
ABURATSU 3
ABURATSU 3
KOBE 3
40FT 8'6" 4
45FT 8'0" 4
48FT 9'6" High Cube 4
20 FOOT 2C 4
Next
Reply
Map
View

Click here to load this message in the networking platform