[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

[sqr-users] Re: confirm af2203e0d11e018e78b9fbb5e8c5a1e9fffe57b9



Hi,

I have recently subscribed in sqrug.org. I need clarification.

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.

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