报表-练习-媒体对象_系统函数

OperatingReportWritingIIMediaObjectsandSystemFunctionsJ.D.EdwardsEnterpriseOneMediaObjects•MediaObjectsareattachmentstorecords-Itemmaster,ItemBranch-SalesOrderHeader,SalesOrderDetail-PurchaseOrderHeader,PODetail-PrintMessage•MediaObjectsarestoredasBLOBSandareprintedthroughsystemfunctions•YoucannotprintanOLEobject,printtextonly-Whenconvertingdata,convertastextIdentifytheMediaObjectPropertiesFastpathG4111,ItemMasterItemMaster,Item2004ScrolldowntheleftsidetoItemNotesInternalAttachmentdonotprintSelectItemNotesAddanItemNoteClickOKFile/New/TextTypeyourtextRightclickonthegrayportionandselectpropertiesNoteNameandKeyfieldsFile/Save&ExitAddalphavariablenamedItemNotesGT4016BClickSystemFunctionIconDoubleclickMediaObjectsFindGT4016B,doubleclickActionisGetTextMouseTextandchoicesappear-chooseRVyoucreatedMatchKeyFieldsEventruleMediaObjectswrapwithinthedisplayspaceyouhavespecifiedinyourvariable.Ifdisplayislongenough,theywillappearexactlyasviewedinthenotesscreen.CreateaconditionalgroupsectionItemNotes,nobusinessview.CreateanalphavariableConditItemNotesGT4016B,makeitglobalExecuteMediaObjectsforGT4016Bagain,butchangethedestinationtotheconditionalsectionglobalvariableYoucancopytheERlineandchangetheitemsinthecopyDoSectionEventRulesNotethatIhavedisabledtheIFstatementsothattheCostComponentssectionwillexecuteforeachrecordWhentocalltheconditionalsection•YouwanttheItemnotestoprintaftertheitemrowisexecuted-Calltheconditionalsection“AfterlastObjectPrinted”fortheDetailsectionAfterLastObjectPrintedNotethedifferenceindisplaylengthHide/ShowFunction•Wedon’twanttheconditionalsectiontoprintunlessthereistextintheMediaObject•Hidethesection,thenapplyanIFtesttoShowthesection•CreateanRCconstanttextintheconditionalsectionforHide/ShowtestingTestingtextEventRulesConditionalSectionSystemFunctionSection/HideSectionIfRVConditItemNotesGT4016BisblankShowSectionDateFunctions•DateFunctionsarepartofthex=assignment/expressionfunctions•Youcanretrievetoday’sdateandcalculateapastorfuturedate•YoucancreateatargetdateanddisplayitoruseitfordataselectionforthereportR55431101-createanRVTargetDateAddasectionVavariableALIASDTE,calledDateSpecifiedAssignvaavalueof6/1/05TargetDate=f(x)OpenDateFunctionsfolderandchooseadd_day(s)Add5daystothedatespecifiedEventRulesTargetdateiscalculatedIncludeTargetDateinDataSelection•Timingisthekey•Thetargetdatemustbeavailablebeforethedetailsectionprocesses-Thetargetdatemustbepartofareportheader-Createthereportheader-CreateanRVRHTargetDateinreportheader,globalvariable-CreateanrptvaSpecifieddateandassignittobe6/1/05ReportHeaderHeaderEventRulesVersionDataSelectionTheProcessingOptiondatadoesnotapply-itwasnotpartofdataselectionOnlyorderswitharequestdate=targetdateareincludedonthereportNote-ConvertednumericisrightjustifiedLefttrimalphaisleftjustified