cancel
Showing results for 
Search instead for 
Did you mean: 

URL reporting export to pdf problem

0 Kudos

We are using SAP Business Objects 4.1 and attempting to use URL reporting to export crystal reports to PDF. We have been doing this in BO 3.x releases and just upgraded to 4.1. Now when we programmatically try to export to PDF we get an HTML formatted message with a NULL crExceptionText. I think I have narrowed the problem down to the http request we are issuing has a null User Agent string. I changed the way I issue the request using PL/SQL to set the user agent string to Mozilla and now we get the PDF returned. Has anyone experienced this issue or is this a known issue? Any help appreciated ....

Thanks,

Tom

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188030
Active Contributor
0 Kudos

Could you post the code you are using?

Thanks,

Bhushan

0 Kudos

Thanks for the response.

We are using PL/SQL procedure to generate PDF from URL posting. Have been doing this successfully with prior version BO 3.x.

x:= UTL_HTTP.REQUEST_PIECES(url,1000);

where x would be the byte array returned from post URL command. get returned html stream with following:

<html>

with a span on <TD class="crExceptionElement"><span class="crExceptionText">null</span><TD>

To get it to work I had to change the way I posted the urlcmd to

http_requ := UTL_HTTP.BEGIN_REQUEST( urlcmd,'GET','HTTP/1.1');

UTL.HTTP.SET_HEADER(http_requ,'User-Agent','Mozilla/4.0'); This is the line that allow the request to complete successfully otherwise I get the same error back. Is this a known requirement of User-Agent string not being null ?

Thanks,

Tom