Re: [sqr-users] Using SYLK.sqc - writing currency to aspreadsheetsothat the cu rrency symbol appears on the left

["tgaudioso" <tony0611@verizon.net>]

Hello folks,

  Try this

  let $french_amt = to_char(#your_amt) edit 99999$

   let $print =  '= ($french_amt)'      <== this is the same code to print 
leading zeroes in Excel

   print $print

----- Original Message ----- 
From: "Knapp, Richard" <KnappR@umsystem.edu>
To: "This list is for discussion about the SQR database reportinglanguage 
from Hyperion Solutions." <sqr-users@sqrug.org>
Sent: Wednesday, May 24, 2006 3:15 PM
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


-- 
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.1/344 - Release Date: 5/19/2006




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