[sqr-users] Re: sqr-users Digest, Vol 24, Issue 9

[Kirti <kirti.b@gmail.com>]

The spf also doesnt print the graph when newgraphics flag is set to true.
but when it is false the graph is printed but with default colours.


On 2/21/06, sqr-users-request@sqrug.org <sqr-users-request@sqrug.org> wrote:
>
> Send sqr-users mailing list submissions to
>        sqr-users@sqrug.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://www.sqrug.org/mailman/listinfo/sqr-users
> or, via email, send a message with subject or body 'help' to
>        sqr-users-request@sqrug.org
>
> You can reach the person managing the list at
>        sqr-users-owner@sqrug.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of sqr-users digest..."
>
>
> Today's Topics:
>
>   1. RE: Printing bar graph with specific colors.
>      NewGraphicsdoesnt seem to be working... (Steve Cavill)
>   2. double-sided printing (Mingazov, Maya)
>
>
>
> ---------- Forwarded message ----------
> From: "Steve Cavill" <steve.cavill@infoclarity.com.au>
> To: "'This list is for discussion about the SQR database reportinglanguage
> from Hyperion Solutions.'" <sqr-users@sqrug.org>
> Date: Mon, 20 Feb 2006 22:48:55 +1100
> Subject: RE: [sqr-users] Printing bar graph with specific colors.
> NewGraphicsdoesnt seem to be working...
> Does the spf file have the right colours?  That will help determine if the
> problem is with sqr or sqrw/driver.
> Steve.
>
> -----Original Message-----
> From: sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org
> [mailto:sqr-users-bounces+steve.cavill=infoclarity.com.au@sqrug.org] On
> Behalf Of Kirti
> Sent: Friday, 17 February 2006 6:26 AM
> To: sqr-users@sqrug.org
> Subject: [sqr-users] Printing bar graph with specific colors.
> NewGraphicsdoesnt seem to be working...
>
> [Default-Settings]
> AllowDateAsChar=TRUE
> output-file-mode=long
> OutputTwoDigitYearWarningMsg=FALSE
> UseY2KCenturyAlgorithm=TRUE
> Default-Numeric=Decimal(26)
>
> ;NewGraphics=FALSE
> NewGraphics=TRUE
>
> [Environment:Common]
> SQRDIR=E:\Psoft\CRM89DMO\bin\sqr\ora\BINW
> SQRBIN=E:\Psoft\CRM89DMO\bin\sqr\ora\BINW
> ENCODING=CP1252
>
> [Environment:DB2]
> SQR_DB_DATE_FORMAT=YYYY-MM-DD-HH.MI.SS.NNNNNN
> SQR_DB_TIME_ONLY_FORMAT=HH.MI.SS
> SQR_DB_DATE_ONLY_FORMAT=YYYY-MM-DD
> ;ENCODING-DATABASE-API=UCS2
>
> [Environment:ODBC]
> SQR_DB_DATE_FORMAT=YYYY-MM-DD HH:MI:SS.NNN ;SQR_DB_TIME_ONLY_FORMAT=
> ;SQR_DB_DATE_ONLY_FORMAT= FixODBCAccuracy=TRUE
> ;ENCODING-DATABASE-API=UCS2
>
> [Environment:Sybase]
> SQR_DB_DATE_FORMAT=YYYY-MM-DD HH:MI:SS.NNN
>
> [Environment:Oracle]
> SQR_DB_DATE_FORMAT=DD-MON-YYYY
>
> [Environment:Informix]
> SQR_DB_DATE_FORMAT=YYYY-MM-DD HH:MI:SS.000SQR_DB_DATE_ONLY_FORMAT=YYYY-MM-DD
>
> [HTML:Images]
> Prev-Page=40,40,/sqr_images/prevpg.gif
> Next-Page=40,40,/sqr_images/nextpg.gif
> First-Page=40,40,/sqr_images/firstpg.gif
> Last-Page=40,40,/sqr_images/lastpg.gif
> ;Wallpaper=
>
> [Processing-Limits]
> ;DYNAMICARGS=1500
> DYNAMICARGS=32767
> EXPRESSIONSPACE=65535
> FORWARDREFS=1000
> NUMVARIABLES=1100
> ONBREAKS=75
> POSITIONS=5000
> PROGLINEPARS=65535
> PROGLINES=32767
> QUERIES=1000
> QUERYARGS=4000
> SQLSIZE=30000
> STRINGSPACE=65535
> SUBVARS=10000
> VARIABLES=32767
> WHENS=1000
> ;BREAKS=100
> ;LONGSPACE=32766
>
> [Fonts]
>
> ; The following are SQR predefined font styles.
> ; The numbers on the left are associated with font styles on the right.
> ; Users may define their own associations between font_numbers and font ;
> styles using the font_numbers 900 thru 999.
> ;
> ; Notes:
> ;
> ;   - If SQR does not find a particular font a substitute is used.
> ;   - If a font style (fixed or proportional) is defined inside SQR,
> ;     its style will override the setting in this file.
> ;   - Proportional is assumed if the second field begins with the
> character
> 'p'.
> ;     (i.e., "4=Arial,p" would equate to "4=Arial,proportional")
> ;   - Bold is assumed if a third parameter is supplied.
> ;
> 3=Courier New,fixed
> 300=Courier New,fixed,bold
> 4=Arial,proportional
> 400=Arial,proportional,bold
> 5=Times New Roman,proportional
> 500=Times New Roman,proportional,bold
> 6=AvantGarde,proportional
> 8=Palatino,proportional
> 800=Palatino,proportional,bold
> 11=Symbol,symbol
> 900=unknown,proportional
> 901=Times New Roman,proportional
> 28825=MS UI Gothic,proportional
>
> [PDF Fonts]
>
> ; The following is the list of fonts used for PDF output ; ; Fonts are
> ordered by priority from left.  If a character is not ;
> covered by higher priority font, font with next priority will be used.
> ; Up to 10 fonts can be linked for a font number.
> ;
> ; Font Types Supported for PDF: Adobe Reader Core 14 fonts
> ;                               Adobe Reader Asian Fontpack fonts
> ;                               OpenType/TrueType fonts
> ; OpenType/TrueType font files must be listed in [TrueType Fonts] ;
> section.  OpenType/TrueType fonts are always embedded in output
> PDF ; file as subset.
> ;
> ; Base font number * 100 is a bold variant of the base font.  Font ;
> number 30 to 39 are recognized as italic fonts.  If fonts
> listed ; under these numbers are not bold/italic fonts, bold and italic ;
> effect will be created in output.
> ;
>
> 
>3=Courier,Cumberland,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>300=Courier-Bold,Cumberland-Bold,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>4=Helvetica,Albany,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>400=Helvetica-Bold,Albany-Bold,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>5=Times-Roman,Thorndale,HeiseiMin-W3,MSung-Light,STSong-Light,HYSMyeongJo-Medium,Angsana
>
> 
>500=Times-Bold,Thorndale-Bold,HeiseiMin-W3,MSung-Light,STSong-Light,HYSMyeongJo-Medium,Angsana
> 11=Symbol
> 12=ZapfDingbats
>
> 
>30=Courier-Oblique,Cumberland,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>3000=Courier-BoldOblique,Cumberland-Bold,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>31=Helvetica-Oblique,Albany,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>3100=Helvetica-BoldOblique,Albany-Bold,HeiseiKakuGo-W5,MHei-Medium,STSong-Light,HYGoThic-Medium,Angsana
>
> 
>32=Times-Italic,Thorndale,HeiseiMin-W3,MSung-Light,STSong-Light,HYSMyeongJo-Medium,Angsana
>
> 
>3200=Times-BoldItalic,Thorndale-Bold,HeiseiMin-W3,MSung-Light,STSong-Light,HYSMyeongJo-Medium,Angsana
> 28825=Courier,HeiseiKakuGo-W5
> 28752=Courier,HeiseiMin-W3
> 37110=Courier,STSong-Light
> 37058=Courier,STSong-Light
> 33269=Courier,MSung-Light
>
> [PDF Fonts:Exclusion Ranges]
>
> ; This section specifies exclusion ranges for the range covered by fonts ;
> listed in [PDF Fonts] section.  If exclusion range is
> set, if a ; character is actually covered by a font, the font is not used
> to print ; the character.  Ranges are specified in
> Unicode, in hex or in decimal.
>
> ; No Exclusion range for base configuration
>
>
> [TrueType Fonts]
>
> ; This section specifies the mapping from TrueType font names used in ;
> above configuration section and physical file path of the
> font on ; operating system. For TrueType collection file (.ttc), font
> directory ; number should also be specified.
> ; (ex. font name=file path, directory number)
>
> ; Font Path=directory where fonts resides.  Default is SQRDIR.  On ;
> Windows, Windows font directory will be looked up too.  Fonts
> not ; residing on other directories must be specified full physical
> path.FontPath=e:\psoft\crm89dmo\fonts\truetype\
> Albany=albw.ttf
> Albany-Bold=albwb.ttf
> Cumberland=cumbwr__.ttf
> Cumberland-Bold=cumbwb__.ttf
> Thorndale=thowr___.ttf
> Thorndale-Bold=thowb___.ttf
> Angsana=angsa.ttf
> Font Path=E:\psoft\crm89dmo\fonts\truetype\
> [Colors]
> Color_1 = (255,0,0)
> Color_2 = (0,255,0)
> Color_3 = (0,0,255)
> Color_4 = (230,230,250)
> Color_5 = (0,0,128)
> Color_6 = (0,100,0)
> Color_7 = (255,255,0)
> Color_8 = (210,105,30)
> Color_9 = (0,191,255)
> Color_10 = (255,165,0)
> Color_11 = (255,20,147)
> Color_12 = (238,130,238)
> Color_13 = (127,255,212)
> Color_14 = (255,52,179)
> Color_15 = (238,44,44)
> Color_16 = (205,173,0)
> Color_17 = (227,130,23)
> Color_18 = (59,94,43)
> Color_19 = (51,161,201)
> Color_20 = (173,255,47)
> Color_21 = (25,25,112)
> Color_22 = (160,82,45)
>
> The above is my pssqr.ini file... I have added the NewGraphics flag and
> the color section. I have defined the color palette in my
> sqr and used it in print chart. But the bar graph is not getting printed
> if I keep NewGraphics = TRUE. If it is set to false the
> graph is getting printed. I have read most of the previous posts on this
> topic and tried several different combinations, but I
> cannot manage to print the grpah with the colours I want. Also I get a
> color dataset error when I try to print a graph having more
> than 14 columns with legend. Without legend the limit is 17. I am at my
> wits end trying to figure out what I have missed. Please any
> help would be appreciated.
> In case you want to see the sqr and its output let me know...
>
>
>
>
>
>
>
> ---------- Forwarded message ----------
> From: "Mingazov, Maya" <MMingazov@newsamerica.com>
> To: <sqr-users@sqrug.org>
> Date: Mon, 20 Feb 2006 20:24:40 -0500
> Subject: [sqr-users] double-sided printing
> Does any one know how to get double-sided printed output in SQR?
>
> Any ideas or example of code would be very helpful.
>
>
>
> Thank you,
>
>
>
> Maya Mingazov
>
> Developer, Applications
>
> Information Services
>
> Ph.:  203-563-6448
>
> Fax: 203-563-6503
>
> mmingazov@newsamerica.com <mailto:mmingazov@newsamerica.com>
>
>
>
>
>
> This message and its attachments may contain legally privileged or
> confidential information.  It is intended solely for the named
> addressee.  If you are not the addressee indicated in this message (or
> responsible for delivery of the message to the addressee), you may not copy
> or deliver this message or its attachments to anyone.  Rather, you should
> permanently delete this message and its attachments and kindly notify the
> sender by reply e-mail.  Any content of this message and its attachments
> that does not relate to the official business of News America Incorporated
> or its subsidiaries must be taken not to have been sent or endorsed by any
> of them.  No warranty is made that the e-mail or attachment(s) are free from
> computer virus or other defect.
>
>
>
>
> _______________________________________________
> 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