Jump to content
Changes to the Jaspersoft community edition download ×

subreport data is null


junioryy

Recommended Posts

Hi all experts,

 

i have created 1 master report and 1 subreport. master report is using database JDBC connection while the subreport is using xml datasource. the subreport with xml data will be displayed based on the seach criteria in the master report.. however when i run the report , the subreport data is null.. i truly ran out of idea what is goin wrong..

 

below is the detail of my report setting:

 

master report:

 

i use datasource expression with value: new JRXmlDataSource($F{XML_LOG},

$P{XPATH_SELECT_EXPRESSION})

 

parameter: USR_ID, expression - $F{USR_ID}

 

report query: select * from TEST where USR_ID='USER5'

 

Subreport :

 

field- $F{XML_LOG} - java.lang.string

Report query : select * from TEST WHERE USR_ID = $P{USR_ID}

 

 

fyi, the XML_LOG that from master report query is java.io.InputStream and the xml wil be display based on the search criteria..

 

and i create the xml datasource using the below expression:

/logRecord

 

Any help would be highly appreciated..

 

thanks in advance!!

Post edited by: junioryy, at: 2007/05/28 08:50

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...