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

1

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

Attachments: 
sagarnikam123's picture
Joined: Nov 1 2012 - 10:33pm
Last seen: 7 months 4 weeks ago

1 Answer:

0

Try with subreport..

ajinkya_c's picture
976
Joined: Aug 29 2012 - 6:13am
Last seen: 2 years 4 months ago

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

sagarnikam123 - 6 years 7 months ago

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.

ajinkya_c - 6 years 7 months ago
Feedback
randomness