Jump to content
Changes to the Jaspersoft community edition download ×

How can I use XML column in Jasper iReport?


soumyadeeplodh

Recommended Posts

I have one database(MySQL) where data type of one column is XML. Like the table name is 'class_5_student' and two columns is there- 
 
> std_roll_num [iNT]
> std_dtl
 
for example 
std_roll_numstd_dtl
1<std_1>
<name>Tom</name>
<age>10</age>
<roll>1</roll>
</std_1>
2<std_2>
<name>Sam</name>
<age>11</age>
<roll>2</roll>
</std_2>
3<std_3>
<name>Lisa</name>
<age>10</age>
<roll>3</roll>
</std_3>

I know how to connect XML datasource and fetch data from XML file. Is it possible to get data from above table and generate report like -

NameRollAge
Tom110
Sam211
Lisa310

Every time I connect this DB, I always get XML column as string.

Please help.

 

 

 

 
 
 
 
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...