Focal Point
[CLOSED] How to create and print a 2 page report

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5987020406

May 18, 2011, 12:41 PM
Rick Man
[CLOSED] How to create and print a 2 page report
This should be simple but I'm missing something.

The short question is how do I create a report that has 2 pages per student. Page one has data on it, page 2 is boilerplate stuff. I would then want to do a double sided print to have page one on one side and page 2 on the other.

The second part is that page one is already in Precision Painter and that may pose another issue. But be that as it may it would be nice to even do the first part.
Thanks,
Rick

This message has been edited. Last edited by: Rick Man,


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
May 19, 2011, 10:57 AM
Francis Mariani
I know nothing about "Precision Painter", but can't you make a two-page "Precision Painter" report, the second page containing your "boilerplate stuff"?


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 19, 2011, 12:34 PM
<JG>
quote:
can't you make a two-page "Precision Painter" report


Actually Francis you can't.

As far as I can see you have to create the two reports and then combine them using the document composer.
or by the old compound syntax.

Both reports have to be either precision report or not precision reports other wise it fails.

The old way is simplest just add OPEN and CLOSE to the PCHOLD statement.

 -* File newfex.fex
TABLE FILE CAR
PRINT
     'CAR.ORIGIN.COUNTRY'
     'CAR.COMP.CAR'
     'CAR.CARREC.MODEL'
     'CAR.BODY.DEALER_COST'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET NEWLAYOUT ON
ON TABLE SET COMPOSITION DEFAULT
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=REPORT,
     NAME=Page,
     METADATA='>GUIDE>show=1,snap=1,<GUIDE<>GRID>show=1,snap=1,sizex=12,sizey=12,<GRID<>RULER>show=0,<RULER<',
$
TYPE=DATAMATRIX,
     NAME=Data Matrix,
     POSITION=(2.000000 2.000000),
     DIMENSION=(6.000000 6.000000),
     METADATA='focusverb=,flags=1>DB>anchor=0,parentanchor=0,flags=1,line=0,item=0<DB<',
$
ENDSTYLE
END
-RUN
TABLE FILE CAR
PRINT
     'CAR.ORIGIN.COUNTRY'
     'CAR.COMP.CAR'
     'CAR.CARREC.MODEL'
     'CAR.BODY.RETAIL_COST'
HEADING
""
FOOTING
""
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET NEWLAYOUT ON
ON TABLE SET COMPOSITION DEFAULT
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = endeflt,
$
TYPE=REPORT,
     NAME=Page,
     METADATA='>GUIDE>show=1,snap=1,<GUIDE<>GRID>show=1,snap=1,sizex=12,sizey=12,<GRID<>RULER>show=0,<RULER<',
$
TYPE=DATAMATRIX,
     NAME=Data Matrix,
     POSITION=(2.000000 2.000000),
     DIMENSION=(6.000000 6.000000),
     METADATA='focusverb=,flags=1>DB>anchor=0,parentanchor=0,flags=1,line=0,item=0<DB<',
$
ENDSTYLE
END
 

May 20, 2011, 08:42 AM
Rick Man
Closer. If the first report is page 1 and the second page 2 I need page 1, page2, page 1, page 2, page 1, page 2, etc.
I tried a by phrase with page-break but got all the page 1s then all the page 2s.


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
May 20, 2011, 09:05 AM
Rick Man
Did some more searching. Am now trying a compound report, but page 2 is overlaying page 1. Any suggestions?


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
May 20, 2011, 04:51 PM
Rick Man
I solved the overlay problem by creating a second page layout and then setting to coordinate. However my real report is created in Precision Painter and when I try to link to it it kicks me out of Dev. Studio.
Looks like Dev. Studio layout composer can not handle a Precsion report


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF
May 22, 2011, 03:26 AM
<JG>
Unfortunately I think that you may have hit a release related issue as it wroks fine in 7.7.0.1
when both reports are precision reports.

-* Default Mode: ResourceLayout
SET HTMLARCHIVE=ON
COMPOUND LAYOUT PCHOLD FORMAT PDF
UNITS=IN, $
SECTION=section1, LAYOUT=ON, METADATA='0.5^0.5^0.5^0.5^4', MERGE=ON, ORIENTATION=PORTRAIT, PAGESIZE=Letter, $
PAGELAYOUT=1, NAME='Page layout 1', text='Page layout 1', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report1', TEXT='report1', TOC-LEVEL=2, POSITION=(0.521 0.521), DIMENSION=(7.500 5.417), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.5in; HEIGHT: 5.417in; OVERFLOW: auto; TOP: 0.521in; LEFT: 0.521in', $
PAGELAYOUT=2, NAME='Page layout 2', text='Page layout 2', TOC-LEVEL=1, BOTTOMMARGIN=0.5, TOPMARGIN=0.5, METADATA='BOTTOMMARGIN=0.5,TOPMARGIN=0.5,LEFTMARGIN=0,RIGHTMARGIN=0,', $
COMPONENT='report2', TEXT='report2', TOC-LEVEL=2, POSITION=(0.417 0.448), DIMENSION=(7.499 6.726), METADATA='Z-INDEX: 100; POSITION: absolute; WIDTH: 7.499in; HEIGHT: 6.726in; OVERFLOW: auto; TOP: 0.448in; LEFT: 0.417in', $
END
SET COMPONENT='report1'
-*component_type report
-INCLUDE report1.fex
SET COMPONENT='report2'
-*component_type report
-INCLUDE report2.fex
COMPOUND END
May 23, 2011, 08:06 AM
Rick Man
Thanks. Yea that's what I'm finding


Reporting Server 7.6.10
Dev. Studio 7.6.8
Windows NT
Excel, HTML, PDF