Grid with drill down

This tutorial shows how to create a link between two grid step parameters and a method to detail the total values ​​of the report.

Creating Grid master/detail

1. Create a new grid application based on the Orders table. This will be the master query and it will be called grid14.

2. Create a new grid app based on the order_details table. This will be called grid14_1.

3. Edit the grid grid14_1. In the application menu, click the SQL item

The string in the square bracket is a global variable used to get the parameter sent by the master application.

4. Now, click on the Generate Font icon on the main ScriptCase toolbar.

5. Go to the “Fields >> New field” option in the application menu to create the new “detail” field of the type text.

Creating a link

6. Click on Links between Applications.

7. Choose Field as the link type and choose the detail field, then click Next.

8. Find and select the application grid14_1 and click Next.

9. Define the parameter is sent to grid14_1 detail. Click on the Field option and choose the OrderID field, then click Next.

10. In the Link Operation Mode property, choose the Modal option.

11. Click on the “Run application” button.

Tutorials in the same category

Tutorial: Saving Report Views

In this example, we will see the options available for the end user to store, in session or in a...

Tutorial: Grid with modal filter.

This tutorial will show how to configure a query filter to display in a modal window, using the res...

Export Option

To export different types of files we must carry out the following steps: 1 - Create a Grid ...

Integration with WhatsApp

To integrate WhatsApp with ScriptCase, we will be using a specific API called Chat-API, it is a...

Comment this post