RE: [sqr-users] SQR process generating unwanted empty PDF file

[Véronique Mermaz <vmermaz@hotmail.com>]

Hi Peter,
 
Well spotted! I tested successfully.
Great thanks,
Veronique
> From: peter.burton@oracle.com> To: sqr-users@sqrug.org> Subject: RE: 
>[sqr-users] SQR process generating unwanted empty PDF file> Date: Tue, 23 Oct 
>2007 05:26:55 -0400> > It is the "Next-Listing" that is causing the issue. Why 
>do you have that in your program if you are not using any PRINT statements.> > 
>Peter> > -----Original Message-----> From: 
>sqr-users-bounces+peter.burton=oracle.com@sqrug.org 
>[mailto:sqr-users-bounces+peter.burton=oracle.com@sqrug.org] On Behalf Of 
>Véronique Mermaz> Sent: Tuesday, October 23, 2007 5:11 AM> To: This list is 
>for discussion about the SQR database reporting language from Hyperion 
>Solutions.> Subject: RE: [sqr-users] SQR process generating unwanted empty PDF 
>file> > > Hi Franck and thanks for your input.> I'm creating an xls file open 
>$Output_Filename_Full as 1 for-writing record={#RecordLength}:fixed Then I'm 
>initiating a string containing tabulations as delimiter and I'm assigning data 
>into it within a begin-sql loop like this let $delimiter = chr(9)> Let 
>$print_Text = $Emplid || $delimiter || $Name || $delimiter> and then I'm just 
>writing my string with > WRITE 1 FROM $print_Text> next-listingAnd I'm closing 
>the file at the end Close 1 I am not using -printer:pd Thanks,> Veronique> > 
>From: franck.masson2002@laposte.net> To: sqr-users@sqrug.org> Subject: 
>Re:[sqr-users] SQR process generating unwanted empty PDF file> Date: Tue, 23 
>Oct 2007 10:44:40 +0200> > you should have the option -printer:pd > 1) supress 
>this option> 2) look to your sqr code and locate any print statement> with the 
>hypotheses that you generate the xls output with the write statement> > 
>Franck,> > > > > > > Message du 23/10/07 10:42> > De : "Véronique Mermaz" > > 
>A : sqr-users@sqrug.org> > Copie à : > > Objet : [sqr-users] SQR process 
>generating unwanted empty PDF file> >> > > > > > Hello, I'm running an SQR 
>process which is supposed to generate an XLS file. It works fine but for an 
>unknown reason an additional empty PDF file is created as well. > > It happens 
>only when the excel file reaches a certain number of lines (more than 60 
>lines).> > Any parameter to increase to fix this issue?Any ideas are welcome. 
>> > ThanksBest regards, Veronique> > > > 
>_________________________________________________________________> > News, 
>entertainment and everything you care about at Live.com. Get it now!> > 
>http://www.live.com/getstarted.aspx> > > > 
>_______________________________________________> > sqr-users mailing list> > 
>sqr-users@sqrug.org> > http://www.sqrug.org/mailman/listinfo/sqr-users> > > > 
>> > Créez votre adresse électronique prénom.nom@laposte.net> 1 Go d'espace de 
>stockage, anti-spam et anti-virus intégrés.> > 
>_______________________________________________> sqr-users mailing list> 
>sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users> 
>_________________________________________________________________> Explore the 
>seven wonders of the world> 
>http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE> > 
>_______________________________________________> sqr-users mailing list> 
>sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users> > > 
>_______________________________________________> sqr-users mailing list> 
>sqr-users@sqrug.org> http://www.sqrug.org/mailman/listinfo/sqr-users
_________________________________________________________________
Explore the seven wonders of the world
http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users