We are using Apex version 24.2 .
Using Interactive Grid i created Master-Child report .
Master report has Sales Order details like order_id,order_number , customer .Child report has the Order_Number, Line_Id ,qty,item_name.
Child report have created “ITEM_NAME” as link invoking a modal page.But on this the selected record “LINE_ID” is not being passsed.
Will try to explain with an example,below is data so for Order_Number-1001 we have 2 records or “LINE_ID” and for ORDER_NUMBER=3004 we have 3 records.We can only select 1 record at a time.
So if i select the first record i.e LINE_ID-321345 it passes to the modal page the LINE_ID=321346.
Similarly if i select Line_id = 546523 or 546524 it is always passing the last value i.e 546525.
So for some reason IR is always selecting the last record in Order.
Please suggest how to solve this issue
ORDER_NUMBER LINE_ID ITEM_NAME QTY
1001 321345 Bread 20
1001 321346 Biscuit 30
3004 546523 Chicken_legs 20
3004 546524 Fish_chop 100
3004 546525 Wings 90