RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4

["Peter Burton" <peter.burton@oracle.com>]

MiMi,

Nope ... You must use Declare-Layout to set "Landscape" mode.

What is the problem with having the SPF file being created anyway?

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 Mimi 
Bekele
Sent: Tuesday, July 10, 2007 12:55 PM
To: This list is for discussion about the SQR database reporting language from 
Hyperion Solutions.
Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4

Thanks again Peter. I see I'm using the declare-layout to set the report
type to landscape. I don't know if there is another way of achieving
this without actually using the declare-layout. 

Below you will see my code. Please let me know if you have any
suggestions

Begin-Setup 
  Declare-Layout default
    top-margin  = 0
    left-margin = 0
    max-lines   = 58
    max-columns = 176
  End-Declare
End-Setup 


Thanks,
MiMi 
-----Original Message-----
From: sqr-users-bounces+mimi.bekele=medimpact.com@sqrug.org
[mailto:sqr-users-bounces+mimi.bekele=medimpact.com@sqrug.org] On Behalf
Of Peter Burton
Sent: Tuesday, July 10, 2007 9:42 AM
To: This list is for discussion about the SQR database reporting
language from Hyperion Solutions.
Subject: RE: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4

MiMi,

Here are some of them ...

declare-toc
declare-report
declare-layout
declare-printer
declare-procedure
use-procedure
alter-printer
use-report
use-printer-type
toc-entry
print-direct printer=XXX

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 Mimi Bekele
Sent: Tuesday, July 10, 2007 12:31 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] RE: sqr-users Digest, Vol 41, Issue 4


Peter,

Thanks for the info. You mentioned the -KEEP , -PRINTER:xx and SQR
commands could cause the creation of the .SPF file. Do you know what are
some of the sqr commands that could cause the creation of the .spf file?
The reason I'm asking is if I knew what the commands are maybe I can
re-write the program so that it will not create the .spf file.

Thanks,
MiMi 




------------------------------------------------------------------------
------------------------------------------------
This transmission, together with any attachments, is intended only for
the use of those to whom it is addressed and may contain information
that is privileged, confidential, and exempt from disclosure under
applicable law.  If you are not the intended recipient, you are hereby
notified that any distribution or copying of this transmission is
strictly prohibited.  If you received this transmission in error, please
notify the original sender immediately and delete this message, along
with any attachments, from your computer.


_______________________________________________
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


------------------------------------------------------------------------------------------------------------------------
This transmission, together with any attachments, is intended only for the use 
of those to whom it is addressed and may contain information that is 
privileged, confidential, and exempt from disclosure under applicable law.  If 
you are not the intended recipient, you are hereby notified that any 
distribution or copying of this transmission is strictly prohibited.  If you 
received this transmission in error, please notify the original sender 
immediately and delete this message, along with any attachments, from your 
computer.


_______________________________________________
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