Customers Report

This tutorial shows how to create a grid ready to export PDF reports and print friendly report pages. It also shows how to perform a specific calculation within a grid.

Creating a new Grid

1. Create a new grid application using the customer table.

2. Open the toolbar menu.

3. Select First, Previous, Next, Last, Row Limit, PDF and Print Align to center on the top toolbar.

Creating the calculated field

4. Open the Fields folder and click on the New field option.

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

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

Field calculation in the OnRecord event

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

8. Add the following code to the selected event:

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