Tutorial: Customers Report

Customers Report

This tutorial demonstrates how to create a grid ready to export reports in PDF and Print friendly reports pages. It also shows how to make a specific calculation inside a grid.

Creating a new Grid

1. Create a new grid application using customers table.

2. Open the Toolbar menu.

3. Select First, Previous, Next, Last, Rows Limit, PDF and Print align to center in Top Toolbar.

Creating the calculated field

4. Open the folder Fields and click in New Field option.

5. Enter 1 for the quantity attribute and click in Next.

6. Choose Text for the Type attribute and define Status to Name and Label, then click in Create.

Field calculation in the OnRecord event

7. Open the Events folder and click in OnRecord option.

8. Add the code below to the event selected:

if({CreditLimit} <= 2000){
{Status} = "Poor";
sc_field_color ("Status", "#AA0000");
{Status} = "Rich";
sc_field_color ("Status", "#0000AA");

9. Click the Run button on the toolbar.

Tutorials in the same category

Analyical Chart

In this example we will see how to create an analytic chart using the Grid application. Creat...

Menu with Chart Applications

This example will use a menu treeview application to display the new charts generated by Scriptcase....

Using the Refined Filter

In this example we will develop a report using the refined filter option, which allows you to filter...

Percentage field

In this example we will see how to use the Percentage field available in the Grid. Configurin...

Comment this post