georgia.bloy Posted October 11, 2018 Share Posted October 11, 2018 Hi, currently building a report based on project information from the DWH, I also need to get some data from the transactional database (as this info is unable to be put into the DWH) The main report is using the DWH Bean and have created a sub report using the PPM bean. I need the sub report to be based on the project info of the main report, so how do I pass the project ID as a parameter into the sub-report?Thanks! Link to comment Share on other sites More sharing options...
joseng62 Posted October 12, 2018 Share Posted October 12, 2018 Hi georgia. So in your subreport your need to create a parameter. Lets call it $P{subparam}- So make the change in the subreport.jrxml and then save and then compile to generate/update the subreport.jasper. Then in Main report, select the sub report element. In the properties tab, select tab "Subreport" , then select "Edit Parameters"Then AddThe in Parameter name it will be subparam then the parameter expression would be what ever you want to pass from main. Hope this helps. Cheers. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now