Need Third Part Report Generator as Access adds Trailing Spaces 1

[plang99]

Need Third Part Report Generator as Access adds Trailing Spaces to fields and need no spaces between fields for upload to mainframe as Text file. Need to list one table (Products)in a detail band and one group (Orders and Order Details).

I am used to dBase copy to filename SDF that does it correctly.

I have set the Printer as Generic/Text and Font is Courier 10. Widest column is 214 characters for the Report Header for the Company Information.
Report Footer has Counts and Sums.

Sample report fields:
INPUT DISTRIBUTOR DATA FILE FORMAT



COLUMNS LENGTH DESCRIPTION

DID 1-3 3 Record Type
4-11 8 Distributor ID#
12-15 4 Filler
16-23 8 Week and Date (YYYYMMDD)
24-55 32 Distributor Name
56-87 32 Distributor Address
88-119 32 Distributor Address
120-143 24 Distributor City
144-145 2 Distributor State
146-154 9 Distributor Zip+4
155-174 20 Distributor Contact Last Name
175-194 20 Distributor First Name
195-204 10 Distributor Contact Phone #
205-214 10 Distributor Contact Fax #

UIR 1-3 3 Record Type
4-13 10 UPC
14-17 4 Filler
18-29 12 Unique Item Code
30-69 40 Distributor Item Name
70-73 4 Sticks per Carton
74 1 Promotion Identifier
75-122 48 Promotion Description
123-132 10 Inventory Quantity in Cartons

ROI 1-3 3 Record Type
4-11 8 Customer Number
12-19 8 Customer Shipping Number
20-51 32 Customer Name
52-83 32 Customer Address
84-115 32 Customer Address
116-139 24 Customer City
140-141 2 Customer State
142-150 9 Customer Zip+4

PCH 1-3 3 Record Type
4-11 8 Customer Number (chain)
12-19 8 Customer Shipping number
20-29 10 UPC
30-33 4 Filler
34-45 12 Distributor Item (unique SKU)
46-54 9 Net Quantity Shipped

TTL 1-3 3 Record Type
4-11 8 Distributor ID #
12-19 8 Week End Date (YYYYMMDD)
20-27 8 # of UIR Records
28-35 8 # of ROI Records
36-44 9 # of PCH Records
45-56 12 Ttl # of Cartons over all PCH Records
57-66 10 Not currently used
67-76 10 Not currently used
77-86 10 Not currently used
87-96 10 Not currently used

Sample report:
DID14001111 20001120ANY CIGARETTE DISTRIBUTOR 1234 ANYPLACE DR DEARBORN MI000048126LAST_NAME FIRST_NAME 12345678901234567891
UIR2300110136 012300110136WINSTON K/S 0200N 0000000190
UIR2300111133 012300111133WINSTON LIGHT K/S 0200N 0000000185
UIR2300112130 012300112130WINSTON BOX 0200N 0000000067
UIR2300113137 012300113137WINSTON LIGHT 100 0200N 0000000109
UIR2300114134 012300114134WINSTON 100 0200N 0000000195
UIR2300117135 012300117135WINSTON ULTRA LIGHT 0200N 0000000180
UIR2300118132 012300118132WINSTON ULTRA LIGHT 100 0200N 0000000162
UIR2300119139 012300119139WINSTON LIGHT BOX 0200N 0000000180
UIR2300120135 012300120135SALEM K/S 0200N 0000000191
UIR2300122139 012300122139SALEM 100 0200N 0000000135
UIR2300124133 012300124133SALEM LIGHT K/S 0200N 0000000120
UIR2300125130 012300125130SALEM LIGHT 100 0200N 0000000118
UIR2300126137 012300126137SALEM SLIM LIGHT 100 BOX 0200N 0000000212
ROI8253902082539020CUSTOMER NUMBER 1 720 ELM STREET PONTIAC MI000048341
PCH82539020825390202300126137 012300126137000000010
PCH82539020825390202300124133 012300124133000000009
PCH82539020825390202300114134 012300114134000000005
ROI8356222583562225CUSTOMER NUMBER 2 26081 OAK STREET SOUTHFIELD MI000048034
PCH83562225835622252300110136 012300110136000000008
PCH83562225835622252300111133 012300111133000000015
PCH83562225835622252300114134 012300114134000000020
PCH83562225835622252300120135 012300120135000000021
ROI8357473783574737CUSTOMER NUMBER 3 20041 LOCUST ST SOUTHFIELD MI000048076
PCH83574737835747372300117135 012300117135000000005
PCH83574737835747372300120135 012300120135000000010
PCH83574737835747372300126137 012300126137000000007
PCH83574737835747372300114134 012300114134000000014
TTL140011112000120100000012000000030000000110000000001240000000000000000000000000000000000000000

 

[plang99]

The ROI is the Group Header for Orders
The PCH is the Detail for Order Details

 

[MichaelRed]

plang99,

I'm not sure that you need a third psrty report generator. Access has the capability to generate fixed width output which should be suitable for your purpose. It does not rely on the reports from within MS Access, but would use a recordset as its source. Look at the 'TransferText' function. What you are asking is more than I can contribute in these forums, but it is quite reasonaby accomplished in several ways. Please contact me if you need further assistance.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[plang99]

Thanks.
I looked it up in help and printed it out.
I know the use of recordsets in VB. Will let you know how I do.

 

[plang99]

Even with fixed width export Access adds a trailing space after each field. I need fields that are next to each other with no space between them for upload to mainframe.