RE: RE: [sqr-users] Using SYLK.sqc - writing currency toaspreadsheetsothat the cu rrency symbol appears on the left

["Jim Womeldorf" <jwomeldo@fastenal.com>]

For creating files using SQR you might take a look at 
http://www.ontko.com/sqr/sylk.html which Ray was kind enough to post it on his 
website.
There is precious little information out there regarding the SYLK file format.  
If you run across anything I'd be interested in seeing it.
Thanks,
Jim

-----Original Message-----
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org 
[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of Paul 
Hoyte
Sent: Wednesday, May 24, 2006 3:42 PM
To: sqr-users@sqrug.org
Subject: RE: RE: [sqr-users] Using SYLK.sqc - writing currency to 
aspreadsheetsothat the cu rrency symbol appears on the left


Speaking about SYLK, is there any type of formal or informal document that 
provides the commands and show the full capability of SYLK.  Seems like it is 
kind of limited based on what I have seen on the board, so just wanted to know 
if any of you gurus out there have done any advanced things with SYLK (using 
SQR to generate the file)..... Thanks in advance for your feedback..
>----- ------- Original Message ------- -----
>From: "Jim Womeldorf" <jwomeldo@fastenal.com>
>To: "This list is for discussion about the SQR database reporting 
>language
>        from Hyperion Solutions."
><sqr-users@sqrug.org>
>Sent: Wed, 24 May 2006 15:29:17
>
>Hi folks,
>I always get a bit excited when I see someone using SYLK.SQC :)  I only 
>deal I English so I have not run into this.
>
>Do a 'save as type' of SYLK to an Excel spreadsheet that is behaving 
>the way you want it to behave.
>(Excel will try to talk you out of it, but be persistent and save it 
>that way anyhow.)
>
>Close Excel and open the file you just saved.  If
>it appears with the formatting as you wish then I must have missed 
>something in coding the SQC.
>Perhaps one of you can figure it out.  
>
>If the formatting is the same as it is with the SQC-created files then 
>it is probably a 'feature'
>of either SYLK or Excel.
>
>Jim
>
>-----Original Message-----
>From:
>sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org
>[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqr
>ug.org] On Behalf Of Sengupta, Rajib (Contractor)
>Sent: Wednesday, May 24, 2006 2:49 PM
>To: This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions.
>Subject: RE: [sqr-users] Using SYLK.sqc - writing currency to 
>aspreadsheetsothat the cu rrency symbol appears on the left
>
>But in excel you can format as French currency in which $ will appear 
>at right. There is some problem in the program
>
>Rajib Sengupta
>Project Manager
>Peoplesoft Consultant - ConagraFoods Inc
>402-952-2144
>
>-----Original Message-----
>From:
>sqr-users-bounces+rajib.sengupta=conagrafoods.com@s
>qrug.org
>[mailto:sqr-users-bounces+rajib.sengupta=conagrafoo
>ds.com@sqrug.org] On Behalf Of Knapp, Richard
>Sent: Wednesday, May 24, 2006 2:16 PM
>To: This list is for discussion about the SQR database 
>reportinglanguage fromHyperion Solutions.
>Subject: RE: [sqr-users] Using SYLK.sqc - writing currency to a 
>spreadsheetsothat the cu rrency symbol appears on the left
>
>
>Talk to Bill (Gates, that is).  This is an Excel problem, not something 
>you can control from SQR especially since the feature is not present in 
>the destination application, no?
>
>Richard Knapp
>AITS - Reporting
>University of Missouri
>Locust Street Building
>Columbia, MO 65201
>573-882-8856
>knappr@umsystem.edu
>
>
>-----Original Message-----
>From:
>sqr-users-bounces+knappr=umsystem.edu@sqrug.org
>[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug
>.org] On Behalf Of SandlerA@DFO-MPO.GC.CA
>Sent: Wednesday, May 24, 2006 1:27 PM
>To: sqr-users@sqrug.org
>Subject: [sqr-users] Using SYLK.sqc - writing currency to a spreadsheet 
>sothat the cu rrency symbol appears on the left
>
>Hi All,
> 
>I have many reports where I am writing both an SQR output and writing 
>to a spreadsheet.  I write to the spreadsheet using SYLK.SQC.  I need 
>to produce the output in both French and English (i.e. if and English 
>user runs the report the headings and formatting are in English while 
>if a French user runs the report, the headings and formatting are in 
>French).
> 
>On many of the reports, I need to write dollar figures to the 
>spreadsheet.
>In English, the format should be $999,999.99.  This
>works without any problem.  In French, the format
>should look like 999 999,99$.  On the SQR output
>this works fine.  However, in writing to Excel, the dollar sign always 
>appears on the left side of the
>number not the right.  The spacing and the commas
>on the spreadsheet do appear where they are supposed; just the dollar 
>sign does not.  The position of the currency symbol should be a 
>function of the Windows regional settings; no matter how I set these, 
>the currency symbol always appears on the left.
> 
>I do need to write these values to the spreadsheet as numbers (not as 
>characters, so I cannot set the format that way).  While the users know 
>that they can change the format on the spreadsheet, they would rather 
>that it appear from the report output as they want to see it.
> 
>We are in a Windows environment.  The reports are generated on a 
>Metaframe server running Windows
>2000.  The users view the spreadsheet on their own
>desktops.  Most of these are running Windows XP and the regional 
>settings are either English or French depending on the users 
>preference.
> 
>The reports are created in SQR version 6.2 and are run as compiled 
>reports from Maximo 4.1.1.
> 
>Does anyone know how I can write to the spreadsheet so that the 
>currency symbol will appear to the right of the number on French 
>reports?
> 
>Thank you.
>Aaron Sandler
>(613) 991-4862 |facsimile/télécopieur (613)
>993-4811
>
>SandlerA@dfo-mpo.gc.ca
><mailto:SandlerA@dfo-mpo.gc.ca>
>
>MIMS Technical Team |Équipe technique SGIE
>
>Canadian Coast Guard|Garde côtière canadienne
>
>437 - 360 Laurier, Ottawa, ON  K1P 1C8
>
>Government of Canada| Gouvernement du Canada
>
>_______________________________________________
>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
>
>_______________________________________________
>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