Functions (Basic syntax)

 —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — —
Sup­port machine trans­la­tion: http://amzn.to/1Z7d5oc
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — —
Crys­tal Reports Online Help
Func­tions (Basic syn­tax)
When using a func­tion in a for­mu­la, type the name of the func­tion and sup­ply the argu­ments required. For example, the Len func­tion requires a String argu­ment and com­putes the length of the string.
Dim x As String
x = ““hel­lo””
for­mu­la = Len (x) The for­mu­la returns the Num­ber 5Sup­ply­ing argu­ments of the incor­rect type required by the func­tion pro­duces an error. For example, call­ing Len (3) would pro­duce an error since Len does not accept a Num­ber argu­ment. Func­tions some­times can accept dif­fer­ent num­bers of argu­ments or types of argu­ments. For example, the CDate func­tion could accept a single String argu­ment to form a Date value or 3 Num­ber val­ues hold­ing the year, month and day respect­ively and form a Date value from them. See Date, Time, and Dat­e­Time (Basic syn­tax).
Example with the Mid func­tion
Dim x as String
x = ““hel­lo””
Start at pos­i­tion 2, go to the end of the string
for­mu­la = Mid (x, 2) for­mu­la is now ““ello””
Start at pos­i­tion 2, extract 1 char­ac­ter
for­mu­la = Mid (x, 2, 1) for­mu­la is now ““e”“The classes of func­tions are: Math, Sum­mary, Fin­an­cial, String, Date/Time, Date Range, Array, Type Con­ver­sion, Pro­gram­ming Short­cuts, Eval­u­ation Time, Print State, Doc­u­ment Prop­er­ties and Addi­tion­al Func­tions. There are also some func­tions spe­cific to con­di­tion­al format­ting for­mu­las.
Tip: The func­tions that Crys­tal Reports sup­ports are described in Func­tions.
In this sec­tion:
Func­tions sim­il­ar to Visu­al Basic func­tions of the same name (Basic syn­tax)
Sum­mary func­tions (Basic syn­tax)
Date ranges (Basic syn­tax)
Array func­tions (Basic syn­tax)
Eval­u­ation Time func­tions (Basic syn­tax)
Print State func­tions (Basic syn­tax)
Doc­u­ment Prop­er­ties func­tions (Basic syn­tax)
Addi­tion­al func­tions (Basic syn­tax)
Con­di­tion­al format­ting func­tions (Basic syn­tax)
Gen­er­al pur­pose con­di­tion­al format­ting func­tions (Basic syn­tax)
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –











Pre­vi­ous page Next page
SAP Busi­nessOb­jects
http://www.sap.com/sapbusinessobjects/
Sup­port ser­vices
http://service.sap.com/bosap-support/
Pro­duct Doc­u­ment­a­tion on the Web
http://help.sap.com/

