Using Conditions

Conditions are used in conditional formatting and notifications. You need to create a condition before it can be used. All the activities regarding setting up different conditions are carried out from Conditions screen.

1. On the Desktop Studio screen, click  button on the toolbar.
   OR

2. On the Desktop Studio screen, from Tools menu, click Conditions. The Conditions screen appears.

Figure 6: Conditions screen

You can perform the following actions:

To create a new condition

On the Conditions screen,

1. Click Add The New Condition screen appears.

Figure 7: New Condition screen

1. In Name, specify a unique name for the condition being designed.

2. In Expression, specify the formula followed by an ‘=’ sign and specify expression for the field. Refer to the section ‘Expressions’ below.

3. Click Compile button to check the formula for syntax errors.

4. Click OK to save the save the created condition. The newly designed condition appears in the list on the Conditions

To modify a condition

1. On Conditions screen, select the condition that you want to modify.

2. Click Modify The Modify Condition Expression screen appears.

3. Edit/modify the required details.

4. Click OK to save the changes.

To delete a condition

1. On Conditions screen, click the condition that you want to delete.

2. Click Delete The message, “You are trying to delete the selected item. Are you sure?” appears.

3. Click OK to delete the condition.

Expressions

Following are the expressions:

• To use a text for checking, enclose the text within single quotes, for example: E_Name==’Pinto’.

• To use a date for checking, specify the date in yyyy-mm-dd format and enclose it within single quotes, for example: JoiningDate==’2004-05-30’.

• Numbers can be used as it is, for example, Sales>5000.

If a field of one type is checked with that of another type, then the conditional format will not be applied.

Examples:

if ( empno > 7500) {return true} else {return false}

if ( Sal > 7500) {return true} else {return false}

if (CustNo == ‘Elsa’){return true}

if (ename == ‘Elsa’){return true}

if (empno > 7500 || ename != ‘SMITH’ ) {return true}

if ((sal > 1400 || empno >7500) && (comm > 2)) return true

Conditional Suppressing of Rows through Scripting

You can suppress the display of certain rows as per your requirement, like some column containing NULL values can be suppressed (hidden) from getting displayed on the report.

There are two methods to do this:

• Select the control and set the visible property (Property window) value as false, and assign a 0 (Zero) value to the height property (Property window) of the control.

• On the Desktop Studio screen, from Tools menu, click Scripting. Select the object as Detail and the event as OnFormat.

• Enter the following code:

Object: Detail            Event: OnFormat

Code:

function OnFormat()

{

if ( rpt.Fields(“Name”).value == null )

{

rpt.Sections(“Details”).visible = false;

}

else

{

rpt.Sections(“Details”).visible = true;

}

if ( rpt.Fields(“Name”).value == null )

{

rpt.Sections(“Details”).height = 0;

}

else

{

rpt.sections(“Details”).height = 285;

}

}

Important: To dynamically change the height of a section through a program, the ‘CanGrow property (Properties list) of Detail Section should be set to ‘False’.

If it is set to ‘True’, then the report section will override your (height) value to adjust the height of the section.

Conditional Calculation through Scripting

You can calculate values in the report by giving conditions for calculation. For example, there are two fields in a report Account_type and Amount. There can be two account types say ‘A’ and ‘B’. If you want to sum ‘A’ and ‘B’ separately, enter a JavaScript in the Script Editor as:

Object: Report            Event: OnDataInitialize,

Code:

function OnDataInitialize()

{

rpt.Fields.add(“valueA”);

rpt.Fields.add(“valueB”);

}

 

function OnFetchData(eof)

{

if ( rpt.Fields(“STATUS”).value == “A” )

{

rpt.Fields.(“valueA”).value = rpt.Fields(“CUST_NO”).value

rpt.Fields(valueB”).value = 0;

}

else

{

rpt.Fields(“valueB”).value = rpt.Fields(“CUST_NO”).value;

rpt.Fields(“valueA”).value = 0 ;

}

rpt.Sections(“Detail”).Controls(“extTYPE”).dataField=”valueA”;

rpt.Sections(“Detail”).Controls(“txtORDER_NO”).dataField = “valueB”;

}

This script will add two new fields in the report containing summated values for ‘A’ and ‘B’ account types.