33
Chapter19:CreatingandViewingReports
Toselectandconfigurefields:
1. ClickSelectFields.
2. Ifyouarecreatinganewreportoraddingfieldstoanexistingreport,
clicktheellipsis,selectAddanewfield,andthendynamicallydefineeach
newreportfieldasfollows:
a. ClicktheasteriskafterField:,andthenselectthetypeofinformationto
includeinthecurrentreportfield.
b. Ifyouwanttosortthedatainthecurrentfield,clickthesort
asteriskandselectasortorder.
c. Ifyouwanttoperformanoperationonthedatainthecurrent
field,clickthefunctionasteriskandselectanoperation.
3. Ifyouaremodifyinganexistingreport,clicktheField,sort,orfunction
thatyouwanttochangeandselectanewvalueasfollows.
a. ClicktheasteriskafterField.
b. Selectthetypeofinformationtoincludeinthecurrentreportfield.
c. Ifyouwanttosortthedatainthecurrentfield,clickthesort
asteriskandselectasortorder.
d. Ifyouwanttoperformanoperationonthedatainthecurrent
field,clickthefunctionasteriskandselectanoperation.
4. Ifyouwanttotestyourselectionsasyouassembleyourreport,click
ExecuteSQLQuerytoviewthecurrentqueryresults.
5. Ifyouwanttodeleteafieldorrearrangetheorderofthefieldsthatare
listedinyourreport,selectafield,clickBrowse(…),andthenselectthe
appropriateaction.
Note:Uncheckedfieldsarenotdisplayedinyourreport,buttheirsortand
functionconfigurationsareretained.
6. Ifyouwanttopreviewyourreport,clickPreview.
FilterResultsOptionsTab
TheFilterResultstaballowsyoutogeneratefilterconditionsforfielddataby
selectingappropriatedescriptorsfromthelinkedcontextmenus.Filtersare
configuredasfollows.
596