“ —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Appoġġ ta traduzz­joni awto­matika: http://amzn.to/1Z7d5oc
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Rap­porti Crys­tal Online Għa­jnuna
Fun­z­jon­iji­et (sin­tassi Bażiku)
Meta jin­tuża fun­z­joni fl for­mu­la, tip l-isem tal-fun­z­joni u l-prov­v­ista l-argu­menti meħtieġa. Per eżem­pju, il-fun­z­joni Len teħtieġ argu­ment String u jikkalku­la t-tul tas-sek­wen­za.
Dim x Bħala String
x = ““bon­jour””
for­mu­la = Len (x) ““Il-for­mu­la pros­pet­ti l-argu­menti Num­ru 5Sup­ply­ing tat-tip żbal­jata meħtieġ mill-fun­z­joni jip­produċi żball. Per eżem­pju, li sse­j­jaħ Len (3) jip­produċi żball peress Len ma taċċetta l-argu­ment Num­ru. Fun­z­jon­iji­et kult­ant tista taċċetta għadd dif­fer­enti ta’ argu­menti jew tipi ta argu­menti. Per eżem­pju, il-fun­z­joni CDate jista jaċċetta l-argu­ment String wieħed biex jiġi ffur­mat valur Data jew 3 Valuri Num­ru hold­ing is-sena, ix-xahar u l-jum rispet­tiva­ment u jif­fur­maw valur Data min­nhom. Ara Data, Ħin, u Dat­e­Time (sin­tassi Bażiku).
Eżem­pju bil-fun­z­joni ta Nofs
x dim bħala String
x = ““bon­jour””
““Bidu fil-pożizz­joni 2, mur l-aħħar tas-sek­wen­za
for­mu­la = Nofs it (x, 2) ““For­mu­la issa huwa”” ello “”
““Bidu fil-pożizz­joni 2, estratt 1 kar­at­tru
for­mu­la = Nofs it (x, 2, 1) ““for­mu­la hija issa”” e ““Il-klassiji­et tal-fun­z­jon­iji­et huma: Matem­atika, Som­mar­ju, fin­an­zjarji, String, Data / Ħin, Data Med­da, Array, kon­ver­ż­joni Tip, Pro­gram­mazz­joni Short­cuts, Eval­wazz­joni Ħin, Stam­pa Istat, Dok­u­ment Pro­prjetaji­et u Fun­z­jon­iji­et addizz­jon­ali. Hemm ukoll xi fun­z­jon­iji­et speċi­fiċi biex for­mu­li ifformat­tjar kondizz­jon­ali.
Tip: Il-fun­z­jon­iji­et li Reports Crys­tal jap­poġġ­ja huma deskrit­ti Fun­z­jon­iji­et.
F’din it-taqsima:
Fun­z­jon­iji­et simili għal fun­z­jon­iji­et bażiċi viżwali ta l-istess isem (sin­tassi Bażiku)
fun­z­jon­iji­et Som­mar­ju (sin­tassi Bażiku)
meded data (sin­tassi Bażiku)
fun­z­jon­iji­et array (sin­tassi Bażiku)
fun­z­jon­iji­et eval­wazz­joni Ħin (sin­tassi Bażiku)
fun­z­jon­iji­et Statali Stam­pa (sin­tassi Bażiku)
Dok­u­ment Prop­er­ties fun­z­jon­iji­et (sin­tassi Bażiku)
fun­z­jon­iji­et addizz­jon­ali (sin­tassi Bażiku)
fun­z­jon­iji­et ifformat­tjar kondizz­jon­ali (sin­tassi Bażiku)
skop ġen­er­ali fun­z­jon­iji­et ifformat­tjar kondizz­jon­ali (sin­tassi Bażiku)
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  — —

paġna ta qabel paġna li jmiss
SAP Busi­nessOb­jects
http://www.sap.com/sapbusinessobjects/
ser­vizzi ta appoġġ
http://service.sap.com/bosap-support/
Dok­u­mentazz­joni pro­dott fuq il-Web
http://help.sap.com/
 

“ —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Onder­steun­ing masji­en ver­tal­ing: http://amzn.to/1Z7d5oc
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Crys­tal Reports Online Hulp
Funk­sies (Basiese sin­tak­s­is)
By die gebruik van n funk­sie in n for­mule, tik die naam van die funk­sie en ver­skaf die argu­mente nodig. Byvoor­beeld, die Len funk­sie vereis n String argu­ment en bere die lengte van die string.
Dowwe x As String
x = ““hal­lo””
for­mule = Len (x) Die for­mule gee die nom­mer 5Sup­ply­ing argu­mente van die ver­keer­de soort wat deur die funk­sie lew­er n fout. Byvoor­beeld, n ber­oep Len (3) sou n fout te prod­useer sedert Len n aan­tal argu­mente aan­vaar nie. Funk­sies kan soms ver­skil­lende aan­tal argu­mente of tipes argu­mente aan­vaar. Byvoor­beeld, kan die CDate funk­sie n enkele String argu­ment aan­vaar om n waarde Datum of 3 Aan­tal waardes hou van die jaar, maand en dag onder­skeide­lik vorm en vorm n waarde Datum van hulle. Sien Datum, Tyd, en Datum tyd (Basiese sin­tak­s­is).
Voor­beeld met die Mid­de-funk­sie
Dowwe x as String
x = ““hal­lo””
Begin by pos­is­ie 2, gaan na die einde van die tou
for­mule = Mid (x, 2) n for­mule is nou ““ello””
Begin by pos­is­ie 2, ont­trek 1 karak­ter
for­mule = Mid (x, 2, 1) n for­mule is nou ““e”” Die klasse van funk­sies is: Wiskun­de, Opso­m­ming, fin­an­sieel, String, Datum / Tyd, datum bereik, Array, Tipe Gesprek, Pro­gram­mer­ing kort­paaie, Eval­u­er­ing Tyd, Print State, Doc­u­ment Prop­er­ties en Byko­mende funk­sies. Daar is ook n paar funk­sies wat spesi­fiek op voor­waar­delike forma­ter­ing for­mules.
Wenk: Die funk­sies wat Crys­tal Reports onder­steun word beskryf in Funk­sies.
In hierdie afdel­ing:
Funk­sies soort­gelyk aan Visu­al Basic funk­sies van die die­s­elf­de naam (Basiese sin­tak­s­is)
Opso­m­ming funk­sies (Basiese sin­tak­s­is)
Datum reek­se (Basiese sin­tak­s­is)
Ver­skeiden­heid funk­sies (Basiese sin­tak­s­is)
Eval­u­er­ing Tyd funk­sies (Basiese sin­tak­s­is)
funk­sies Print Staat (Basiese sin­tak­s­is)
Dok­u­ment eienskappe funk­sies (Basiese sin­tak­s­is)
Byko­mende funk­sies (Basiese sin­tak­s­is)
Voor­waar­delike forma­ter­ing funk­sies (Basiese sin­tak­s­is)
Alge­mene doel voor­waar­delike forma­ter­ing funk­sies (Basiese sin­tak­s­is)
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  — —

