how to inject multiple tables in the report, using XML data source instead of database ?

[#1]

hello
i am working with java with spring environment and crystal reports jars , i am trying to inject multiple tables in the rpt report, using XML data source instead of database ( because our database is a nosql database and sometimes we have to fetch the data manually from other services , so connecting to a database is not optional )

Can anyone provide a sample code on how to do so , and if it is required to have a database connection can it be H2 database at least ( or any other virtual database ) ?

[DonWilliams]

The best way to test to see if what you want to do is supported by CR or if CR is capable do it first in CR Designer.

Add your multiple Tables from XML data source and link all table, CR is a Relational Database Reporting tool so you must link the tables.

See if this helps:

Download our SAP Crystal sample database in MS Excel format:
https://crystal-reports-downloads.s3.amazonaws.com/Ridin-Round.xls

It can be done using the Eclipse or CRS/BOE Java SDK's but you do need to validate it works first, tables must have a field them can be linked on.

Note, if you can't link the tables then use a subreport to add the table to and link the subreport to the main report.