rmahend Posted October 5, 2017 Share Posted October 5, 2017 HI, I am using Jaspersoft 6.3 and I need to pass the parameter which i created at the main sql and I want to use the same parameter to pass to other SQLs used in the same report. For example, the main SQL used for a pie chart I am using in the report. And I created a diff. sql for the bar chart, but the where clause use the same filter. Please let me know if you need more information.Thanks,Mk Link to comment Share on other sites More sharing options...
rmahend Posted October 5, 2017 Author Share Posted October 5, 2017 Ignore my question. I found the way and used the Report_connection. It works. Thanks Link to comment Share on other sites More sharing options...
reportdev Posted October 5, 2017 Share Posted October 5, 2017 For the subreport, table or chart elements, you would find a Dataset options in the properties pane. You can access a button named Parameters.In the parameter options, a parameter mapping should be done from the main dataset to the sub dataset. 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