dropdown-sql-format

field

SQL-Fieldname (do not use a comma)

you need an mandatory field name

you can set the field type and the field name with (C) for Char and N for Number

Example

select ("ItemName"(C)itemname<tab>title=Description/) from "OITM"

Beas converts this syntax (MSSQL) to

  select ItemName+'' as itemname from OITM

and in HANA

select "ItemName"||'' as itemname from "OITM"

or you can work with

select (field=ItemName||''<tab>name=itemname<tab>title=Description/) from "OITM")

wrong is

select (field=ItemName'<tab>name=itemname<tab>title=Description/) from "OITM")

(without ||) because then the name-result is "OITM_ItemName" or "ItemName" - it's not defined.

Use always HANA-Format. See select

name

internal Name

Beas sets "<fieldname> as <name>" in the SQL statement

title

set the title

if you set min. 1 title, Beas insert a title-header

width

the width of column

if not set, Beas uses 300 pixel

this information is the minimal entry. Beas checks the first 50 entries to calculate the optimal width

height

set the height

You can work with formular. don't use Comma. Use "|" for Comma

Example: if (id=1|50|100)

or you use <tab> as delimieter in the field-description

format

the Format: timenum, quantity, mass, price, date, datetime, time, c:<unitfieldname>

Fix format, example #,#0.00

Special format: bmp = make this as picture

expression

create a formula field

visible

0 = make invisible

weight

set weight

0 = normal,

1 or 700 = big weight

if(id=1,0,700) = width formula

italic

set italic (see weight)

color

set color (see weight)

alignment

set alignment: left, right, center