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

["Bob Stone" <bstone@fastenal.com>]

check the archives - there is a lot of discussion about this.  Jim Womeldorf 
sent out an SQC a few times that had procedures for creating an XLS.

You can also create a CSV, with a .xls and Excel will open it correctly.  It 
doesn't have all the formatting you may want - for that, check the archives.

http://www.sqrug.org/sqr-users/ 

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org 
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org] On Behalf Of 
Jones.Steven@ups-scs.com
Sent: Tuesday, October 23, 2007 10:52 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQR process generating unwanted empty PDF file

How do you generate an xls file from sqr?  I know how to generate a .csv, but 
not an .xls.
-Steve Jones 

-----Original Message-----
From: sqr-users-bounces+jones.steven=ups-scs.com@sqrug.org 
[mailto:sqr-users-bounces+jones.steven=ups-scs.com@sqrug.org] On Behalf Of 
Véronique Mermaz
Sent: Tuesday, October 23, 2007 2:11 AM
To: This list is for discussion about the SQR database reporting languagefrom 
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

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