I'm testing out this process with simple car files, but I'm not getting the results I expected. I made a coordinated compound report with the PDF layout painter. When I run the report, I get a PDF that I expect (15 pages that are sorted by country). However, bursting is not creating the desired results. When I burst to email, each user is getting a 15 page report with the Average Cost report on multiple pages for their burst Country. When I burst the report to the libray I'm getting gibberish:
%PDF-1.4
6 0 obj
<<
/Length 7 0 R
>>
stream
BT /F1 1 Tf ET
0 g
/GS1 gs
0 Tc
0 Tw
0 G
0 J 0 j 1 w 10 M []0 d
1 i
10 0 obj
<<
/Length 11 0 R
>>
stream
BT /F1 1 Tf ET
0 g
/GS1 gs
0 Tc
0 Tw
0 G
0 J 0 j 1 w 10 M []0 d
1 i
BT /F1 1 Tf 0.00 0.00 0.00 rg 12 0 0 12 6 762 Tm (AVERAGE COST)Tj
12 0 0 12 192 750 Tm (AVE)Tj 12 0 0 12 285 750 Tm (AVE)Tj
12 0 0 12 6 738 Tm (COUNTRY)Tj 12 0 0 12 92 738 Tm (BODYTYPE)Tj 12 0 0 12 192 738 Tm (DEALER_COST)Tj 12 0 0 12 285 738 Tm (RETAIL_COST)Tj
ET 0.00 0.00 0.00 RG 6 732 m 56 732 l S 92 732 m 149 732 l S 192 732 m 271 732 l S 285 732 m 364 732 l S
BT 12 0 0 12 6 714 Tm (ENGLAND)Tj 12 0 0 12 92 714 Tm (CONVERTIBLE)Tj 12 0 0 12 235 714 Tm (7,427)Tj 12 0 0 12 328 714 Tm (8,878)Tj
12 0 0 12 92 702 Tm (HARDTOP)Tj 12 0 0 12 235 702 Tm (4,292)Tj 12 0 0 12 328 702 Tm (5,100)Tj
12 0 0 12 92 690 Tm (SEDAN)Tj 12 0 0 12 228 690 Tm (13,067)Tj 12 0 0 12 321 690 Tm (15,671)Tj
ET endstream
endobj
7 0 obj
893
endobj
12 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
13 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
14 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
15 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
16 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
17 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
18 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
19 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
20 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
21 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
22 0 obj << /Type /Page /Parent 5 0 R /Resources 4 0 R /Contents [6 0 R ]>> endobj
4 0 obj
<<
/ProcSet [/PDF /Text /ImageC]
/Font <<
/F1 23 0 R
>>
/XObject <<
>>
/ExtGState <<
/GS1 2 0 R
>>
>>
endobj
5 0 obj
<<
/Types /Pages
/Kids [12 0 R 13 0 R 14 0 R 15 0 R 16 0 R 17 0 R
18 0 R 19 0 R 20 0 R 21 0 R 22 0 R ]
/Count 11
/MediaBox [0 0 612 792]
>>
endobj
23 0 obj
<<
/Type /Font
/Subtype /Type1
/Encoding /WinAnsiEncoding
/Name /F1
/BaseFont /Courier
>>
endobj
3 0 obj
<<
/Type /Halftone
/HalftoneType 1
/HalftoneName (Default)
/Frequency 60
/Angle 45
/SpotFunction /Round
>>
endobj
2 0 obj
<<
/Type /ExtGState
/SA false
/OP false
/HT /Default
>>
endobj
1 0 obj
<<
/Type /Catalog
/Pages 5 0 R
>>
endobj
xref
0 24
0000000000 65535 f
0000013178 00000 n
0000013099 00000 n
0000012967 00000 n
0000012555 00000 n
0000012685 00000 n
0000000010 00000 n
0000000989 00000 n
0000001021 00000 n
0000001650 00000 n
0000001682 00000 n
0000002677 00000 n
0000011631 00000 n
0000011715 00000 n
0000011799 00000 n
0000011883 00000 n
0000011967 00000 n
0000012051 00000 n
0000012135 00000 n
0000012219 00000 n
0000012303 00000 n
0000012387 00000 n
0000012471 00000 n
0000009024 00000 n
0000009056 00000 n
0000010624 00000 n
0000010657 00000 n
0000011609 00000 n
0000000029 00001 f
0000000030 00001 f
0000000031 00001 f
0000000032 00001 f
0000000033 00001 f
0000000034 00001 f
0000000035 00001 f
0000000036 00001 f
0000000037 00001 f
0000000038 00001 f
0000000000 65535 f
0000012852 00000 n
trailer
<<
/Size 24
/Root 1 0 R
>>
startxref
13233
%%EOF
Here is the code for the coordinated compound report I'm working with.
COMPOUND LAYOUT
UNITS=IN, $
SECTION=section1, LAYOUT=ON, MERGE=ON, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
pagelayout=1, name='Layout page 1', $
component='report2', type=report, position=(0.837 0.936), dimension=(6.101 8.586), $
pagelayout=2, name='Layout page 2', $
component='report3', type=report, position=(0.412 0.248), dimension=(7.566 9.796), $
pagelayout=3, name='Layout page 3', $
component='report1', type=report, position=(0.941 1.127), dimension=(7.186 9.066), $
END
SET COMPONENT='report2'
-*component_type report
TABLE FILE CAR
PRINT
LENGTH
WIDTH
BY COUNTRY
BY BODYTYPE
BY MODEL
HEADING
"CAR SPECS"
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT PDF
END
SET COMPONENT='report3'
-*component_type report
TABLE FILE CAR
PRINT
COMPUTE MODEL2/A15 = EDIT(MODEL, '999999999999999');
DEALER_COST AS DCOST
RETAIL_COST AS RCOST
BY COUNTRY
BY BODYTYPE
HEADING
"COST DIFFERENCES"
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT PDF
END
SET COMPONENT='report1'
-*component_type report
TABLE FILE CAR
SUM
AVE.DEALER_COST
AVE.RETAIL_COST
BY COUNTRY
BY BODYTYPE
HEADING
"AVERAGE COST"
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT PDF
END
COMPOUND END
Bethany
Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server