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
issues.
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: http://myserver/httpxml.xml
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
propertyBag.put( "Http(s) XML URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/orders.xml"); propertyBag.put( "Http(s) Schema URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/orders.xsd");
propertyBag.put( "Http(s) XML URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/customer.xml"); propertyBag.put( "Http(s) Schema URL", "http://resources.businessobjects.com/support/downloads/samples/cr/customer_db/customer.xsd");
But I get the following errors
Exception in thread "main" com.crystaldecisions.sdk.occa.report.lib.ReportSDKLogonException: Logon
Error: {0}---- Error code:-2147217393 Error code name:dbLogonFailed
at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
........
at com.crystaldecisions.sdk.occa.report.application.DatabaseController.byte(Unknown
Source)
at com.crystaldecisions.sdk.occa.report.application.DatabaseController.addTable(Unknown
Source)
at com.businessobjects.samples.CreateHttpXML.main(CreateHttpXML.java:90)
Caused by: com.crystaldecisions.reports.common.LogonFailureException: Logon Error:{0}
at com.crystaldecisions.reports.queryengine.Connection.br(Unknown Source)
at com.crystaldecisions.reports.queryengine.Connection.bs(Unknown Source)
................
Any ideas as to what my issues are or what I am missing.
Thanks in advance.
Darren
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.
Grrrrrrrrrrrrrrr