[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR output in .csv file
- Subject: [sqr-users] SQR output in .csv file
- From: srikanth reddy <srikanthreddy_mca@yahoo.com>
- Date: Mon, 5 Sep 2005 07:39:48 -0700 (PDT)
- Delivery-date: Mon, 05 Sep 2005 09:40:55 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=FSSxddQeuqdRraV47XcyjKYeXuJniraKgZjUawk9W8EFyXDTljrfAUpRBoyqGSeBmxkaLOEzFL6WWgRg9f0OOcUlb0t/yISCUnISrgty6Bq/XBDoHPCFNzzkI/BM0vARxPHTJYfuoBy0S93Pp3OBBIwVs8KnswvY6uX7WaVSDzU=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hello ,
I am having a two issues while displaying values in the .csv format .
(i) if the Output I want to display is 3,456.234 then in the Excel file 3 is
being displayed in one column and 456.234 is being displayed in another column.
Point to be noted is I have used the technique like '=" || xyz || '"' where xyz
contains the value but still the output is splitted into two different coulmns
in the excel file.
(ii) if the output i want to display is 23.450 then only 23.45 is displayed in
the Excel file. i.e. trailing zero is not displayed.
Can you please suggest a solution for this.
Thanks
Srikanth
---------------------------------
Click here to donate to the Hurricane Katrina relief effort.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users