display xml data

[junioryy]

hi all experts,

 

may i know how can i display xml data instead of whole xml in the jasper report?

 

for example :

 

<?xml version="1.0" encoding="UTF-8"?>

<logRecord>

<logField

className="my.com.infopro.icba10.kernel.system.domain.Branch"

fieldName="branchType" oldValue="04" newValue="T8"/>

<logField

className="my.com.infopro.icba10.kernel.system.domain.Branch"

fieldName="country" oldValue="AUS" newValue="COL"/>

<logField>

</logRecord>

 

 

What i need is only the fieldname and the value as below:

 

branchType: 04

country: AUS

 

the xml is in java string. so may i know what is the appropriate textfield expression and class type that i need to set?

 

so far i have convert the xml string to an object and pass as parameter to jasper. is it the correct way or got any good solution?.

 

 

Any help and opinion would be highly appreciated.

 

Thanks in advance

[andreas.daab]

Use your xml file as datasource. In the field "Create a data source using ths expression" put "/logRecord". Then create a field. Call it e.g. myField and use "logField/@oldValue" as field description.

[junioryy]

Hi andreas.daab,

 

really thanks for your reply. however, the xml file is located in DB and i will retrieve it based on the search critea. so currently, im using Database JDBC Connection to retrieve the data..

 

besides the xml file, i also need to display others data such as user info and address.. so, how can i use the xml as datasource and Database JDBC Connection concurrently? is it possible ?

 

Really appreciated if can hear from you again

 

Thank you so much!!

Post edited by: junioryy, at: 2007/05/23 02:34

[andreas.daab]

I would do it with java code

1. Read the XML-File from your database and save it to a file

2. Read the other fields from database and put them into Objects, e.g. Strings or a HashMap.

3. Create a JRXmlDataSource

Code:

JRXmlDataSource dataSource = new JRXmlDataSource("file.xml", "/logRecord"«»);

4. Create a parameter HashMap

Code:

[code] Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put("PARAM1", "value1"«»);

PARAM1 is String in this example, but it can be an instance of every class.

5. Create a JasperPrint Object

Code:

[code] JasperPrint jasperPrint = JasperFillManager.fillReport("myreport.jasper", parameters, dataSource);

6. Add your parameters ("PARAM1") to your report