報(bào)表-練習(xí)-媒體對(duì)象-系統(tǒng)函數(shù)

1、Operating Report Writing IIMedia Objects and System FunctionsJ.D.Edwards EnterpriseOneMedia ObjectsMedia Objects are attachments to recordsItem master, Item BranchSales Order Header, Sales Order DetailPurchase Order Header, PO DetailPrint MessageMedia Objects are stored as BLOBS and are printed thro

2、ugh system functionsYou cannot print an OLE object, print text onlyWhen converting data, convert as textIdentify the Media Object PropertiesFastpath G4111, Item MasterItem Master, Item 2004Scroll down the left side toItem NotesInternal Attachment do not printSelect Item NotesAdd an Item NoteClick OK

3、File/New/TextType your textRight click on the gray portion and select propertiesNote Name and Key fieldsFile/Save & ExitAdd alpha variable named ItemNotesGT4016BClick System Function IconDouble click Media ObjectsFind GT4016B, double clickAction is Get TextMouse Text and choices appear - choose RV y

4、ou createdMatch Key FieldsEvent ruleMedia Objects wrap within the display spaceyou have specified in your variable.If display is long enough, they will appearexactly as viewed in the notes screen.Create a conditional group section Item Notes, no business view.Create an alpha variable ConditItemNotes

5、GT4016B, make it globalExecute Media Objects for GT4016B again, but change the destination to the conditional section global variableYou can copy the ER line andchange the items in the copyDo Section Event RulesNote that I have disabled the IF statementso that the Cost Components section willexecute

6、 for each recordWhen to call the conditional sectionYou want the Item notes to print after the item row is executedCall the conditional section “After last Object Printed for the Detail sectionAfter Last Object PrintedNote the difference in display lengthHide/Show FunctionWe dont want the conditiona

7、l section to print unless there is text in the Media ObjectHide the section, then apply an IF test to Show the sectionCreate an RC constant text in the conditional section for Hide/Show testingTesting textEvent Rules Conditional SectionSystem FunctionSection/HideSectionIf RV ConditItemNotesGT4016B i

8、s blankShow SectionDate FunctionsDate Functions are part of the x= assignment/expression functionsYou can retrieve todays date and calculate a past or future dateYou can create a target date and display it or use it for data selection for the reportR55431101-create an RV Target DateAdd a section Va

9、variable ALIAS DTE, called Date SpecifiedAssign va a value of 6/1/05Target Date = f(x)Open Date Functions folder and choose add_day(s)Add 5 days to the date specifiedEvent RulesTarget date is calculatedInclude Target Date in Data SelectionTiming is the keyThe target date must be available before the

10、 detail section processesThe target date must be part of a report headerCreate the report headerCreate an RV RHTargetDate in report header, global variableCreate an rpt va Specified date and assign it to be 6/1/05Report HeaderHeader Event RulesVersion Data SelectionThe Processing Option data does not apply - it was not part of da