Studio Report Controls - Properties List

Alignment

This property is available in the Property pane if you select a field control from the layout window. This property determines the alignment of the value (left, right or center) within the control.

Figure 2: Alignment

Alignment in Barcode

This property sets the alignment of the caption of the barcode.

Figure 3: Alignment

BackColor

This property is used to set background color of a control or a section.

Figure 4: Back Color

Note: BackColor property will be effective only when BackStyle property is set to ‘Normal (1-ddBKNormal)’.

BackColor in Barcode

This property sets the background color of the Barcode.

Figure 5: BackColor in Barcode

Figure 6: Showing BackColor in report using BackColor

BarWidth in Barcode

This property determines the width of the bars of the barcode.

Figure 7: BarWidth is one

Backstyle

This property will be available in property pane if you select a field control or a section from the layout pane.  Its value determines if background color  will be applicable or not.

Figure 8: Back Styles

You can also perform the same through the Script Editor as shown in the example below:

Object: Detail             Event: OnFormat

Code:

function OnFormat()

{

if (parseInt(rpt.section(“Details”).controls(“txtSales”).dataValue)  > 1000 );

{

rpt.section(“Details”).controls(“txtSales”).backStyle = 1; // Back Style Normal

}

else

{

rpt.section(“Details”).controls(“txtSales”).backStyle = 0;  // BackStyle Transparent

}

}

Border

This property defines the border surrounding the labels and fields.   It can be changed through the shortcut menu or using the script editor.

Figure 9: Different kind of borders applied on controls

Caption

This property is applicable for label controls.  Its value is displayed for the selected label at report execution time.

Caption Position

This property will be there on the property pane when the page header is selected.  Value of this property determines position of page header on report.

Caption in Barcode

Figure 10: Caption on Barcode

Caption is text that is displayed along with barcode.  The caption needs to be used if Barcode is not bound with any DataField.

If the caption is too long for barcode width to adjust, then in the barcode itself the report designer can see a message.  Here the length needs to be increased so that the bars can be adjusted in the barcode area.

Figure 11: Bars in Barcode not fitting

Caption Position in Barcode

It determines the positioning of the numeric value within the barcode.  It can either be placed above (‘Above’) the barcode or at the Bottom (‘Below’) of the barcode.  There is a value which is ‘Blank’ which means even though caption is there the bars would show but caption will not be visible.

Figure 12: CaptionPosition in Barcode

Figure 13: Caption as Blank

Column Direction

This property will be available if you click on a section in the layout pane.  This property determines how Intellicus Studio should print the detail section in a multi-column report.

Figure 14: Column Direction

When ‘DownAcross’ is selected, the printing will go to the next column after the column on the left is completely printed.

Figure 15: Report Print Directions

You can also define the same through Script Editor as shown in the example below:

Object: Detail             Event: OnFormat

Code:

function OnFormat()

{

rpt.Sections(“Detail”).columnCount = 3;

rpt.Sections(“Detail”).columnDirection = 1;}

Data Field

This property is available for a field or a group header section.  It defines the binding field and a group.  This value is set to the name of any field in the data source, or the name of a custom field added into the field’s collection.

Figure 16: Data Fields

When the DataField property is set for the group, records in the detail section will be grouped by this field.

When the DataField property is set for a field, Intellicus Studio binds the field’s data from each record in the database to the selected control. The record set data is first saved into the data value, and then passed through any (defined) output format, to be set as the control’s text.

When using XML the DataField must be set to a valid ‘Xpath’ string.

Important: The base path set by the ‘RecordSetPattern’ is used as the starting node; if a control needs to use a higher level node, use “../” to move back a node.

The DataField property can also be used to perform calculations using scripting expression by stating the property, proceeded by an ‘=’ symbol. This allows the fields to be set up to display the calculated results. Example;rpt.sections(“ghClient”).dataField= “CustomerID”;

Warning: Intellicus Studio will NOT sort the data automatically. The SQL must have proper ‘Order By’ statement in the same sequence in which the report has been grouped.

Data Field in Barcode

It determines the value for which barcode is to be generated.  If the value in Datafield is blank or is no mapped then caption used in ‘Caption’ shall be shown.

Figure 17: DataField in Barcode

Image Source Type

Value of this property decides the source for selected image.

Path: Select this if image is located on local, or a network path that can be accessed from the machine where Intellicus Report Server is running.

URL: Select this if image is to be fetched from a web location.

Binary Data: Select this to pick up the image at run time from a field in database, or embed the image in report (IRL) by picking it up from a path.

Image Path

Value of this property decides the path from where the image should be picked up.

Important: This is the path to the image file on computer where Intellicus report server is running.

Font

This option will be available in the Properties list if you select a label or a field control from the layout pane. The ‘Font’ property allows you to set font name, size, styles, and effects. When you select this option from the Properties list, Font dialog box will appear to select various options for the font.

You can also change the font settings for a control at runtime, depending on conditions applied on the same. The following examples sets the sales figure above a certain value to a bold, underline format.

For above, you can use Conditional Formatting feature too.

Object: Detail            Event: OnFormat

Code:

function OnFormat()

{

if (parseInt(rpt.sections(“Details”).controls(“txtSales”).dataValue) > 10000 )

{

rpt.sections(“Details”).controls(“txtSales”).bold = true;

rpt.sections(“Details”).controls(“txtSales”).font.underLine = true;

}

else

{

rpt.sections(“Details”).controls(“txtSales”).bold = false;

rpt.sections(“Details”).controls(“txtSales”).font.underLine = false;

}

}