Vori­ge Vol­gende
SAP Busi­ness
http://www.sap.com/sapbusinessobjects/
onder­steun­ings­di­en­ste
http://service.sap.com/bosap-support/
Produk dok­u­mentas­ie op die web
http://help.sap.com/
 

“ —  —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Mbështetje mak­inë përk­thim: http://amzn.to/1Z7d5oc
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — –
Crys­tal Reports Online Ndih­më
Funk­sion­et (Sin­tak­sa Basic)
Kur për­dorni një funk­sion në një for­mulë, shk­ru­ani emrin e funk­sion­it dhe të ofro­jë argu­mentet e nevojsh­me. Për shem­bu­ll, funk­sioni Len kërkon një argu­ment String dhe Llog­ar­it gjatësinë e var­gut.
x dim As String
x = ““hel­lo””
for­mu­la = Len (x) ““For­mu­la e kthim­it argu­mentet Num­ri 5Sup­ply­ing të tip­it të gabuar kërkuar nga funk­sioni prod­hon një gabim. Për shem­bu­ll, duke e quajtur Len (3) do të prod­ho­jë një gabim që Len nuk pran­on një argu­ment Num­ri. Funk­sion­et ngan­jëherë mund të pran­o­jë numër të ndry­shëm të argu­menteve apo llo­jet e argu­menteve. Për shem­bu­ll, funk­sioni CDate mund të pran­o­jë një argu­ment të vetëm String për të for­muar një vlerë Date ose 3 vler­at Num­ri mba­jnë vit­in, muajin dhe ditën respekt­iv­isht dhe të for­mo­jnë një vlerë Date prej tyre. Shih datën, kohën, dhe DATETIME (sin­tak­së Basic).
Shem­bu­ll me funk­sion­in Mid
x dim si String
x = ““hel­lo””
““Të fil­lo­jë në poz­i­cion­in 2, shkoni në fund të var­gut
for­mu­la = Mid (x, 2) ““for­mu­la është tani”” ello “”
““Të fil­lo­jë në poz­i­cion­in 2, ekstrakt 1 karak­ter
for­mu­la = Mid (x, 2, 1) ““for­mu­la është tani”” e ““Klasat e funk­sioneve janë: Math, Përmbled­hje, fin­an­ciare, String, Date / Time, Data Range, koleksion­it, Lloji i kon­ver­tim­it, Short­cuts Pro­gra­mim, Time vler­ësim­it, Print shtetërore, Doc­u­ment Prop­er­ties dhe funk­sion­et sht­esë. Ka edhe disa funk­sione të veçanta për të for­mu­lave të kushtëzuar form­atim­it.
Këshillë: Funk­sion­et që Rapor­tet Crys­tal mbështet janë për­shk­ru­ar në funk­sion­et.
Në këtë nen:
Funk­sione të ngjash­me me funk­sion­et Visu­al Basic me të njëjt­in emër (sin­tak­sës Basic)
Funk­sion­et Përmbled­hje (sin­tak­së Basic)
Data shkon (sin­tak­së Basic)
Funk­sion­et Array (sin­tak­së Basic)
Funk­sion­et Koha Vler­ësimi (sin­tak­së Basic)
Funk­sion­et Print Shtetit (sin­tak­së Basic)
Doc­u­ment Prop­er­ties funk­sion­et (sin­tak­sa Basic)
Funk­sione të tjera (sin­tak­së Basic)
Funk­sion­et e kushtëzuar form­atim­it (sin­tak­së Basic)
për qël­lime të për­gjith­sh­me funk­sion­et kushtëzuara form­atim­it (sin­tak­së Basic)
 — —  —  —  —  —  —  —  —  —  —  —  —  —  —  — – — —  —  —  —  —  —  —  — —