08CustomReportslab.docx
- 文档编号:14889871
- 上传时间:2023-06-28
- 格式:DOCX
- 页数:20
- 大小:212.91KB
08CustomReportslab.docx
《08CustomReportslab.docx》由会员分享,可在线阅读,更多相关《08CustomReportslab.docx(20页珍藏版)》请在冰点文库上搜索。
08CustomReportslab
LabExercise–CustomReports
PlanningtheReport
Youshouldhaveaplanforthereportformatbeforebeginningthecreation.Inotherwords,youneedtoknowthefinaldestinationbeforeyoubeginyourjourney.Inthiscase,weneedareportthatcontainsalloftheresultsnecessarytodeterminewhetherornotoursystemsuitabilitytestsaresatisfactoryforthesequenceweran.Onaseparatereportwewantareportforallofthesamplesweran.
Eachpageinourreportsshouldlooklikeitwasprintedonletterhead.Thefooterneedstoprovideinformationlikewhenthereportwasprintedandthepagenumbering.
Thesystemsuitabilityreportshouldincludeaheaderidentifyingthesequencereportedandthemethodusedtogeneratetheresults.Weneedtoseeachromatogramfortheblankinjectionandachromatogramforthesensitivityinjection.Forallofthesystemsuitabilitystandardsweneedatablewithretentiontimeandareawiththemeanandthe%RSDforthearea.Finallyweneedtheresolutionbetweenpeaks2and3,thetheoreticalplatesandthetailingfactorsfortheresolutioninjection.
Forthesamplesweneedtheretentiontime,thearea,theamountandthe%oftargetconcentration.Weneedthemeanforeachpairofreplicateinjectionsandtheoverallmeanand%RSDforallsampleinjections.
1)Rememberthatthecustomreportwillbecreatedfromthecurrentdataset(resultsofaqueryandfilter).RunorcreateyourqueryfortheAcqSequenceName110301Athatwillretrieveallthelatestversionsofrunsforthatacquisitionsequenceandinstrument1.Wehaveretrievedthisdataseveraltimesnow.Ifyournotcomfortableorfamiliarwiththissteppleasespeakwithyourinstructor(Hint:
thereshouldbe14runs.)OKanymessageaboutFiltersnotbeingselected.
CreateaNewReportTemplate
InthesestepsyouopentheReportTemplateEditorapplication,giveyournewtemplateaname,restrictreportcompoundsandsaveitforthefirsttime.
2)SelectReport/CreatefromtheChemStoremaindialogorclicktheReportTemplateEditortoolandselectCreate.
TheReportTemplateEditormaindialogboxappearsandatemplatenamed“NewReportTemplate”appearsinthetreeviewontheleftsideofthewindow.
3)With“NewReportTemplate”highlighted,inthetreeview,intheNametextfieldtypeSystemSuitabilityReportforCompounds1-4asthenewnameforyourreport.
4)SelectFile/Save“SystemSuitabilityReport-Compounds1-4”As…tosaveyourtemplate.
5)ClickSaveontheSavereporttemplateasdialogbox.
Whatusefulinformationmightbeenteredinthecommentsbox?
_________________________________________________________________
SpecifythePageHeader
Inthesestepsyouaddapageheadertothereportthatprintsoneverypageandcontainsthecompanyletterheadandlogo.
6)Inthetreeviewofthereporttemplate,highlightthereporttemplatename,SystemSuitabilityReport-Compounds1-4.
7)ClicktherightmousebuttonwhenthereporttemplatenameishighlightedtobringupthecontextmenuandselectInsertPageHeader.Alternatively,youcanusethemenustoinsertapageheaderbyselectingEdit/InsertSection/PageHeader.
Now,theright-handsideofthedialogboxcontainstextfieldsforenteringinformationaboutthereportheaderandanewlineappearsinthetreeviewlabeled“NewPageHeader”.
8)MakesuretheIncludeinReportcheckboxischecked.
9)ChecktheIncludeBordercheckboxtocreateaborderaroundtheheaderwhenitisprinted.
10)ClickPrintOnAllPagessothattheheaderappearsoneverypageofthereport.TheEditordialogboxshouldnowappearasshownbelow.
11)ClicktheEditbuttonatthebottomofthedialogbox.
TheEditPageHeaderdialogboxappears.Usethisdialogtosetupthedata,textorgraphicitemsthatappearintheheader.
12)ClicktheTextItemstab.
13)Clickinthemiddlecelloftheheader.
14)Setthefollowingparametersasshownbelow.
∙Font:
TimesNewRoman/12
∙Content:
A.F.B.Laboratories
∙Appearance:
Bold/Center
∙Width:
2inches
Whathappenedinthecellyouselectedinstep13)?
_________________________________________________________________
15)ClicktheAddRowbutton.
Whathappened?
_________________________________________________________________
16)Setthefollowingparametersasshownbelow.
∙Content:
1GreatAmericanWay
∙Appearance:
Center
∙Width:
2inches
17)ClicktheAddRowbutton.
18)Setthefollowingparametersasshownbelow.
∙Content:
Everywhere,USA
∙Appearance:
Center
∙Width:
2inches
19)ClicktheAddRowbutton.
20)Setthefollowingparametersasshownbelow.
∙Content:
PhoneBR-549
∙Appearance:
Center
∙Width:
2inches
21)ClicktheAddRowbutton.
22)Setthefollowingparametersasshownbelow.
∙Content:
AlfredE.Neuman,President
∙Appearance:
Center
∙Width:
2inches
YourEditPageHeaderpanelshouldnowappearasshownbelow.
23)ClicktheGraphicItemtab.
24)ClickBrowse…andnavigateto\HPCHEM\CHEMSTOR,thenhighlightLOGO.WMFandclickOpen.
ThefilenameappearsintheSourcetextfield.Itisgrayed-outwhichmeansthatyoucannoteditthisfielddirectly.Tochangetheselectedfile,youmustbrowsethefilesystemforanewfilename.
25)IntheHorizontalLocationarea,selectAtOffsetandrepeatedlyclickthe▲toincreasetheoffset.Watchthegreenboxintheexampleareaatthebottomofthepanelmovefromlefttorightasyouincreasetheoffset.
26)NowselectLeftastheHorizontalLocation.
27)SelectTopastheVerticalLocation.Youexampleshouldappearasshownbelow.
Whatwouldthe“AtOffset”intheverticallocationdo?
_________________________________________________________________
ExperimentwiththeHeaderLayoutandSelectedItemradiobuttonstoseehowthedisplaychanges.Usethesebuttonstohelpyouviewyourheaderasyoudesignit.
28)ClickOKtoexitthisdialogbox.
29)SelectFile/Save“SystemSuitabilityReport-Compounds1-4”tosaveyourtemplate.
30)ClickthePreviewbutton.
31)ClosethePreview
SpecifythePageFooter
Inthesestepsyouaddafootertothereportwhichdisplaysthepagenumberandtimethereportwasprinted.
32)Inthetreeviewofthereporttemplate,highlightthereporttemplatename,SystemSuitabilityReport-Compounds1-4.
33)ClicktherightmousebuttonwhenthereporttemplatenameishighlightedtobringupthecontextmenuandselectInsertPageFooter.Alternatively,youcanusethemenustoinsertapagefooterbyselectingEdit/InsertSection/PageFooter.
WhyisInsertPageHeadergrayedout?
_________________________________________________________________
Now,theright-handsideofthedialogboxcontainstextfieldsforenteringinformationaboutthereportfooterandanewlineappearsinthetreeviewlabeled“NewPageFooter”.
34)MakesuretheIncludeinReportcheckboxischecked.
35)ClickPrintonallPagessothatthefooterappearsoneverypageofthereport.
36)ClicktheEditbuttonatthebottomofthedialogbox.
TheEditPageFooterdialogboxappears.Youusethisdialogtosetupthedata,textorgraphicitems,thatappearinthefooterjustasyoudidtheheader.
37)ClicktheTextItemstab.
38)Clickintheleftcellofthefirstlineofthefooter.
39)UndertheDatabaseValuelabel,selectPrintTimefromthedrop-downlist.
Whathappenedinthecellyouselectedinstep38)?
_________________________________________________________________
Wheredidthetext,“ReportPrinted”,comefromandhowwouldyoueditthattext?
_________________________________________________________________
40)Usetheappearancecontrolstoprintthelabelinboldtext(clicktheB).
41)ClicktheFormat…button.
42)OntheFormatdialogbox,selectGeneralformattingbeforeclickingOK.
43)Clickintherightcellofthefirstlineofthefooter.
44)FromtheDatabaseValuedropdownlist,selectPageNumber.
45)ClicktheFormat…button.
Whatisthedefaultformatforpagenumbering?
_________________________________________________________________
46)OKtheFormatFielddialogbox.TheEditPageFooterpanelshouldnowappearasshowninnextFig..
47)ClickOKtoexittheEditPageFooterdialogbox.
48)SelectFile/Save“SystemSuitabilityReport-Compounds1-4”tosaveyourwork.
49)ClickthePreviewbutton.
50)ClosethePreview
Section1AddingaHeaderwithSequenceandMethodInformation
AnydataweplaceonareportmustbecontainedinaDataSection.ADataSectioncancontainaheaderandoneormoretables,chartsorchromatograms.YoucannotaddatableorcharttothereportuntilyouinsertaDataSection.
Throughthenextserveralsectionswewillbuildasystemsuitabilityreportonesectionatatime.Wecouldbuildthereportinanyorder,insertingsectionsandrearrangingthemtosuitourneeds,butwewillstartfromthetopandgotothebottomsotospeak.
51)Inthetreeviewofthereporttemplate,highlightthenameofthetemplate,SystemSuitabilityReport-Compounds1-4.
52)ClicktherightmousebuttonwhenthereporttemplatenameishighlightedtobringupthecontextmenuandselectInsertDataSection.
Whatmenuitemswouldyouselecttoaccomplishthistask?
_________________________________________________________________
Now,theright-handsideofthedialogboxcontainstextfieldsforenteringinformationaboutthedatasectionandanewlineappearsinthetreeviewlabeled“NewDataSection”.
53)With“NewDataSection”highlighted,typeDataSetReportedintotheDescriptionfield.
54)MakesuretheIncludeinReportcheckboxischecked.
Whenweadditemslikesequencenamestoheaders,wemustfacethepossibilitythatifourquerydoesnotretrievea
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 08 CustomReportslab