[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Printing on the first line
- Subject: [sqr-users] Printing on the first line
- From: "Manoj Singh" <singh_manoj@india.com>
- Date: Mon, 14 Mar 2005 18:01:55 +0800
- Delivery-date: Mon, 14 Mar 2005 05:03:21 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi Guys,
I have a requirement in which I am creating a csv file and where I am summing
up a field after the last record I have fetched I have to put that value on the
first line of CSV file .Is it possible in CSV File ? I have one option where I
can write a sql for sum(salary) write it into the file and then fetch one by
one row and write in a CSV file. Is there any other option.
eg.
o/p Should be
Total salary :10500
emplid salary
0001 5000
0002 3000
0003 2500
--
India.com free e-mail - www.india.com.
Check out our value-added Premium features, such as an extra 20MB for mail
storage, POP3, e-mail forwarding, and ads-free mailboxes!
Powered by Outblaze
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users