My main dataset, based on 'DataTable1' has fields 'PID',. I have created a grouping using the 'PID' field. There are 2 rows in 'DataTable1' so when I preview i do in fact see 2 PID's (this is what I'm expecting).
However, the confusion starts in the Details band.
I have a subdataset based on 'DataTable2' that also has the field 'PID' among other fields. 'DataTable2' has 22 rows. 16 of them below to the first PID group, the other 6 belong to the second PID group.
I've used a table in the Details band to display the 22 rows according to the PID group they below to (16 under group 2, the other 6 under group 2).
However I'm finding that JasperStudio shows me 22 rows for group 1 (i.e. first PID) and 22 rows for group 2 (i.e. second PID). It is not grouping the rows according to the PID it belongs to.
I've tried to add a filter expression at the subdataset level to filter rows where PID in 'DataTable1' equals PID in 'DataTable1', thinking this will group the rows correctly, but I keep getting errors (I am not a techie person so don't know how to write java).
It is worth saying that 'DataTable1' is the main dataset and maps to one block in an xml data adapter. 'DataTable2' is the subdataset and maps to a different block of data in the same XML data adapter. But the thing they have in common in the PID value.
PLEASE HELP, I'M VERY CONFUSED. ANY HELP YOU CAN OFFER WILL BE GREATLY APPRECIATED.
THANK YOU IN ADVANCE