Focal Point
ReportCaster print multiple copies

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

June 20, 2012, 11:55 AM
Robert B Clark
ReportCaster print multiple copies
Looking for a way in ReportCaster to print multiple copies of the same document.
I'm setting up a job that prints a schedule to a printer, but I need to print for 40 people.
I don't really want it to run the job 40 times, just once then print 40 times.
Also, is there a way to control or pass other printer parameters such as double-sided, staple, etc.?


Robert B. Clark -- Business Systems Analyst
Daimler Trucks North America
Phone: 503.745.7057
"There's always a better way."
IBM Mainframe zOS 8.1.05, DB2 adapter
WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
June 20, 2012, 02:18 PM
Prarie
You really have to send it to a printer, e-mail won't do?

Anyway you can set up a printer distribution list.
June 20, 2012, 02:40 PM
Robert B Clark
Good suggestion Prarie. Thank you.
But email won't work completely. People can't carry around an email and the supervisors need to hand out many copies for their personnel. The Distribution List solves the Quantity issue (albeit not to elegant) but it does not solve the printer options issue for a 20 page schedule that I want to print double-sided and stapled.


Robert B. Clark -- Business Systems Analyst
Daimler Trucks North America
Phone: 503.745.7057
"There's always a better way."
IBM Mainframe zOS 8.1.05, DB2 adapter
WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
June 21, 2012, 09:41 AM
Alex
Where I was able to control or have influence on this sort of thing, we sent and emailed report to the individuals concerned then if they needed to print it they did it themselves. This way they the printing is diverted to the appropriate departments budget for the paper, ink and equipment costs associated.


WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF
June 21, 2012, 10:47 AM
Tom Flynn
We save trees by creating Shared Drives on the network for each department and FTPing 1 copy to a folder on that departments shared drive.
Then, each person within the department that has access to the folder now has access to the report.

They then can do with it what they wish....


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
June 21, 2012, 04:26 PM
Robert B Clark
Unfortunately Tom, they wish it to be printed... for them... lots and lots of copies.
Confused


Robert B. Clark -- Business Systems Analyst
Daimler Trucks North America
Phone: 503.745.7057
"There's always a better way."
IBM Mainframe zOS 8.1.05, DB2 adapter
WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
June 22, 2012, 07:35 AM
Don Garland
Here is an idea, loop on your last HOLD file creating many sets of the same data. Index with a seq field, output to PDF for print page breaking on the seq field.

I hope this doesn't make me the bad guy.

  


SET BYDISPLAY = ON

DEFINE FILE CAR
SEQ/I4 = 1;
END
TABLE FILE CAR
PRINT COUNTRY MODEL CAR
BY SEQ
ON TABLE HOLD AS CARTEST1
END
-RUN

-REPEAT :LOOPING FOR &N FROM 2 TO 5;
-SET &FSEQ = &N - 1;

DEFINE FILE CAR
SEQ/I4 = &N;
END
TABLE FILE CAR
PRINT COUNTRY MODEL CAR
BY SEQ
ON TABLE HOLD AS CARTEST&N
MORE
FILE CARTEST&FSEQ
END
-RUN
-:XXXIT
-:LOOPING


TABLE FILE CARTEST5
PRINT 
     'CARTEST5.CARTEST5.COUNTRY'
     'CARTEST5.CARTEST5.MODEL'
     'CARTEST5.CARTEST5.CAR'
BY 'CARTEST5.CARTEST5.SEQ' NOPRINT
     
ON CARTEST5.CARTEST5.SEQ PAGE-BREAK
HEADING
"Multiple Page Report "
" "
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
$
TYPE=DATA,
     COLUMN=N1,
     FONT='ARIAL',
$
TYPE=DATA,
     COLUMN=N2,
     FONT='ARIAL',
$
TYPE=DATA,
     COLUMN=N4,
     FONT='ARIAL',
$
TYPE=DATA,
     COLUMN=N3,
     FONT='ARIAL',
$
TYPE=TITLE,
     COLUMN=N1,
     FONT='ARIAL',
$
TYPE=TITLE,
     COLUMN=N2,
     FONT='ARIAL',
$
TYPE=TITLE,
     COLUMN=N4,
     FONT='ARIAL',
$
TYPE=TITLE,
     COLUMN=N3,
     FONT='ARIAL',
$
TYPE=HEADING,
     LINE=1,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=14,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=1,
     SIZE=14,
     STYLE=BOLD,
$
ENDSTYLE
END
-RUN





This message has been edited. Last edited by: Don Garland,


WebFOCUS Administrator @ Worldpay FIS
PROD/DEV/TEST: 8204, SANDBOX: 8206 soon - BIP, Reportcaster, Resource Manager, EUM, HyperStage soon, DB: HIVE,Oracle,MSSQL
June 22, 2012, 07:07 PM
Robert B Clark
Don, thanks for the suggestions and sample code. That looks very plausible. Can ReportCaster handle that?
I guess I'll test and find out. Smiler


Robert B. Clark -- Business Systems Analyst
Daimler Trucks North America
Phone: 503.745.7057
"There's always a better way."
IBM Mainframe zOS 8.1.05, DB2 adapter
WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter
June 25, 2012, 11:45 AM
Darin Lee
Another way that we resolved a similar issue was to set up a specific print queue on the printer where the defaults woudl be the special instructions needed. Most high-capacity printers now have the ability to handle multiple queues. So if you set up a new queue where all documents would be printed double-side with staples, you could just specify the print queue along with the printer address in ReportCaster and the printer would just take care of everything. In fact you could probably also specify for the queue that you always wanted 40 copies and then you wouldn't even need the distribution list.

Just a thought-


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
June 25, 2012, 03:08 PM
Robert B Clark
Great info Darin. In talking with our Printer Queue guy, that is exactly what I'm working on right now. I'm just trying to get the PS output to be passed correctly to the new queue. One printer supports PS, the other doesn't, which is hampering progress.


Robert B. Clark -- Business Systems Analyst
Daimler Trucks North America
Phone: 503.745.7057
"There's always a better way."
IBM Mainframe zOS 8.1.05, DB2 adapter
WF 8.1.05 Hub to Sub, Self-Service, SQL Server adapter