《NAVISION技术开发培训文档.ppt》由会员分享，可在线阅读，更多相关《NAVISION技术开发培训文档.ppt（31页珍藏版）》请在三一办公上搜索。
1、Technical Training(1 Day),Albert.Fang,Training Target,Know the concepts of C/L and navision objectsCan create tables and form and build links between them.Can create simple reports and dataportTo have the ability to learn further technical knowledge.,Training Schedule,Table 1.5 hourForm 2 hourReport
2、 2.5 hourDataport 1 hourC/AL and Codeunit 0.5 hourQuestions and answers.0.5hour,Table-What is a table?,Tables are used to store records in the database.A table consists of two parts the table data and a table description.Table Description Table Properties Triggers(插一条数据的时候要调用哪些属性：新增，修改，删除，重命名，字段）Fie
3、lds-Properties-Triggers Keys（关键字）-Properties,Table Table and Field Properties,Viewing and Modifying Table Properties(How to view?How to get Help for a property?)Viewing and Modifying Field Properties(How to view?)Triggers of table(How many triggers exit in a table?How do they work?)Triggers of field
4、(How many triggers in a field?),Table Creating a table,Adding Fields to Your TableChoosing Data types.(Option,Integer,Text,Code,Decimal,Date,Boolean,Blob)Exercise 1:Create a sample table:91200/Vehicle,Table-Keys,Primary key:A table description contains a list of keys.The first key in the list is the
5、 primary key.(How are the records stored and sorted in a table?)Secondary Keys:Defined to sort a table in another order.Exercise 2.1 change primary key for table 50001Exercise 2.2 create a secondary keys for table 50001:Date of Mfg.，Transmission,Table-Adding Data,Exercise 2.1:add new lines in table
6、91200 Exercise 2.2:use the secondary key in table 91200,Table-Setting Relationship between tables,Table Relations and the TableRelation Property先针对表a的某个字段，在属性中设定table relation再建一张关联表b，然后针对这张表设计一个form;设计好这个form后，再回到表b进行design，点中字段为空地方，察看property，在lookup form id中设定针对关联表的form,Table-Special table fields
7、,SumIndexFieldsFlowFields(drill down-自动汇总，比如item 的库存）1、先要在目标表中增加统计字段，该字段的“属性”中“field class”设为“flow field”,然后在“calcformula”中设定计算公式（有向导）2、然后在数据来源表中，设计，在菜单“view”中察看“key”，增加之前在目标表中的“calcformula”中设定的table filter设定为key,并设定sumindexfields(该字段必须是decimal）3、针对数据来源表创建一个form 4、对于数据来源表进行设计，然后点中空的一行，点击属性，将drilldow
8、n form设成新建的数据来源表的form id.FlowFilter Fields 1、先要在目标表中增加一个字段（字段类型看实际需要在字段中输入值的类型），针对该字段属性中的“field class”设为“flow filter”2、在目标form中拉出这个字段 3、在目标表中，针对统计字段重新设定“calcformula”中的table filter(将新增的flowfilter field作为筛选条件之一）4、然后在数据来源表中，设计，在菜单“view”中察看“key”，增加之前在目标表中的“calcformula”中修改的table filter新增为key,并设定sumindexf
9、ields(该字段必须是decimal）,Form-what is a form?,Forms are used for entering information into database tables and for retrieving and displaying information from database tables.Form Description Form Properties Triggers Control-Properties-Triggers,Form-What are Controls?,Controls are objects that can displa
10、y data from a database table field,the value of a C/AL expression,bitmap pictures or static information such as a descriptive text.container controls:such as frame and tab control.Bound and Unbound Forms and Controls:Typically a form is bound to a table and a control is bound to a field.But you need
11、nt always do this.Menu form is an example of unbound forms and a button is a example of a unbound control.,Form-Form and Control Properties,Some important form properties:“sourcetable”,”Sourcetableview”（用来设定打开form时的自动筛选条件）Control properties:Different types of controls have different sets of properti
12、es,在main form中增加subform,通过工具（toolbox）可增加subform修改subform的两个属性：subformid(设定对应于哪个form)subformlink(设定subform中显示信息的筛选条件）,Form-Creating a Form,Exercise 4 create a form manually from customer,add some controls on it freely(must try tab control,text control,check box control)form 50001Exercise 5 create a f
13、orm(50002)from 50001 using a form wizard form,Form Creating Buttons&link forms,Exercise 6.1 Create a list form(50003)from table 50001Exercise 6.2 Add a button named“card”in this formExercise 6.3 Build the link between form 50002 and form 50003,Form-Creating Subform,Step i:Creating the Main FormStep
14、ii:creating a subformStep iii:add the subform to the Main formExercise 7:Create a simple sales order,Report-What are reports?,Reports are used to print information from a database in a structured way.Report Description(Report components)-Properties-Triggers-Dataitems-Properties,-triggers-Sections(Pr
15、operties,triggers,Controls)-Request Form(Properties,triggers,Controls),Report The report components,Data Item:A data item corresponds to a table.When a report uses more than one table,you should set relations between the data items Sections:each data item could have one or more sections.A section ca
16、n be thought of as a block of information to print on the paper.Controls:The information that is printed in the sections is composed of controls.Request Form:A request form is a form that is run before the actual report begins execution.Property:A property is an attribute of an object(report,data it
17、em,section and so forth)Triggers:Exercise 7:create a simple report:salesperson list,Report The report designer,Dataitem Designer How to ordering a dataitem?How to indent a dataitem?How to link a dataitem?Section DesignerRequest form DesignerExercise 8:Create a Salesperson list including customers,Re
18、port Some useful properties,NewPagePerRecord Property just try to change this properties in report 50002PrintOnlyIfDetail Property:The report should only print master records that have details if you set the properties to yes.ReqFilterFields and ReqFilterHeading,Report-Grouping within a report,Typic
19、ally in a report,there is a need to print subtotals or to separate groups of records based on fields within the records themselves.This is realized by grouping a dataitem.The most common use for grouping is to subtotal a report by Date.The GroupTotalFields Property The GroupHeader and GroupFooter Se
20、ctionsExercise 9:create a customer/customer ledger entry report(50003),the customer ledger entry should be grouped by posting date(customer fields:no.,name,city,phone no.;customer ledger entry fields:posting date,document no.,description,amount),Report-totaling within a report,Creating totals and gr
21、and totals:just try to make totals for report 50003,Report-Adding some advanced features,Using flowfilters in reportAdding and Taking Away from the Request Form Skipping Sections in a Report Adding a Grand Total with More Than One Data Item Adding MultiLanguage Functionality to Your Report,Dataport-
22、Fundamental,Dataports are objects that are used for importing data from and exporting data to external text files.Dataport Description-Properties-Triggers-Data Items(Properties,Triggers)-Dataport Fields(Properties,Triggers)-Request Form(Properties,Triggers,Controls),Dataport Designing Dataport,Datap
23、ort propertiesDataport field properties,Dataport Sample dataport(Export),Exporting fixed formatExercise10:create a dataport to export g/l account in fixed formatExporting-Variable Format,Dataport Sample dataport(Import),Import fixed formatExercise10:create a dataport to import data into table 50003(
24、new create)Import-Variable Format,C/L:summary,CAL Simple DataTypesIdentifiers-VariablesThe Assignment StatementExpressionsNumeric ExpressionsIF and EXIT StatementsCompound Statements and CommentsArraysRepetitive StatementsOther StatementsCalling Built-In FunctionsCAL ProgrammingCAL Functions,Codeunit,Creating codeunitUsing codeunitExercise 11:create a simple codeunit to show“nice to meet you”message,问题,?,
