kumargsk2014 Posted April 8, 2014 Share Posted April 8, 2014 Hi , I Created UserInteractiveReport using Ireport tool and deployed this JasperReportServer.In Report1 dispalyed data in table and passing query stringto another report(report2) .In Report 2 how to take value from query string that we passed from report1.I Created input control with paramer name butit is not working .please help me in this Link to comment Share on other sites More sharing options...
marianol Posted April 8, 2014 Share Posted April 8, 2014 Can you post some sample reports to have a better idea of what are you trying to achieve? Also which version of iR and JRS are you using? Link to comment Share on other sites More sharing options...
tchen Posted April 9, 2014 Share Posted April 9, 2014 If you are trying to dynamically load SQL query into JasperReports and hoping JR will figure out what fields the query will produce at the run time, it will not work. Report fields ($F{}) in the template (JRXML file) needs to be defined at design time, not run time, in order for you to use them in the report layout.If you can control what columns this passed in report query contains, you can manually define those fields ($F{} name and type) in the report layout, and use !P{parameter1} in the report query to get the data at run time. "parameter1" is a String parameter in your report2 layout. Hope this helps. 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