Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Bursting Coordinated Compound report built in PDF Layout Painter
Go
New
Search
Notify
Tools
Reply
  
Bursting Coordinated Compound report built in PDF Layout Painter
 Login/Join
 
Platinum Member
posted
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
 
Posts: 188 | Registered: April 14, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
According to IBI

WebFOCUS ReportCaster Release 7.6.0 is the first release that provides
support for coordinated compound report burst distribution in all supported
formats (PDF and DHTML).


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Does anyone know if there are any supported formats for Report Caster 7.1?


Server Environment: Win2K3 Server WebFOCUS 7.13 Apache Tomcat standalone application server
 
Posts: 188 | Registered: April 14, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Can't you just do it the old fashioned way?

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 OPEN
END

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

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 CLOSE
END


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Bethany,
I think that you had best go with Prarie's comments, or upgrade to a 76 release where compound bursting is supported.
As far as I know there is no bursting format available in 81 for what you need to do. So either upgrade or split the request so that it creates the correct compound report for each user that needs to receive it. That may result in a lot of extra work, but it will do the trick in your 713 version.

Hope this helps ...


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
Virtuoso
posted Hide Post
quote:
...When I burst the report to the libray I'm getting gibberish:

That is the "PDF" code but I don't know if there may be bad characters /data corruption/ etc. For whatever reason, it is not being recognized as a PDF document so it is being displayed as text. Try saving that file to your desktop and see if you can re-open with Adobe Reader and see what you get.

In any case, as was mentioned, 7.6.x is the version that fully supports what you are wanting to do easily. I think I have an example of doing this the "old" way - I'll see if I can find it.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Bursting Coordinated Compound report built in PDF Layout Painter

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.