Passing Parameters to Nested Grid

Applications Grid / Reports
#1

Hi Friends,

I need help on the following scenario :

  1. I have a grid with Search Options
  2. On the grid, I have a nested grid which linked to value “[glo_custno]” (on nested grid) to “CustNo” (on main grid) AND “[glo_date]” (on nested grid) and “Inv_Date” (on main grid).
  3. “CustNo” is a field BUT INV_Date IS a “SEARCH” field, which accepts “BETWEEN TWO VALUES” Date
  4. In another word, I want to pass “CustNo” and TWO values of “INV_Date” from main grid to nested grid.
  5. In SQL Section of NESTED grid, I have the following "SELECT …, … , … FROM INVDetails WHERE DET_CustNo = ‘[glo_custno]’ and (DET_Date >= ‘[glo_date]’ and DET_Date <= ‘[glo_date]’) <= (How do I filter between two values if passed from main grid). The first filter "DET_CustNo = ‘[glo_custno]’ " works O.K. but the second filter, how?

Please help.