sagarnikam123 Posted December 6, 2012 Share Posted December 6, 2012 I am using sample dataset to put problem simply to understand,please dont suggest me to optimize/change mysql logic/queries.I have output of main query in .jrxml file(main table)i am taking "book_id" as user input.want to made subdataset_1 by using "book_id" input & some fields from main table as1)subdataset_1select AuthMn,AuthFN from main_table where BookID=$P{book_id}--->subdataset_12)subdataset_2select AuthMN from subdataset_13)printing subdatset_2 without using any widget from pallete of ireport (e.g. table,crosstab,charts..etc) Can anyone guide my how to access main table's fields & parameters in subdataset_1 ? &accessing fields from subdataset_1 to another dataset ? Link to comment Share on other sites More sharing options...
ajinkya_c Posted December 6, 2012 Share Posted December 6, 2012 Try with subreport.. Link to comment Share on other sites More sharing options...
sagarnikam123 Posted December 6, 2012 Author Share Posted December 6, 2012 I dont want to use subreport,even i used that also,it create problem of importing parameter,some fields from main report. Any how the problem is going to same. @ajinkaya_c can u tell answers for my questions,asked in bottom ? may be logic how to proceed using any tutorials Link to comment Share on other sites More sharing options...
ajinkya_c Posted December 6, 2012 Share Posted December 6, 2012 You can passed parameter as well as field to the subreport and also return the variable to the main report so that i think it is achievable by subreport. 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