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:

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

9. Click the Run button on the toolbar.

Tutorials in the same category

Subquery XML export

1- Create an application of Grid 2- Go to the toolbar option on the side menu to enable ...

Send summary exported by email

In this tutorial we will be looking at how to export the summary and send it by email. Creat...

Send grid exported by email

1- Create an application of the type grid 2- Proceed to go in the side menu Export /...

Advanced Filter Tags (Chart)

In this tutorial we will see how an advanced filter can be applied within a Chart application ...

Comment this post