Some thought needs to take place when designing data table output. The data could be 1 row or it may be 15. So defining an area for displaying this data is required so it doesn't overwrite text.

Setting Up the Base

1. Select the "Panel" tool from the Standard Component Menu and draw a box on the page in the required location ensuring the box covers the desired area on the page.

Setting Up the Header

1. From the Bands tools menu, select a Column Header and click in the panel box made in previous one. The Band will be orange in colour and will snap to the top of the panel box
   
   Bands consist of 2 parts - The header in the solid colour with name of the object & The light colour section that contains your information.

2. Select the "Text" tool from the Standard Component Menu and draw a box on the light coloured section, go into the design view and enter your first column name. Repeat for reach column heading.
   

Setting Up the Data Output

1. From the Bands tools menu, select a Data and click in the bottom of the panel box made earlier. This will bring up a window to select the data source.
   
   Under the MS SQL header select the type of information you are reporting on and click ok.
   The Band will be blue in colour and will snap below the header in the panel box.
   
   The Band consists of 2 parts - The header in the solid colour with name of the object with is Data Source & The light colour section that contains your information.

2. Select the "Text" tool from the Standard Component Menu and draw a box on the light coloured section, go into the design view and insert your data field. Repeat for reach field required in the report.
   

Things to remember:

• Without the panel created first up, the header and data bands snap to the top of the page.

• When creating the text boxs in the heading the size of the box is displayed (also whilst resizing) noting these can help speed up the data layout.

This will show you the available helper functions to display data in meaningful ways on you report.

URL
Code: {Url()}

Returns: http://www.transvirtual.com.au/

Convert Weight

Code: {ConvertWeight(Value, From UOM, To UOM)}

Available Units Of Measure

Returns: Value

Convert Length

Code: {ConvertLength(Value, From UOM, To UOM)}

Available Units Of Measure

Returns: Value

Get Larger Number

Code: {GetLargerNumber(Value1, Value2)}

Example: {GetLargerNumber(100, 200)}

Returns: Value

Route Zone Detail

You would use this for example if your agent requires routing information on the label.

Code: {RouteZoneDetail(Consignment ID, Agent ID, Field Required)}
Example: {RouteZoneDetail(ConsignmentItems.IdConsignment, null, "long") }
Field Required: "long" or "short" zone Name
Returns: Value

Format Type
This is used in conjunction with other rules to get required output.

Code: {FormatType(Type Name, Value)}
Example: {FormatType("InvoiceDueDateType", 1) }
Returns: The display name of the type

Format Currency Margin

Code: {FormatCurrencyMargin(Value, Margin)}
Example: {FormatType(10.10, 15) }
Returns: $11.62

Format Range

Code: {FormatRange(from, to)}
ESample: {FormatType(1, 5) }
Returns: "1,2,3,4,5"


GS1 Barcode
To create a GS1 barcode the sender must have a GS1 assigned company number. Visit here for details https://www.gs1au.org. The GS1 Consignment Prefix can be entered in the customer card as a "Consignment Prefix"

This is used as part of the GS1 barcode generator.

Code: {Gs1Barcode(Consignment ID, "401", "402")}

Example: {Gs1Barcode(data.IdConsignemnt, “401”, “420”)}

Returns: (401)Number(420)2322

Format Currency

Code: {formatCurrency(Value)}

Example: {FormatCurrency(Invoice.InvoiceBaseTotal + Invoice.InvoiceAdditionalServiceTotal)}

Code: {formatCurrency(Value, CurrencyID)}

Code: {formatCurrency(Value, Hide If Zero)}}

Example: {FormatCurrency(Invoice.InvoiceBaseTotal + Invoice.InvoiceAdditionalServiceTotal, true)}

Format Hours

Code: {FormatHours(object val)}

Format Seconds

Code: {FormatHours(object val)}

Format Number

Code: {FormatNumber(object val)} or

{FormatNumber(object val, bool hideIfZero)}

Remove Empty Lines

Code: {RemoveEmptyLines(Value)}

Example: {RemoveEmptyLines(Invoice.CustomerName + '\n' + Invoice.CustomerAddress1 + '\n' + Invoice.CustomerAddress2 + '\n' + Invoice.Suburb +' ' + Invoice.State+", "+ Invoice.Postcode)}
Returns: A string with no empty lines

Format Date

Code:{FormatDate(Value)}

Example: {FormatDate(Invoice.InvoiceDate)}}
Returns: 29/07/2017

Date Time Now

Code: {FormatDateTime()}

Example: {FormatDateTime(DateTime.UtcNow)}
Returns: Current Date Time

Format Date Time

Code: {FormatDateTime(Value)}

Example: {FormatDateTime(Invoice.InvoiceDate)}}
Returns:  29/07/2017 13:52

Format Date Long

Code: {FormatDateLong(Value)}

Example: {FormatDateLong(Invoice.InvoiceDate)}}
Returns:  July 29, 2017

Format DateTime Long

Code: {FormatDateTimeLong(Value)}

Example: {FormatDateTimeLong(Invoice.InvoiceDate)}}
Returns: July 29, 2017 1:45:30 PM

Format Time Long

Code: {FormatTime(Value)}

Example: {FormatDateLong(Scan.Time)}}
Returns:
1:45:30 PM

Images

Code: {LoadImage(id)} example Dangerous Goods

Consignment Logo's

{LoadConsignmentLogo(idCustomerAgent, idCustomerAgent2nd)}

{LoadConsignmentLogo(long? idCustomerAgent)}

Label Logo's

{LoadLabelLogo(long? idCustomerAgent, idCustomerAgent2nd)}

{LoadLabelLogo(long? idCustomerAgent)}

Invoice Logo's

LoadTVInvoiceLogo()

LoadInvoiceLogo()