Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Batch Report Print

4 posts in DataWindow Last posting was on 2008-07-18 17:40:21.0Z
Jim Posted on 2008-07-18 17:21:47.0Z
Sender: 686e.487e0ea1.1804289383@sybase.com
From: Jim
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Batch Report Print
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4880d12b.52f9.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jul 2008 10:21:47 -0700
X-Trace: forums-1-dub 1216401707 10.22.241.41 (18 Jul 2008 10:21:47 -0700)
X-Original-Trace: 18 Jul 2008 10:21:47 -0700, 10.22.241.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87414
Article PK: 416670

Hi All:

I am using PB 10.5.2(6602) with ASE 12.5. I have a
requirement to print a report in batch. this report should
have all the headers and footers of our application
specificy report.
and i need to schedule it on every friday so and so time and
print to a specific printer.

Has anyone implemented such a solution that can print
powerbuilder report (cause saving as excel or any other
format will loose the header and footer images) in batch on
specific day and time. Any weblinks or code snippets
appreciated.

Thanks
Jim


Dean Jones Posted on 2008-07-18 17:36:46.0Z
From: "Dean Jones" <dean_dot_jones_at_powerobjects_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4880d12b.52f9.1681692777@sybase.com>
Subject: Re: Batch Report Print
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4880d4ae@forums-1-dub>
Date: 18 Jul 2008 10:36:46 -0700
X-Trace: forums-1-dub 1216402606 10.22.241.152 (18 Jul 2008 10:36:46 -0700)
X-Original-Trace: 18 Jul 2008 10:36:46 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87416
Article PK: 416671

we do this all the tme. We create PDF's and e-mail. You could send to a
printer on the network but you might hit security issues. Much easier to
create as a pdf and e-mail. We can also store in a database and e-mail alink
to pull the pdf.

If you need to schedule it I would look at Using EAServer to run your PB
component.

--
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112

TeamSybase
* * Think Sybase * *

<Jim> wrote in message news:4880d12b.52f9.1681692777@sybase.com...
> Hi All:
>
> I am using PB 10.5.2(6602) with ASE 12.5. I have a
> requirement to print a report in batch. this report should
> have all the headers and footers of our application
> specificy report.
> and i need to schedule it on every friday so and so time and
> print to a specific printer.
>
> Has anyone implemented such a solution that can print
> powerbuilder report (cause saving as excel or any other
> format will loose the header and footer images) in batch on
> specific day and time. Any weblinks or code snippets
> appreciated.
>
> Thanks
> Jim


Terry Dykstra Posted on 2008-07-18 17:28:46.0Z
Reply-To: "Terry Dykstra" <dontreply_tddykstra@forestoil.ca.x>
From: "Terry Dykstra" <tddykstra@forestoil.ca>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4880d12b.52f9.1681692777@sybase.com>
Subject: Re: Batch Report Print
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4880d2ce$1@forums-1-dub>
Date: 18 Jul 2008 10:28:46 -0700
X-Trace: forums-1-dub 1216402126 10.22.241.152 (18 Jul 2008 10:28:46 -0700)
X-Original-Trace: 18 Jul 2008 10:28:46 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87415
Article PK: 416672

You can specify the printer in your DW itself:
<DW Control Name>.Modify("DataWindow.Print.PrinterName='<string containing
the printer name for the report output>'")

The easiest is to use the Windows task scheduler to simply call your
application.

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Jim> wrote in message news:4880d12b.52f9.1681692777@sybase.com...
> Hi All:
>
> I am using PB 10.5.2(6602) with ASE 12.5. I have a
> requirement to print a report in batch. this report should
> have all the headers and footers of our application
> specificy report.
> and i need to schedule it on every friday so and so time and
> print to a specific printer.
>
> Has anyone implemented such a solution that can print
> powerbuilder report (cause saving as excel or any other
> format will loose the header and footer images) in batch on
> specific day and time. Any weblinks or code snippets
> appreciated.
>
> Thanks
> Jim


Dean Jones Posted on 2008-07-18 17:40:21.0Z
From: "Dean Jones" <dean_dot_jones_at_powerobjects_dot_com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4880d12b.52f9.1681692777@sybase.com> <4880d2ce$1@forums-1-dub>
Subject: Re: Batch Report Print
Lines: 62
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4880d585$1@forums-1-dub>
Date: 18 Jul 2008 10:40:21 -0700
X-Trace: forums-1-dub 1216402821 10.22.241.152 (18 Jul 2008 10:40:21 -0700)
X-Original-Trace: 18 Jul 2008 10:40:21 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87417
Article PK: 416673

printing is not the issue. he has to run multiple threads to batch multiple
reports, he needs the various parameters in a relative format. Different
parameters are need for different users etc. You need a way to run the
report and schedule it for off hours while specifying how to distribute the
report, i.e. send to a printer. Search the internet there i a company that
has a report write tool built in PB (french company I think) Looks really
nice.

Look at EAS for threading. Then write some really good PB code.

You can look at our product smlPortal, but it will most likely never be
converted to PB11 or EAS6.x

--
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112

TeamSybase
* * Think Sybase * *

"Terry Dykstra" <tddykstra@forestoil.ca> wrote in message
news:4880d2ce$1@forums-1-dub...
> You can specify the printer in your DW itself:
> <DW Control Name>.Modify("DataWindow.Print.PrinterName='<string containing
> the printer name for the report output>'")
>
> The easiest is to use the Windows task scheduler to simply call your
> application.
>
> --
> Terry Dykstra (TeamSybase)
> http://powerbuilder.codeXchange.sybase.com/
> http://casexpress.sybase.com
> product enhancement requests:
> http://my.isug.com/cgi-bin/1/c/submit_enhancement
>
> <Jim> wrote in message news:4880d12b.52f9.1681692777@sybase.com...
>> Hi All:
>>
>> I am using PB 10.5.2(6602) with ASE 12.5. I have a
>> requirement to print a report in batch. this report should
>> have all the headers and footers of our application
>> specificy report.
>> and i need to schedule it on every friday so and so time and
>> print to a specific printer.
>>
>> Has anyone implemented such a solution that can print
>> powerbuilder report (cause saving as excel or any other
>> format will loose the header and footer images) in batch on
>> specific day and time. Any weblinks or code snippets
>> appreciated.
>>
>> Thanks
>> Jim
>
>