Font in Barcode

This property sets the font of the caption on the barcode.  The ‘Font’ property allows you to set font name, size, styles, and effects. When you select this option from the Properties list, Font dialog box will be displayed for you to select from various options.

You can also change the font settings for a control at runtime, depending on conditions applied on the same.

Figure 18: Font on Barcode

Forecolor

This will set the foreground (text color) of the selected control. When you choose this option from the properties window, a color palette will open up to choose colors from.

Figure 19: ForeColor (text color) applied on a control

You can also change the forecolor (text color) of a control by writing a script.  The following example will display a red colored ‘confidential’ text at the top-left corner of each page.

Object: Detail            Event: OnFormat

Code:

function OnFormat()

{

rpt.Sections(“Detail”).Controls(“txtSales”).foreColor = 25545255;

}

Forecolor in Barcode

This will set the fore color of the bars in the barcode.  You can choose this option from color palette which is available in ForeColor property.

Figure 20: ForeColor in Barcode

Keep Together

This property will be available on property pane if you select the group section (header or footer). This option applies to group header sections and determines whether group header and group footer sections will print on the same page or not.

Figure 21: Keep Together

You can achieve the same through the Script Editor. For example, rpt.sections(“GHCategory”).grpKeepTogether = true;

Height in Barcode

Using the Height property you can set the height of the barcode.  The height is the complete height of the barcode control. It defines the section’s height in twips.

Figure 22: Height of the Barcode control

Figure 23: Height of Barcode control and caption

This property will be available in property pane when a field control is selected.  It sets the distance of left boundary of the control from the left edge of the report page.  The unit of measure is pixels.

Left

This property will be available in property pane when a field control is selected.  It sets the distance of left boundary of the control from the left edge of the report page.  The unit of measure is pixels.

Left in Barcode

This property will be available in property pane when a field control is selected.  It sets the distance of left boundary of the control from the left edge of the report page.  The unit of measure is pixels.

Figure 24: ‘Left’from report Page

Figure 25: ‘Left’from report Page

Line Color

This property will be available in property pane when a Line control or Shape control is selected.  It defines the color of the Line used to draw the line or shape.  You can select a color from the available options or can create color as per the need.

Line Style

This property is available in property pane when a Line control or Shape control is selected.  Its value determines the style of line that will be applied to the selected control.

Figure 26: Line Style

Line Weight

This property will be available in the property pane when Line control or Shape control is selected.  It defines the thickness of line.  A value of zero will not draw line. The line will become thicker with higher values.  Unit of measure of thickness of line is pixels.  You can select a color from the available options or can create color as per the need.

Figure 27: Line of various thickness

New Page

This property will appear in property pane when you click on an empty part of detail section.  The value set for this property will determine if the section should be printed before having a page break or after having a page break.  It does not apply to a page header or a page footer section.

Figure 28: New Page

To utilize this facility through the Script Editor, follow the given example.

OnPages

This property will appear on property pane when the Page Header or the Page Footer is selected.   Set this property to control appearance of the Page header or Page footer section.

This property will be effective on the Page Header or Page Footer whichever is selected while setting value of this property.

Picture

This property will be available when a picture control is placed on the report (and is selected).  This property sets the picture that will be placed on the report at run time.  The image types that you can use are:

• bmp

• ico

• jpg

• cur

• gif

• wmf

If the image you have selected is larger than the placeholder the image will be auto-cropped equally from all the sides.  If it is smaller than the placeholder, Intellicus will add equal amount of empty space on all the sides around the image.

PictureAlignment

This option will be available if you select a picture from the layout pane.

0-Top Left             1–Top Right         2-Center               3-Bottom Left       4-Bottom Right

Figure 29: Picture Alignment

Shape

This option will be available if you select a shape control.  The value set for the property will decide shape of the control.

Figure 30: Shapes

Style in Barcode

It determines the style of the barcode.

Figure 31: Style in Barcode

The styles that Intellicus supports are:

• CODE128 (Default)

• CODE128_RAW

• CODE128_UCC

• EAN13

• EAN8

• UPCA

• UPCE

• Interleaved2Of5

• Planet

• PostnetZIP

• PostnetZIP4

• PostnetZIP4DP

• 3Of9

• 3Of9X

• Codabar

• PDF417

• Datamatrix

• SUPP5

NOTE: There are certain requirements with some of the styles.  It is suggested that report designers should know the styles that they are using in the report.

Examples:

The EAN13 style requires a minimum of 13 characters in data field.

The EAN8 style requires a minimum of 8 characters in data field.

The EAN13 style requires numeric value in data field.  It won’t work if barcode is set on String value.

Summary Function

This option will be available if you select a field control from the layout pane.  It sets the type of the summary function used to process the selected field’s values. You can use this function to create sub totals, grand totals, and other summary values.

Figure 32: Summary Function

Summary Group

You can apply page numbers at group level.  Select the group on which the page numbers are to be applied.

Select SummaryRunning as RunGroup at ‘n’ Page numbering.  Select SummaryRunning as None ‘m’ Page numbering to get the page count for each group.

Figure 33: Summary Group

Summary Running

This option will be available if you select a field control from the layout pane.  It determines whether the summarization will be accumulated or reset for each level (detail-, group- or page).