Simple drill down
In this tutorial is demonstrated how to create a link between two grids passing parameters and a method to detail report total values.
Creating Master/Detail grids
1. Create a new grid application using Orders table. This is the Master grid, and define the app name to grid14.
2. Create a new grid application using order_details table . Define the app name to grid14_1.
3. Open to edit grid14_1 and go to SQL option
 |
 |
|
 |
||
 |
 |
4. Add the line below to SQL Select Statement: The string between brackets is a global variable used to get the parameter sent by master application.
WHERE
OrderID = '[v_order]'
5. Now, click in Generate Source icon in ScriptCase main toolbar.
|
|
|
 |
||
|
|
Creating a Link
5. Open to edit grid14.
|
|
|
 |
||
|
|
6. Open Links folder in menu, and click in New Link
|
|
|
 |
||
|
|
7. Now, click in Create New Link option.
8. Choose Field as link type and choose PriceOrder field, then click Next.
|
|
|
 |
||
|
|
9. Choose grid14_1 and click in Next
10. Define the parameter is sent to detail grid14_1. Click in Field option and choose OrderID field, then click in Next.
|
|
|
 |
||
|
|
11. In Link Operation Mode property choose Open in other window option.
|
|
|
 |
||
|
|
| Rate this Tutorial | |||||||
|
|||||||
|
