Crystal Reports generation from XML datasource or file.

[Former Member]

How to generate the crystal report(.rpt file) from XML/XSD file as input..?

I'm trying out this from 'Crystal Reports in Eclipse'.

[ted_ueda · Accepted solution]

[Crystal Reports for Eclipse Version 2 - Programmatically Create Reports off of XML or Web Services Data Sources|https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12990] [original link is broken] [original link is broken] [original link is broken];

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

Hi Ted,

thank you for providing a good link. I just tried with program what he had given, it's throwing a error like this.

"Failed to load the database connector 'crdb_xml.dll'.

Could you help out how can i come out of that error.

Thanks,

[Former Member · Accepted solution]

Same problem here using CR4J v.2 sp1<BR/>

This is the complete StackTrace:<BR/>

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: Error al cargar el conector de base de datos. No se pudo obtener acceso a la clase 'com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader'.---- Error code:-2147467259 Error code name:failed
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.if(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.PrintOutputController.export(Unknown Source)
	at com.businessobjects.samples.InformePruebaXML.main(InformePruebaXML.java:64)
Caused by: com.crystaldecisions.reports.common.QueryEngineException: Error al cargar el conector de base de datos. No se pudo obtener acceso a la clase 'com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader'.
	at com.crystaldecisions.reports.queryengine.Connection.ur(Unknown Source)
	at com.crystaldecisions.reports.queryengine.Connection.uB(Unknown Source)
	at com.crystaldecisions.reports.queryengine.Connection.br(Unknown Source)
	at com.crystaldecisions.reports.queryengine.Connection.bs(Unknown Source)
	at com.crystaldecisions.reports.queryengine.Connection.t1(Unknown Source)
	at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.a(Unknown Source)
	at com.crystaldecisions.reports.dataengine.dfadapter.DFAdapter.for(Unknown Source)
	at com.crystaldecisions.reports.reportdefinition.ReportHelper.a(Unknown Source)
	at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.long(Unknown Source)
	at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.a(Unknown Source)
	at com.businessobjects.reports.sdk.requesthandler.ReportViewingRequestHandler.int(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.do(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.if(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.a(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.a(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter$2.call(Unknown Source)
	at com.crystaldecisions.reports.common.ThreadGuard.syncExecute(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.for(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.int(Unknown Source)
	at com.businessobjects.reports.sdk.JRCCommunicationAdapter.request(Unknown Source)
	at com.businessobjects.sdk.erom.jrc.a.a(Unknown Source)
	at com.businessobjects.sdk.erom.jrc.a.execute(Unknown Source)
	at com.crystaldecisions.proxy.remoteagent.RemoteAgent$a.execute(Unknown Source)
	at com.crystaldecisions.proxy.remoteagent.CommunicationChannel.a(Unknown Source)
	at com.crystaldecisions.proxy.remoteagent.RemoteAgent.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.ds.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
	at com.crystaldecisions.sdk.occa.report.application.ReportSource.a(Unknown Source)
	... 4 more
Caused by: java.lang.reflect.InvocationTargetException
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	... 32 more
Caused by: com.businessobjects.reports.jdbinterface.common.DBException: No se pudo cargar el conector de base de datos 'crdb_xml.dll'.
	at com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader.loadDriver(Unknown Source)
	... 36 more

Edited by: Asier Camara Martin on Jun 1, 2009 2:16 PM

[ted_ueda · Accepted solution]

Do you have XMLConnector.jar deployed in your app?

That's the XML connectivity libs.

Sincerely,

Ted Ueda

[Former Member · Accepted solution]

arg! no, the XmlConector.jar wasn't include in the crystal library in eclipse.

Now it's working fine, thanks a lot.

[Former Member · Accepted solution]

I could not able to find 'XMLConnector.jar' in my crystal reports libraries in eclipse. Where can i download it..?

please provide me the path?

[Former Member · Accepted solution]

thx ted..It's working!!!!!!

[Former Member · Accepted solution]

HI.

I am having the same problem with the missing DLL for xml reports, but I cannot find the XMLConnector.jar anywhere.

I am using Eclipse 3.6.0.

The Crystal plugin for Eclipse (2.0.6.r916) was downloaded and added manually into Eclipse (unzipped into the folder).

Where can I find the XMLConnector.jar?

Thanks.

[Former Member · Accepted solution]

Hi there,

Can we download this Jar somewhere.. or is it available in the standard shipment now..!?

thanks

Domnic

[Former Member]

Hi,

I designed a report in Crystal report with XML datasource for a webservice call. In crystal report it is working fine but failing in Java(Using eclipse and tomcat) with below error

Error loading database connector. The class 'com.crystaldecisions.reports.queryengine.driverImpl.DriverLoader' could not be accessed.

All other reports with jdbc/jndi working fine from java. Could you please advise if I am missing some java files and where to down load?

Thanks in advance

Thomas

[Former Member]

Hi,

1) Open the Crystal report with XML datasource connectivity in the Crystal Report designer.

2) Click on File ->Report Options.

3) Uncheck the Verify On First Refresh box.

4) Save the Crystal report.

5) Open this Crystal report in Crystal Report for Eclipse designer and try Executing it again.

Please let me know the results.

Thanks,

Neeraj

[Former Member]

Hi ,

I wanted to implement complete flow in CR4E itself. In java, I just need to pass XML file and XSD file programatically(boz UI implemenation is not impl yet) and it has to generate .rpt file. I will make use of rpt file to generate report.

[Former Member]

Hi,

I believe you might not be able to browse the data fields from the XML file although

the XML Data Source Connection is build successfully and able to ping it?

A work around is to design the reports from Crystal Reports Designer and import it to Eclipse.

Please let me know the results.

Thanks,

Neeraj