Skip to Content
Former Member
Apr 28, 2009 at 11:15 AM

HTTP XML Data Source authentication error


Morning All,

I have just started playing around with using XML as a data source for my CR4Ev2.0.1 reports.

I have managed to create the local inline reports and change their data source loacation with no current


I am now trying to create the HTTPXML reports using code from Ted's BLOG.

I manage to create a new report, and can open it in design, I can see the data source structure but as

soon as I try browse the data or preview my report I get the following error

Cannot Open file
Server returned HTTP response code: 407 for URL:

I had a quick look up the 407 error and it seems to be a Proxy authentication error, we do have a proxy

server setup which requires a username and password.

Before I go through what I have tried I want to confess that for this httpxml.xml file all I did was take my

inline.xml file and rename it and make it avaliable via a URL. So this might be the whole problem but I

am sure this is ok.

So I have tried turning off the proxy server as this URL is local so I dont need to go through the proxy.

If I go to the URL in my browser it works fine and I do not need to enter any proxy details.

Thats the problem with my HTTP XML attempt.

If I use the code as is, from Ted's BLOG, for

Crystal Reports off of HTTP XML data URL

and try use the following 2 URLs

"Http(s) XML URL", "");
"Http(s) Schema URL", "");

"Http(s) XML URL", "");
"Http(s) Schema URL", "");

But I get the following errors

Exception in thread "main" Logon 
Error: {0}---- Error code:-2147217393 Error code name:dbLogonFailed 
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
	at com.businessobjects.samples.CreateHttpXML.main(
Caused by: com.crystaldecisions.reports.common.LogonFailureException: Logon Error:{0}
	at Source)
	at Source)

Any ideas as to what my issues are or what I am missing.

Thanks in advance.


Edited by: Darren Jackson on Apr 28, 2009 2:12 PM

Is there any documentation as to what entries I can use in the property bag.

Like is there a ("ProxySet", false) or something along those lines?

Edited by: Darren Jackson on Apr 28, 2009 5:28 PM

I have made a little more head way.

I saved the Orders.xml and Orders.xsd files onto my webserver and editied the code to only worry about

the Orders and ignore the Customer files.

I now create my reports, open them in Eclipse to design them, but when I try preview the data it is now

asking me for a username and password. I have tried all combinations that I can think of for our systems

but none work.