[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Output .csv format not working
- Subject: [sqr-users] Output .csv format not working
- From: "p satheesh kumar" <sathkumar_p@rediffmail.com>
- Date: 7 Oct 2004 09:32:06 -0000
- Delivery-date: Thu, 07 Oct 2004 04:34:03 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi,
I have already sent mail but I didn't include the attachment. Now I attached.
My problem is excel download option. I am integrating coldfusion with cgi and
in cgi I am using sqr to create report.
Checked the below things
- Checked the parameters from coldfusion. Required parameters are coming fine.
- No errors where found in cgi file.
- SQR is able to create the report in .csv format. But not displaying fine (It
displays the path of sqr). Attached the sample report.
Checked SQRIBE_HOME path it is fine in environment. The below code I have used
$sqrcommand1 = "sqrt $Rptsqr $UIDPWD -E$ErrorFile -F$FileName -PRINTER:EP
-EH_CSV ".
" ". "$ID1" ." ". " ".
"\'". "$ID2" ."\'". " ".
" ". "$ID3" ." ". " ".
"\'". "$PARAMETER1" ."\'". " ".
"\'". "$PARAMETER2" ."\'". " ".
"\'". "$PARAMETER3" ."\'". " ".
"\'". "$PARAMETER4" ."\'". " ".
" 1>/dev/null 2>/dev/null" ;
But when I work from the site. It is not showing the output in expected format.
But it is able to create .csv file.
When I use the same in on the server command prompt by giving required
parameters and save the file in .csv it is working fine. The output is
displayed fine.
I have been searching on the internet for the last two days. I am not able to
find any solutions. Can someone help me out?
Thanks in advance,
Satheesh.
Here was a non admissible message part of 'application/pdf' MIME type.
It has been automatically discarded before sending the message to the
list.
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users