i am using mysql database,ireport 4.7
i created main dataset (e.g. A) in a report,i want to use some fields from maindatset A to create subdatset B.
then wants to create subdataset C ( by taking some fields from parameters ,some from A & some from subdataset B)
and at last wants to prints table C
i tried to combine all my queries into single querie,but it ends on complex queries & all frustations
how sould i proceed ? is there any tutorial/how to for this ?