Jump to content
Changes to the Jaspersoft community edition download ×

How to take parameters & fields from main report's table into subdataset ?


sagarnikam123

Recommended Posts

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)

thousand_questions_frist_table-send.png.e088ac5355a7f48c1ea3d0557d052850.png

i am taking "book_id" as user input.

want to made  subdataset_1 by using "book_id" input & some fields from main table as

1)subdataset_1

select  AuthMn,AuthFN  from main_table where BookID=$P{book_id}--->subdataset_1

2)subdataset_2

select AuthMN from subdataset_1

3)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

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

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