[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] SQR to Excel - error in opening the output file.
- Subject: [sqr-users] SQR to Excel - error in opening the output file.
- From: Raghvendra Dharwada <dharwada@gmail.com>
- Date: Fri, 24 Jun 2005 13:36:45 -0700
- Delivery-date: Fri, 24 Jun 2005 15:37:50 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type;b=E8ii4MODB7lzV/0auCFeog0FZ2yywwZUd/A/H7xJEPths9D+KwGVAnmNOSp5IoIRug2/5KMXTn1HCY5hqAJJXDobdMRprQUXeoCr4KoB/WMokZHDp+VdscQcPrIaoeWgU9KA89LYjJRfU3GA6f3TusyvGSkXhpoamfguWB8HKOI=
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi,
I have a custom sqc (MM_EXCEL.sqc) which has several functions for
outputting data from SQR to excel. I am using this SQC in my SQR to print
the output to excel.The excel file is created successfully and also I get
the correct output too in the required format.But then, when I try to open
this excel file I get errors displayed on the Message box saying:
1st Message box:
Cannot read record 7199.
Continue reporting each error?
And when I click 'No' I get the following on the 2nd Message Box:
Microsoft Office Excel cannot convert some of the cells.
The total number of errors found is 1
One of my colleague suggested me to check the cell widths and the numeric
formats of the cells I am going to print. I verified them too, but still I
cannot get rid of the error.
Since this is not a general case, I know, it is hard for someone to provide
a solution, but my hope is that if anyone happened to get similar errors,
please let me know how you
rectified it.
Thanks.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users