774810K GV Report Writer v3.1 User Manual - 75pct for print
Contents
1. Select Analysis Query Options Spectrum Name Date Range From To Sample Description Show Description Detector Description Sample C Detector Close Select bi Query Now Template Sort by Name x5 TUT BONES Ascending Descending Description 1 liter bottle s n 1752 1 liter bottle s n 1752 1 liter bottle s n 1752 1 liter bottle s n 1752 1 liter bottle s n 1752 on endcap of P40615 Test sample 1 liter bottle s n 1752 Test sample 1 liter bottle s n 1752 1 liter bottle s n 1752 1 liter bottle s n 1752 Uranium ore DSPEC Fig 21 Select an Analysis 3 3 2 3 Sample Description Enter the entire sample description to be selected To search for a specific word or phrase any where in the description put the asterisk wildcard character both before and after the word or phrase Do not put a space between the asterisk and the word or phrase unless there is a space in the description For example DSPEC will find DSPEC 75 but DSPEC will not 3 3 2 4 Detector Description Enter the entire detector description to be selected To search for a specific word or phrase any where in the description use the asterisk wildcard character as described in Section 3 3 2 3 3 3 2 5 Template When a selection is highlighted in the list box the report template name that was used to produce the original report is shown here To make a report with a different temp2. 0 0 0 0 KK KK KK KK KK 2 2 INSTALLATION AND STARTUP 4 4 4 44 24 b amp r an s k i n Way y n h az n lw nnn 3 251 Installation ror NER EE K are ER CUIU ENSE b e aven 3 2 1 1 Creating or Modifying Report Writer Templates ooooo ooocoooooo 4 222 Startup xus AE SIE ERI un Ee a OM 2 2 3 Selecting Connecting to the Report Database LA LAV KK KK KK KK KK KK KK KK KI KK 5 2 3 1 Windows 7 Run as administrator marked and Windows XP 6 2 3 2 Windows 7 Run as administrator NOT marked ooooooooo o 7 32 MENU COMMANDS nonet Pese Tante Hela a eue esp De ie 9 SL File Menu sc xa rain ee pte ta T Pg E RE 9 3 T T Recall JE O 5 51 ete a tete teer ae sete due dete det 9 3 1 2 Print Report oso EUH Rex ve pde Ve 10 SV Be Print Plot us due dores ite eaea Sl teu s del dece geb aN el nd dul a 11 SOLAS E ET E el tee eos 12 2515095 O I Wu an ya etse eet ornat te orate oot ls M Aaaa a aeos 12 3 2 Options Menus en sur pe ree e pe RAALA Sr de esi t e 13 ILLAS ES voii LY EHE E eee E ee E E RE tede Eri 13 32 LT Report TR Ep GRE SERIE berries ee dies 13 Template a S Mte RO eue Mee a ev 13 Report Destination veses ot nicia ia yaitia aea a 14 Options testes ee Lori vestes ee ee DET LA A ay n 14 Export Report AS scene ue ii 14 32 1252 PlOU si gehe eet e boten role dd 14 241 3 Datab se c os 2r AA ii iaa
3. 8 shows the resulting report plot window When you click the Open button Ej Recall UFO file the UFO record is stored in the Look in User gt ek Be database and the report and or Re Name Date modified Type Size r plot is generated according to hona Bor WAUZAJI Fae folder ji __JAn19185 ufo 10 31 2013 11 12 UFO File the current report options see ur QA000003 ufo 10 15 2013 11 14 UFO File me k QA000004 ufo 10 15 2013 11 15 UFO File Section 3 2 Note that dup licate QA000005 ufo 10 15 2013 11 17 UFO File UFO filenames replace the old ta di Tmpl 11 5 2013 2 20 PM File folder database entry with the new one Libraries p GammaVision V7 Examples 10 31 2013 11 14 File folder A Computer TS Network m File name zi Open Files of type UFO File UFO ci Cancel Sample Description L Fig 7 The Recall UFO File Dialog GammavVision Report Writer v3 1 A44 BW 774810K 0914 r File Options Database Window Help GammaVision Report Writer Version 3 10 G701W040 05 Nov 2013 3 33 21PM 3 MIXED GAMMA MARINELLI ON ENDCAP OF P40268A GvDemo An1 Start Time 07 Jun 1991 10 37 33AM Live Time 3600 00 Real Time 4219 80 Dead Time 14 69 Detector ID 12592 Detector Sy stem 122 Calibration Description Fig 8 Report and Plot for the UFO File 3 1 2 Print Report This menu c
4. Documents GvRptArchiveDB2 Mdb MDB File a Music L GvRptDB2 Mdb MDB File i Pictures Bi Videos all J File name GvRpt Project ABC mdb Save as type Database File MDB Zi Hide Folders Save y Cancel Fig 20 The Create Database Dialog 3 3 2 Select Analysis This menu command displays the dialog shown in Fig 21 which contains several search and display options as well as a listing of the analysis records in the current database Because the number of records in the database can become very large selection criteria such as date date range or spectrum name are provided When you select a database record and click OK a new report and plot are created based on the selected record To search for a subset of records enter the desired Query Options then click the Query Now button to search on the set of criteria entered Any or all of the query options can be specified at the same time Options left blank are ignored in the search NOTE The displayed list of database entries is not updated until you click the Query Now button 3 3 2 1 Spectrum Name Enter the Spectrum Name no extension The asterisk wildcard can be used For example QA finds all names starting with QA and QA finds all names with QA anywhere in the name 3 3 22 Date Range This selects only spectra where the acquired date is between the From and To dates 18 774810K 0914 3 MENU COMMANDS
5. 16 3 22 Always On TOP e eere rem ehe oet ee emet e sen eve te 16 3 3 Database Menlo A ete Mate ae See iue Sinus 16 3 3 be A Meo rede docete dt AD ate ede eet DA Aes 16 3 3 Le Select Databases io Ea EA are CABE AN 17 3 3 1 2 Create Database it Dat ENE CP rea er ERE Ee 17 3 32 Select Analysis eei bee b ere Cede e iy oh Wee d eben WD 18 3 32 1 Spectrum Name ssesseeeeeee KK KK KK KK KK KK KK 18 39 9 2 2 Date A on ue eerta Deed ed QA eel N y e 18 3 3 2 3 Sample Description 3 4 as al An ak Anka al d eee 19 3 3 2 4 Detector Description sanr aana a N DA Kl W n ee cee na 19 3 3 2 5 Template nz ba id colis ate aie Sak ES 19 3 3 2 6 Show Description orua nr a a Ea ces 20 3 3 24 Sort by Name 2 45 conet eb PEE abe tan aeae 248 20 GammaVision Report Writer v3 1 A44 BW 774810K 0914 3 3 2 8 Query NOW sec eU Iw eee e 20 nie ELM 20 3 3 3 Archive ElleS 22 AS le teen sue dte E e a dk 01 20 3 3 3 1 Associated Files to Archive KK KK KK KK KK KK RR KK KK ooo 20 3 3 3 2 Show Descriptions er e o 21 39 Selecon i voire iue oz e moie ai 21 3 3 3 4 Archive Path coe DROP PVP pe CE dake eS 22 3 3 3 5 Soft OptIODS vs yk j4r v ed Eu ug ERR RHET ERE Sele dee 22 3 3 3 6 Performing the Archive 0 0 cece eee di d aya eens 22 3 3 4 A e le alat a Deo d n Aa a mea stan etree 23 3 3 4 1 Associated Files to Purge 0 00 KK KK KK
6. Database Menu The Database menu shown in Fig 18 contains commands for database configuration and maintenance Define Select Analysis 3 3 1 Define The Define menu command displays the Analysis Database Archive Files Records Purge Files Records Definition dialog shown in Fig 19 This lets you select or Fig 18 Database Menu create a database file to be used for analysis results 16 774810K 0914 3 MENU COMMANDS Note the diagram at the top of the r Analysis Database Definition dialog depicting a cable connection between the Report and the Data DAPA Database base Under normal conditions the Report CET plug on the cable is shown as being Select Database Create Database connected indicating the database is a Data Source Name GvRpt Database connected to the Report Writer pro gram JA If Report Writer can Current Database C User GvRptDB2 Mdb not connect to the Current Data base for any reason the plug is Fig 19 The Database Report Connection shown as disconnected A and you must connect to a valid database file NOTE The Report Writer can only connect to a database file created with the Create Data base command in this dialog 3 3 1 1 Select Database Selecting connecting to a database is discussed in Section 2 3 As noted there the steps for selecting a database in Windows 7 depend on whether or not you ar
7. Desending Desending by Spectrum Name 31385 iter bottle s n 1752 Qa13b3 iter bottle s n 1752 Qa2013 iter bottle s n 1752 22032 iter bottle s n 1752 Qaf1b3 iter bottle s n 1752 on endcap of P40615 Da23b3 est sample Qa23b4 iter bottle s n 1752 Qa2d0 est sample iter bottle s n 1752 iter bottle s n 1752 iter bottle s n 1752 ranium ore DSPEC Qa3012 Qa3013 Qa3031 Qa3042 Coasts j mk a to mk Fig 22 The Archive Files Dialog will also be moved to the archive folder along with a database containing the GvDemo record Note the files are erased from the current folder The template files are only archived if they have the same name as the analysis files Common templates are not moved 3 3 3 2 Show Description The Sample option displays the sample description in the selection list box The Detector option displays the detector description in the selection list box 3 3 3 3 Selection The Select All button highlights all records in the list box Deselect All removes the highlight from all records Use the mouse plus the lt Ctrl gt and Shift keys to select particular records as you would in for example Windows Explorer To choose a contiguous block of records click the first record in the block then hold down the lt Shift gt key and click the last record Release Shift To choose a discontinuous set of records click the first record then hold down Ctrl and click each remaining reco
8. DetID INTEGER The Detector ID used to acquire the data GeoID INTEGER The Geometry ID used for the analysis Weight FLOATING The sample weight Units TEXT 16 The textual description for the unit UnitsNM FLOATING The units factor numerator UnitsDN FLOATING The units factor denominator RndErr FLOATING Random error value used for the analysis SysErr FLOATING Systemic error value used for the analysis TotalAct FLOATING The total activity of the sample AnalysisType INTEGER The analysis type flags AnalysisVer TEXT 16 The analysis version string SpcName TEXT 255 The file name of the spectrum file Libl Name TEXT 255 The name of the first library file 30 774810K 0914 5 DATABASE TABLE DEFINITIONS Field Name Data Type Description Lib2Name TEXT 255 The name of the second library file Lib3Name TEXT 255 The name of the third library file PbcName TEXT 255 The file name of the PBC table file CalName TEXT 255 The name of the original calibration file CalDesc TEXT 130 The calibration description text CalEnergyCreD DATE The energy calibration creation date CalEnergyCreT DATE The energy calibration creation time CalEfficiencyCreD DATE The efficiency calibration creation date CalEfficiencyCreT DATE The efficiency calibration creation time CalAfit INTEGER The above knee efficiency cali
9. KK KK KK KK K 23 3 3 4 2 Show Description pesanu armaa Kl awa nne 24 3 5 2 3 Selection e sume expe e Ehe bears db eta Ce atin YE es 24 3 3 4 4 File Options eese reed cire ede be eh ih erk E 24 3 3 4 5 SOF OPIO Lie Ege et eoe Pend Bede ae ee 24 3 00 40 PULSE FILES 2 Itt doe Aan ie E Oen Mz JM R 24 3 344 Cancel a ent eR EL Ut 24 3 2 8 LAS te is uen qo tm p repete eben era iste em ar OE Rs 24 34 Window Menu Deed nis e nx eran ep t tete ea tbe ka av 25 3 5 Help Men A e E P ERE EIS 25 4 AUTOMATIC COMMAND LINE MODE see ee 27 5 DATABASE TABLE DEFINITIONS 0 0 0 cece kk ek k k kk e ek 29 5 1 Application Table GvRptApplication KK KK KK KK KK KK KK KK KK KK KK 29 5 2 Analysis Table GvRptAnalysis W K kk KK kK KK KK KK ee 30 5 3 Identified Peaks Table GvRptPeak Lu KK KK KK KK KK KK KK KK KK KK KK KK KK 34 5 4 Unknown Peaks Table GvRptUnPeak AY kk KK KK KK KK KK KK KK KK KK KK KK KK 36 APPENDIX A CHANGING DATABASES WITH THE WINDOWS ODBC UTILITY 37 iv NOTE We assume that you are thoroughly familiar with Microsoft Windows usage and terminology The convention used in this manual to represent actual keys pressed is to enclose the key label within angle brackets for example F1 For key combinations the key labels are joined by a within the angle brackets for example Alt 2 gt 1 INTRODUC
10. OATING The peak counting uncertainty FWHM FLOATING The full width at half maximum in keV FW10M FLOATING The full width at 0 10 maximum in keV FW04M FLOATING The full width at 0 04 maximum in keV Flagl INTEGER The first set of peak flags Flag2 INTEGER The second set of peak flags Flag3 INTEGER The third set of peak flags RoiLow INTEGER The peak low limit of integration RoiHigh INTEGER The peak high limit of integration LibNum INTEGER The library index number from which the nuclide information was obtained For example a 1 indicates that the library information came from the first library file field Lib1Path in the Analysis Table Gammas FLOATING The gammas per 100 disintegration MDA FLOATING The MDA based on this peak Abundance FLOATING The isotopic abundance based on this peak 34 774810K 0914 5 DATABASE TABLE DEFINITIONS Field Name Nuclide Data Type TEXT 10 Description The nuclide name LibEnergy FLOATING The library energy for this peak HalfLife FLOATING The nuclide half life in days PBCFactor FLOATING The PBC correction factor Nflag INTEGER The nuclide analysis flags NucAbun FLOATING The calculated abundance of the nuclide in becquerels Hfactor FLOATING The decay time correction factor IsoError FLOATING The isotope counting error for this nuclide TotalError FLOATING The total error for
11. ORTEC GammaVision Report Writer for Microsoft Windows 7 and XP SP3 A44 BW Software User s Manual Software Version 3 1 Printed in U S A ORTEC Part No 774810 0914 Manual Revision K Advanced Measurement Technology Inc a k a ORTEC a subsidiary of AMETEK Inc WARRANTY ORTEC DISCLAIMS ALL WARRANTIES OF ANY KIND EITHER EXPRESSED OR IMPLIED INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE NOT EXPRESSLY SET FORTH HEREIN IN NO EVENT WILL ORTEC BE LIABLE FOR INDIRECT INCIDENTAL SPECIAL OR CONSEQUENTIAL DAMAGES INCLUDING LOST PROFITS OR LOST SAVINGS EVEN IF ORTEC HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES RESULTING FROM THE USE OF THESE DATA Copyright O 2014 Advanced Measurement Technology Inc All rights reserved ORTEC is a registered trademark of Advanced Measurement Technology Inc All other trademarks used herein are the property of their respective owners NOTICE OF PROPRIETARY PROPERTY This document and the information contained in it are the proprietary property of AMETEK Inc ORTEC Business Unit It may not be copied or used in any manner nor may any of the information in or upon it be used for any purpose without the express written consent of an authorized agent of AMETEK Inc ORTEC Business Unit TABLE OF CONTENTS T INTRODUCTI N iv pu TUI E Ver eiu e Vs ERU peer TIT ce 1 1 1 If You Have an Older Report Writer Version
12. Options Choose Send to the Recycle Bin to move the associated files to the Recycle Bin database records are deleted Choose Delete Files to remove files permanently 3 3 4 5 Sort Options The list of records can be displayed by order of date transferred to database sequential forward or reverse by spectrum name alphanumeric ascending or descending or by specific spectrum name the asterisk wildcard can be used 3 3 4 6 Purge Files Click this button to remove the selected database records and either move the associated files to the recycle bin or delete them 3 3 4 7 Cancel Click this button to exit the dialog without archiving 3 3 4 8 List The lower section of the dialog shows a list of database entries that have been selected from the database according to the query settings The list is only updated when you click Query Now The list shows the spectrum file name and the selected description To select a file from this list double click the name or single click to highlight it and click Select 24 774810K 0914 3 MENU COMMANDS 3 4 Window Menu The Window menu Fig 24 contains the standard Windows commands for the open windows within the application and Vertical Tile shows the windows currently open if any maran a Cascade Arrange Icons Auto Arrange Close All 1 GammaVision Plot v 2GammaVision Report Fig 24 The Window Menu 3 5 Help Menu f The Help men
13. TION The GammaVision Report Writer A44 BW transfers information from a GammaVision unfor matted output UFO analysis results file to a database and creates custom reports and spectrum plots from the database This program writes to a database so the analysis results can be used with off the shelf applications such as SAP BusinessObjects Crystal Reports or Microsoft Access You can generate reports by selecting either a UFO GammaVision analysis results file or an existing record in a Report Writer database GammaVision Report Writer can be run either automatically from GammaVision or as a standalone program Report Writer uses the Crystal Reports engine to generate reports employing Crystal Reports macro files as report templates GammaVision sample analysis SDF files can be set to report using these templates and different sample types can use different report templates This release of Report Writer includes two versions of the three default reports e GvComplete115 RPT and GvComplete11 RPT which have similar content to the default text report for respectively GammaVision v7 and GammaVision v6 x and older These reports are divided into five sections 1 a header section which includes the data acquisition and analysis inputs 2 an unidentified peak summary 3 a peak energy matrix containing the identified peaks 4 a library peak usage table and 5 a summary of nuclides in the sample e GvActivity115 RPT and GvA
14. a different target folder This option lets you store the reports on remote machines i e network directories Options e Export File The output report can be exported to one of several different formats discussed in the following paragraph e Print Plot with Report Mark this checkbox to include the plot with the report when the report is printed e Print on Completion Mark this checkbox to automatically print the report after it is created Export Report As If the Export File box is checked the report is saved in the file format specified in this section The default is Rich Text format RTF Other formats include Microsoft Word and Excel and Portable Document format PDF 3 2 1 2 Plot Clicking the Plot tab displays the l GammaVision Report Ween A SS property page shown in Fig 13 It contains the following options Report Plot Database Plot Title i Colors Plot Title An optional title can Cow be entered for the plot This replaces pa em pe A P pes the default title if left blank The As icis aine default plot title is composed of the Horizontal Vertical spectrum filename and the ROI file Energy C Channels Log Linear name Tic Marks M GridLines Tic Marks Y amp GridLines Full Scale V Auto Scale V Colors Clicking this button displays the Color Options dialog see Fig 14 It allows you to select specific colors for grid and tic Fig 13 T
15. ame 7 UncName8 TEXT 38 UNCREC User defined uncertainty name 8 UncName9 TEXT 38 UNCREC User defined uncertainty name 9 UncVall Double UNCREC User defined uncertainty value 1 33 GammavVision Report Writer v3 1 A44 BW 774810K 0914 Field Name Data Type Description UncVal2 Double NCREC User defined uncertainty value 2 UncVal3 Double NCREC User defined uncertainty value 3 UncVal4 Double NCREC User defined uncertainty value 4 UncVal5 Double NCREC User defined uncertainty value 5 UncVal6 Double NCREC User defined uncertainty value 6 UncVal7 Double NCREC User defined uncertainty value 7 UncVal8 Double NCREC User defined uncertainty value 8 UncVal9 Double az M ev i an i car in SEDI ez M as SIR ue NCREC User defined uncertainty value 9 5 3 Identified Peaks Table GvRptPeak This table contains the list of identified peaks Field Name Data Type Description AnalysisID INTEGER Link to analysis table PeakID AutoNumber Internal sequence number PeakNum INTEGER Contains the one based peak number Channel FLOATING The peak centroid in channels Energy FLOATING The peak energy in channels BkgCnt FLOATING The corrected background for the peak NetCnt FLOATING The corrected net area of the peak Uncertainty FL
16. as administrator checkbox GammaVision Report Writer v3 1 A44 BW 774810K 0914 GammaVision J GammaVision Report Writer E GammaVision Report Writer Use GammaVision Report Writer 7 ORTEC File Structures Manual Intel Lotus Applications 4 Back Fig 1 Select Report Writer Program Properties r j GammaVision Report Writer Properties d Security Details Previous Versions Advanced Properties General Shortcut Compatibility Choose the advanced properties want for this shortcut PS GammaVision Report Writer H9 Ms Target type Application p TORA Target location Gamma Vision Report Writer dk ence eii pd unauthorized activity Target x86 VGammaVision Report Writer GvRpt32 exe Run in separate memory space Start in Shortcut key None Ros Nemal window y Coa J Comment L Fig 2 Run As Administrator 2 1 1 Creating or Modifying Report Writer Templates As noted above the Report Writer templates are standard Crystal Reports that are connected to the GvRpt Database ODBC data source To modify or create a new report template you will need Crystal Reports v11 5 or Microsoft Visual Studio 2010 not supplied with A44 BW The GvComplete115 RPT and GvComplete11 RPT templates closely matches the content and 4 783620H 1013 2 INSTALLATION AND STARTUP layout of the default text report for t
17. base dialog 2 Accessing the proper ODBC utility is different for 64 bit Windows 7 vs 32 bit Windows 7 64 bit Windows 7 Enter the following executable filename in the search programs and files box Fig 26 and press Enter to open the ODBC Data Source Admini strator dialog used by Report Writer C Windows SYSWOW64 Odbcad32 exe 3 Odbcad32 Exe 77 See more results Vindows SYSWOW64 Odbcad32 ex x E Fig 26 Run Obdcad32 exe in 64 Bit Windows 7 e 32 bit Windows 7 From the Windows Control Panel select ODBC to open the ODBC Data Source Administrator dialog 3 Click the System DSN tab Fig 27 4 Click to highlight the GvRpt Database entry then click the Configure button This will open the dialog shown in Fig 28 5 Click the Select button to open the file open dialog shown in Fig 29 Select the desired database file and click OK then click OK as needed to return to the Control Panel 37 GammaVision Report Writer v3 1 A44 BW 774810K 0914 gt a 3 ODBC Data Source Administrator m ODBC Microsoft Access Setup EX User DSN System DSN File DSN Drivers Tracing Connection Pooling About Data Source Name mur rw Description GammaVision Report Writer Database ii Conca Name Driver Add Database Attenuation Microsoft Access Driver mdb Database C User GvRptDB2 mdb Help GVQA Microsoft Access Dri
18. bled PBFlag INTEGER Peaked background correction enabled RndSumFlag INTEGER Random summing enabled DecCorFlag INTEGER Decay correction enabled 31 GammaVision Report Writer v3 1 A44 BW 774810K 0914 Field Name Data Type Description GeoFlag INTEGER Geometry correction enabled AbsorFlag INTEGER Absorption curies UnitMcFlag INTEGER Units in microcuries Gamma3Flag INTEGER Library based peak stripping TempCalElnt FLOATING Temporary energy calibration value TempCalESlope FLOATING Temporary energy calibration value TempCalEShape FLOATING Temporary energy calibration value AbsorIntExtFlag INTEGER Flag is 2 if internal absorption 4 if external absorption AbsorLength INTEGER Absorber length AbsorName TEXT 255 Absorber name GeoRefName TEXT 255 Geometry correction reference UFO file EffCalFlag INTEGER Flag to indicate the spectrum has been efficiency calibrated IodineECTime FLOATING Iodine equivalence at current time IodineEDTime FLOATING Iodine equivalence at decay time AveECTime FLOATING Average energy calculation at current time AveEDTime FLOATING Average energy calculation at decay time Lib1Path TEXT 255 Full path name of the first library file Lib2Path TEXT 255 Full path name of the second library file Lib3Path TEXT 255 Full path name of the third library file PbcPat
19. bration fit type Note that the interpolative fit type is not supported in the database CalBfit INTEGER The below knee efficiency calibration fit type Note that the interpolative fit type is not supported in the database CalKnee FLOATING The Detector knee in keV CalAsig FLOATING The 2 sigma uncertainty in percent for the above knee calibration efficiency fit CalBsig FLOATING The 2 sigma uncertainty in percent for the below knee calibration efficiency fit CalEInt FLOATING The energy calibration intercept value CalESlope FLOATING The energy calibration slope value CalEShape FLOATING The energy calibration quadratic value CalFInt FLOATING The FWHM intercept value CalFSlope FLOATING The FWHM slope value CalFShape FLOATING The FWHM quadratic value CalAInt FLOATING The above knee efficiency vs energy intercept value CalASlope FLOATING The above knee efficiency vs energy slope value CalAShape FLOATING The above knee efficiency vs energy quadratic value CalBInt FLOATING The below knee efficiency vs energy intercept value CalBSlope FLOATING The below knee efficiency vs energy slope value CalBShape FLOATING The below knee efficiency vs energy quadratic value CalUnc FLOATING The calibration source uncertainty value CalDiff FLOATING The energy calibration difference value Operator TEXT 64 The operator name that appears on the reports DecAcqFlag INTEGER Decay during acquisition ena
20. ctivity11 RPT which present the data acquisition and analysis inputs and a summary of nuclides in the sample e GvMinimal115 RPT and GvMinimal11 RPT which report an abbreviated list of data acquisition and analysis inputs and the total activity in the sample If you are a first time user of GammaVision and GammaVision Report Writer use the version 11 5 templates which accommodate the new data fields introduced in GammaVision version 7 If you are upgrading from an earlier version of Report Writer or will report on data collected with GammaVision v6 x or older we recommend using the version 11 templates You can edit these templates or create your own with Crystal Reports v11 5 or Microsoft Visual Studio 2010 not included in A44 BW See also Section 2 1 1 Regardless of the template you select for reporting all of the data described in Chapter 5 is saved in the database GammaVision Report Writer v3 1 A44 BW 774810K 0914 1 1 If You Have an Older Report Writer Version If you already have an older version of Report Writer on your computer Any previous report templates will be retained during installation i e they will not be overwritten Do not delete older report templates or you will not be able to display your older reports in the same format as they were originally generated You will have to regenerate them using one of the new templates Older templates will be available for use in addition to the new tem
21. d so you can set the printer options This command is available only when a plot window Fig 10 is open 11 GammaVision Report Writer v3 1 A44 BW 774810K 0914 GammaVision Report Writer GammaVision Plot EA Ex File Options Database Window Help e x GvDemo MIXED GAMMA MARINELLI ON ENDCAP OF P40268A 1 0E05 T 10000 EL TT Energy keV File C User GammaVision V7 Examples GvDemo spc Detector 12592 122 1000 L H o o 4 0 ns 10H H Li 3 00 664 50 1326 00 1987 50 Acquired 07 Jun 1991 10 37 33 AM Real Time 4219 80 s Live Time 3600 00 s 2649 00 Channels 16384 Fig 10 Plot Window 3 1 4 Export This command exports a report based on the current Export Report As format on the Options tab under Settings Report Section 3 2 1 1 3 1 5 Exit This menu command closes the Report Writer program 12 774810K 0914 3 MENU COMMANDS 3 2 Options Menu The Options menu Fig 11 contains commands for setting plot report and program options Settings Always On Top 3 2 1 Settings Fig 11 Options This menu command displays a dialog box see Fig 12 that Ment contains options for the report plot and database sections 3 2 1 1 Report Clicking the Report tab in the l GarmmaVision Report WORSE os Lo jim upper left of the dialog displays a property page with the following options Template Th
22. e installed in Program Files and the Crystal Reports components are in Program Files Business Objects e The Report Writer database GvRptDB2 Mdb is in C NUser The default Crystal Reports templates are in C NUserNTmpl For Windows 7 users the final step is to flag the Start menu entry s Run as administrator option This works around a Windows 7 security feature that requires you to connect to data base files via the Windows ODBC utility On the Start menu locate the GammaVision Report Writer group expand it and right click the GammaVision Report Writer program entry This will open the context menu shown in Fig 1 Select Properties to open the dialog shown on the left of Fig 2 Click the Advanced button to open the dialog on the right of Fig 2 click the Run as administrator box then click OK twice When you Run as administrator each time you start a Report Writer work session a Windows user account security dialog will ask if you wish to allow the program to make changes to this computer Click Yes You can then change database files without having to use the Control Panel ODBC utility until the next Report Writer work session 1 e it resets each time you exit Report Writer NOTE Ifyou do not use the Run as administrator configuration Appendix A explains how to change databases with the Windows ODBC utility Alternatively you can create a desktop shortcut to Report Writer and follow the same steps to mark its Run
23. e running Report Writer in the Run as administrator mode as configured in step 3 of Section 2 1 Note that Report Writer can only connect to database files created with the Create Database command described in the next section 3 3 1 2 Create Database This button opens a dialog see Fig 20 that lets you create a new database formatted according to the current Data Source Name This means that if the current data source is GvRpt Data base the Create Database command will generate a new empty analysis report database Simi larly if the data source is GvRpt Archive Database Create Database will generate a new empty records archival database Be sure to first select the correct data source type with the Select Database command You may create as many databases as you wish Select the desired location enter the name you wish to assign the new database in the File name field and click Save to return to the Analysis Database Definition dialog The final step is to connect it to the report using the Select Database command as described in Section 2 3 17 GammaVision Report Writer v3 1 A44 BW 774810K 0914 n Create Database I OQ m Computer OS C User X Search User 2 Organize v New folder dE v e 3k Favorites Er Name f Date modified Type RE Desktop i ot n Downloads Ji GammaVision V7 Examples 3 Recent Places di Tmpl Atd Mdb A Libraries L GvQa32 Mdb MDB File
24. eak This table contains the list of unknown peaks Field Name Data Type Description AnalysisID INTEGER Link to analysis table UnPeakID AutoNumber Internal sequence number PeakNum INTEGER Contains the one based peak Channel FLOATING The peak centroid in channels Energy FLOATING The peak energy in channels BkgCnt FLOATING The corrected background for the peak NetCnt FLOATING The corrected net area of the peak Uncertainty FLOATING The peak counting uncertainty FWHM FLOATING The full width at half maximum in keV FW10M FLOATING The full width at 0 10 maximum in keV FW04M FLOATING The full width at 0 04 maximum in keV Flagl INTEGER The first set of peak flags Flag2 INTEGER The second set of peak flags Flag3 INTEGER The third set of peak flags RoiLow INTEGER The peak low limit of integration RoiHigh INTEGER The peak high limit of integration SuspectPeak TEXT 10 The suspected nuclide name for current energy Flag4 INTEGER Fourth set of peak flags 36 APPENDIX A CHANGING DATABASES WITH THE WINDOWS ODBC UTILITY If for some reason you cannot run GammaVision Report Writer in administrator mode clicking the Select Database button will display a permission error instructing you to connect to the data base via the Windows ODBC utility You can do this without exiting the Report Writer program 1 Close the message and the Select Data
25. eomName Text 255 EDFREC Geometry file name EdfBkgPath Text 255 EDFREC Background spectrum path EdfCsPath Text 255 EDFREC Cesium spectrum path EdfGeomPath Text 255 EDFREC Geometry file path EdfLow Double EDFREC Low integration limit keV EdfHigh Double EDFREC High integration limit keV EdfFlags Integer EDFREC Report and calculation flags EdfGeSeq Integer EDFREC Germanium sequence number EdfGtSeq Integer EDFREC Gamma Total sequence number ActConv Double EDFDAT Activity conversion factor Cs137Eff Double EDFDAT Cesium Efficiency at 662 keV EdfGrossCnts Long EDFDAT EDF sample gross counts GammaTotalBq Double EDFDAT Gamma Total in Bq EdfBkgCPS Double EDFDAT Background CPS from background spectrum EdfBkgCnts Long EDFDAT EDF sample background counts KFactor Double EDFDAT K calculation from Cs spectrum CsGrossCnts Long EDFDAT EDF gross counts from Cs spectrum CsBkgCnts Long EDFDAT EDF background counts from Cs spectrum CsActBq Double EDFDAT 662 keV activity in Bq from Cs spectrum CsPeakArea Double EDFDAT 662 keV area from Cs spectrum UncNamel TEXT 38 UNCREC User defined uncertainty name 1 UncName2 TEXT 38 UNCREC User defined uncertainty name 2 UncName3 TEXT 38 UNCREC User defined uncertainty name 3 UncName4 TEXT 38 UNCREC User defined uncertainty name 4 UncName5 TEXT 38 UNCREC User defined uncertainty name 5 UncName6 TEXT 38 UNCREC User defined uncertainty name 6 UncName7 TEXT 38 UNCREC User defined uncertainty n
26. file or click to highlight it E A atd mdb 21 GvDemo Mdb then click Open You are Desktop 21 GvQA32 backup 070801 mdb ready to begin generating Bi evaase Mdb f B GvRptarchiveDB2 mdb Bl GvR ptDB2 mdb 21 150_new mdb lt reports My Documents ii gt My Computer File name G RptDB2 mdi Files of type Database File MDB E Cancel Fig 5 The Select Database Dialog 783620H 1013 2 INSTALLATION AND STARTUP 2 3 2 Windows 7 Run as administrator NOT marked If you do not run Report Writer in the Run as administrator configuration described in Section 2 1 clicking the Select Database button will display a permission error instructing you to connect to the database via the Windows ODBC utility You can do this without exiting the Report Writer program as described in Appendix A GammaVision Report Writer v3 1 A44 BW 774810K 0914 Intentionally blank 3 MENU COMMANDS This chapter describes the menu commands and accelerators for the GammaVision Report Writer 3 1 File Menu The File menu see Fig 6 contains commands for opening Bep UFO files printing and plotting as well as exiting the Recall UFO program Print Report Print Plot 3 1 1 Recall UFO Export This menu command lets you select a UFO file and creates a Eu m M report for it using the previously selected template Figure 7 Fig 6 File Menu shows the file selection dialog and Fig
27. h TEXT 255 Full path to the PBC table file CalPath TEXT 255 Full path to the original calibration file AbsorPath TEXT 255 Full path to the absorber file GeoRefPath TEXT 255 Full path to the reference UFO file FractionLimit FLOATING Percent of gamma rays that must be found to identify an isotope UFOName TEXT 255 Name of this UFO file MPCFlag INTEGER Flag indicating state of the MPC DAC table AnalysisPgm TEXT 32 AN3REC Analysis program name SearchSens Integer CALREC Peak Search Sensitivity ColStart Date Date Time ACQINF Collection Start date ColStartTime Date Time ACQINF Collection Start time ColEndDate Date Time ACQINF Collection End date ColEndTime Date Time ACQINF Collection End time PeakUncAbove Double DATREC Peak uncertainty above the knee PeakUncBelow Double DATREC Peak uncertainty below the knee HalfLives Double ANEXT1 Half lives decay limit ActRange Double ANEXT Activity range factor 32 774810K 0914 5 DATABASE TABLE DEFINITIONS Field Name Data Type Description StepEnergy Double ANEXT1 Minimum step background energy MDA2 Integer ANEXTI Second MDA WeightUnc Double ANEXT1 Sample weight uncertainty in percent PBCWidth Double ANEXTI PBC Match Width EdfBkgName Text 255 EDFREC Background spectrum name EdfCsName Text 255 EDFREC Cesium spectrum name EdfG
28. he Plot Tab marks spectrum data ROI boxes or fill axis labels and descriptive text 14 774810K 0914 3 MENU COMMANDS ROI This section governs the fill mode for areas marked Color Options as ROIs In Boxed mode each ROI is marked with a box The box is as wide as the ROI and about 75 of the plot height Monochrome In Filled mode each ROI is drawn as a striped area extending Grid and Tics Wi Black y from the spectrum to the baseline Spectrum Data EN Red Z Roi Box or Fil gt Text The Axis Labels and or Description text can either ee Oe 5 be printed or suppressed Axis Labels BIB Black Other Text Horizontal This section contains two radio buttons that allow you to specify the horizontal axis in Channels or Energy Energy is not available if the spectrum is not cali Fig 14 The Color Options brated Tic Marks and or Grid Lines can be displayed for Dialog this axis by marking one or both of the checkboxes The grid lines change as the horizontal axis is expanded or contracted To select a horizontal range mark Full Scale or click Range to choose a specific range in channels or energy Clicking Range displays the Horizontal Range Options dialog shown in Fig 15 The range options need not be the same as the plot options that is the range can be in channels with the plot in energy Vertical This section contains two radio butt
29. heir respective GammaVision versions and can be used as an example to create a custom report Chapter 5 lists all data available for your custom reports NOTE When creating or modifying a template in the Crystal Reports program make sure that the Save data with file command on the File menu is not checkmarked Note that this command is only displayed when a template file is being edited 2 2 Startup From the Windows Start menu enter gam in the Search programs and files box then click the GammaVision Report Writer search result or open the Windows Start menu and click GammaVision Report Writer then GammaVision Report Writer Windows 7 users running in administrator mode see step 3 in Section 2 1 will see a Windows user account security dialog Click Yes to give Report Writer permission to make changes on this computer The Report Writer window will E Gammavision Report Writer i ooxy open Fig 3 If Report Writer cannot connect to the most recently selected database for example on first startup or if the database file has been moved renamed or deleted the Analysis Database Definition dialog Fig 4 will immediately open and you must connect to a database file as described in the next section Fig 3 Report Writer Window at Startup 2 3 Selecting Connecting to the Report Database On the Database menu click Define to open the Analysis Database Definition dialog shown in Fig 4 This d
30. ialog lets you select an existing database file or create a new database to be used for analysis reports Note the diagram at the top of the dialog depicting a cable connection between the Report and the Database Under normal conditions the plug on the cable is shown as being connected indicating the database is connected to the Report Writer program AP GammaVision Report Writer v3 1 A44 BW 774810K 0914 E Analysis Database Definition pues AN Database eporl Cancel Select Database Create Database Data Source Name GvRpt Database Current Database C NUserGvRptDB2 Mdb Fig 4 The Database Report Connection If Report Writer cannot connect to the Current Database for any reason the plug is shown as disconnected JA X and you must connect to a valid database file as follows NOTE The Report Writer can only connect to a database file created with the Create Data base command in this dialog see the instructions in Section 3 3 1 2 The default database is GvRptDB2 mdb However you may create as many databases as you wish 2 3 1 Windows 7 Run as administrator marked and Windows XP Click the Select Database Select Database button to open the Select ban j sf agree Database dialog Fig 5 ES E Test Files Bl IsotopicDB070522v3 mdb To complete the connection LJ Gm Ai IsotopicDB 070508 mdb double click the desired se B NI isotopi 07022
31. is is the template used to create the report Enter the complete name or use Browse to find the template This is the default name if no name is given on the command line The Report Writer program inter acts with the GammaVision Sam ple Type and Report Generator functions The report template Report Plot Database Template cau ser Tmpl G vComplete11 Rpt Report Destination C User Browse Options Export File Print Plot with Report Print on Completion Export Report As ASCII Text Crystal Reports C Excel 5 0 Rich Text C Word for Windows Portable Doc Fig 12 The Report Tab selected here is used in Gamma Vision when the Report Generator command is issued It also then becomes the default Report Writer template on the Report tab under Sample Type If a different template is selected in GammaVision using the Report Generator command s Setup option that template is communicated back to the Template field on the Report Writer s Report tab Note however that GammaVision s Sample Type Report tab does not communicate with the Report Writer or the Report Generator command If you choose a different template on the Sample Type Report tab it will be used only for the GammaVision analysis report 13 GammaVision Report Writer v3 1 A44 BW 774810K 0914 Report Destination The report is created by default in the same folder as the UFO file Alternatively you can specify
32. late choose a new report template using the Browse button then select a template file to be used The template specified will be replaced by the template name stored with the selection when a new selection is made 19 GammavVision Report Writer v3 1 A44 BW 774810K 0914 3 3 2 6 Show Description Choose between showing the Sample description or the Detector description in the list of files 3 3 2 7 Sort by Name The list of spectra is normally shown in the order the spectra were stored in the database The list can also be displayed in alphanumeric or reverse alphanumeric order Select Ascending for alphanumeric order and Descending for reverse alphanumeric order Select neither for chrono logical order The redisplay is done by clicking Query Now discussed in the next paragraph 3 3 2 8 Query Now This button performs a query based on options from the Query Options box This must be done to update the list of spectra shown 3 3 2 9 List The lower section of the dialog shows a list of database entries that have been selected from the database according to the query settings The list is only updated when you click Query Now The list shows the spectrum file name and the selected description To select a file from this list double click the name or single click to highlight it and click Select 3 3 3 Archive Files This opens the Archive Files dialog see Fig 22 which allows you to archive the database and optionall
33. late TEXT 255 The template name and full path that was used when the report was generated 29 GammavVision Report Writer v3 1 A44 BW 774810K 0914 5 2 Analysis Table GvRptAnalysis This table contains fields common to the analysis Field Name Data Type Description AppID INTEGER Link to application table AnalysisID AutoNumber Internal sequence number AcquiredDate DATE The acquisition date AcquiredTime TIME The acquisition time LiveTime FLOATING The live time in floating point seconds RealTime FLOATING The real time in floating point seconds SampleDesc TEXT 130 The sample description DetDesc TEXT 130 The Detector description StartChn INTEGER The starting channel for the analysis EndChn INTEGER The ending channel for the analysis Sigma INTEGER The standard deviation or confidence level for uncertainty 1 2 or 3 RndSumFactor FLOATING The random summing factor for the analysis CorrDate DATE The decay correction date CorrTime TIME The decay correction time AbsorpFactor FLOATING The absorption factor for the analysis PeakAccWidth FLOATING The acceptance width for peaks PeakError FLOATING The peak error cutoff value for the peak search It is recorded in percent MDAType INTEGER The MDA type for the analysis BkgCalc INTEGER The background calculation type for the analysis
34. ll connect to the wrong type of database 3 3 3 5 Sort Options The list of records can be displayed by order of date transferred to database sequential forward or reverse by spectrum name alphanumeric ascending or descending or by specific spectrum name the asterisk wildcard can be used 3 3 3 6 Performing the Archive To transfer the selected records and or files to the archive database and folder click Move Files To copy the selected records and or files to the archive database folder leaving the original files records in the current database folder click Copy Files To exit the dialog without archiving click Cancel 22 774810K 0914 3 MENU COMMANDS 3 3 4 Purge Files This menu command displays a dialog shown in Fig 23 that allows you to remove analyses from the existing database Purge options include removing the database records UFO SPC ROI and report template files When you click the Purge Files button the selected records are removed from the database and the associated files are sent to the Windows Recycle Bin or permanently deleted r Purge Files Associated Files to Purge Show Description Selection Purge Files IV Templates V SPC Files Sample __ Select All Page Files iv UFOFiles M C Detector __ Deselect All File Options Send Files to the Recycle Bin C Delete Files Unrecoverable Sort Options Asending Asending by Spectrum Name C Search for Spectru
35. m Name Descending Desending by Spectrum Name Name Description ________ __ i Z z VZ1d a1385 iter bottle s n 1752 Qal3b3 iter bottle s n 1752 Qa2013 iter bottle s n 1752 Qa2032 iter bottle s n 1752 Qaf1b3 iter bottle s n 1752 on endcap of P40615 Qa23b3 est sample Qa23b4 iter bottle s n 1752 Qa2d0 est sample iter bottle s n 1752 iter bottle s n 1752 iter bottle s n 1752 ranium ore DSPEC Qa3012 Qa3013 Qa3031 Qa3042 esa yt mj md mk and nk nd Fig 23 Choose Records and Associated Files to be Purged 3 3 4 1 Associated Files to Purge These check boxes indicate whether or not to purge the associated UFO SPC ROI and or RPT files from the current folder For example if GvDemo is selected from the list box and the SPC Files box is marked the GvDemo spc file will be purged along with the GvDemo data base record Note that the files are purged from the current folder The template files are only purged if they have the same name as the analysis files Common templates are not purged 23 GammaVision Report Writer v3 1 A44 BW 774810K 0914 3 3 4 2 Show Description The Sample option displays the sample description in the selection list box The Detector option displays the detector description in the selection list box 3 3 4 3 Selection The Select All button highlights all records in the list box Deselect All removes the highlight from all records 3 3 4 4 File
36. o 17 Run as administrator marked 3 Run as administrator not marked 37 Selec mai V Eee E das 21 24 Show Description o oooooooo 20 21 24 Sort by Name 4 lt i xalk Helen k4 k ea 20 Sort Options 6 35 2 3 A 204 Er EA 22 24 Template see Report Template 19 Mi y A resets n vare o NON e SEE eke eae 15 i bil RRA O DN RO Ma 14 Unknown Peaks Table 36 Veft Gak AXIS yn yA ah b ww SEK RU 15 Window menu aa RR eee ee 25 40
37. omatic mode 2 0 KK eee eee 27 Colors oia HNHNnE N HN ED EHD DJ JJJ 14 Create Database LL AV KK RR KK KK KK KK 17 Database select connectto 5 37 Database menu 1 AY KK KK RR KK KK KK 16 Archive Files o ooo ooooooo 20 DEM RES EN fo 16 Purge files coner AA aie 23 Select Analysis o oooo oooo oooo o o 18 Database table definitions 29 Analysis table o ooo oo o o o 30 Application table 29 Identified peaks table 34 Unknown peaks table 36 Date Range 000000 18 Define Create database SS KK 17 Detector Description 00 19 EX see t Cv ede as An EN S er ES 12 EXPO st qe Sete ENDE eor ets 12 Export Report aS WAY KK KK KK KK KK KK KK 14 El Met See E NI e pes 9 EX doo an n0 2 o ve ed rtm 12 EXPO A Sr eere 12 Print plot 22 0 A KK KK KK KK KK KK 11 Print report 0 2 KK KK KK KK KK 10 Recall UFO eseeeess 9 File Options KK KK KK KK 0000 24 Helpmenu 0 0 0 0 e 25 Horizontal Axis LV KK KK KK KK eee 15 Horizontal Range AW KK KK KK KK KK 15 Identified Peaks Table 34 Interactive mode n u KK RR o 9 File Meno 5 y y ae Qe ee eas 9 ODBC utility in Windows 3 7 22 37 Options menu A KK KK 000000000 13 Always On Top 00005 16 Plot Tabu inte n n w 0534 14 Rep
38. ommand uses the default printer to print the report currently displayed in the report window This command is available only when a report window Fig 9 is open 10 774810K 0914 3 MENU COMMANDS Lo GammaVision Report Writer GammaVision Report File Options Database Window Help GammaVision Report Writer Version 3 10 G701W040 08 Nov 2013 12 52 41AM Page 1 DB Analysis ID 1 Sample Description MIXED GAMMA MARINELLI ON ENDCAP OF P40268A SpectrumF ilename GvDemo An1 Acquisition Information Start Time 07 Jun 1991 10 37 33AM Live Time 3600 00 4219 80 Dead Time Detector ID Detector System 14 69 96 12592 12296 Calibration Description Energy Created Zero Offset 3 771 keV Libra i GvDemo Lib Library 2 File Null Lib Library 3 File Null Lib Analysis Parameters Start Channel Stop Channel Pesk rejection level Activity Scaling Factor Detection Limit Method Sample Size Additional random error Filename CAUseriGammaVision V7 Examples GvDemo Spc 05 Apr 1995 8 44 58AM Efficiency Created 07 Jun 1991 10 37 33AM Gain 0 162 keV Channel 200 for an energy of 36 07 keV 16 000 for an energy of 2588 56 keV 50 000 96 1 0000 1 0000 1 0000 Traditional ORTEC Method 1 00E 000 0 0000 Fig 9 Report Window 3 1 3 Print Plot This command prints the plot currently displayed in the plot window A standard print dialog box is displaye
39. ons that allow you to specify the vertical axis as Logarithmic or Linear Tic Marks and or Grid Lines can be displayed for this axis by marking one or both of the checkboxes The grid lines change as the vertical axis is expanded or con tracted the baseline is always zero Mark Auto Scale for automatic scaling or click Range to choose a specific range on the Vertical Range Options dialog shown in Fig 16 Horizontal Range Options Vertical Range Options Enter the Maximum Value for the Vertical Axis 100000 Enter the Range for the Horizontal Axis Units Energy C To 512000000 Channels 6 From dada z Fig 16 Choose the Vertical Range Fig 15 Horizontal Range 15 GammavVision Report Writer v3 1 A44 BW 774810K 0914 3 2 1 3 Database Clicking the Database tab displays the property page shown in Fig 17 It allows you to include the identified and or unidentified peaks in the database Note that this could add a large number of fields to the database The peak lists are useful for making reports on specific peaks f GammaVision Report Writer Properties ES Report Plot Database Dptions Iv Include Identified Peaks Iv Include Unidentified Peaks Fig 17 The Database Tab 3 2 2 Always On Top When this option is enabled click to checkmark it on the menu the Report Writer is always displayed on top of other windows 3 3
40. ort tab eo KK KK KK KK KK 13 SOMOS scissors 13 Plot Tab eade dand e AKA N Ker 55433 14 eu M ia ptas 14 Horizontal axis KK KK KK 15 Horizontal range LL KK 15 ROI fill mode RR 15 Text co ot a mm 15 Title ie eo a tete ee bee Perd 14 Vertical axis eee eee 15 Print Plot cR SAN Stace Hees 11 Print Plot with Report oo oco ooo oo 14 Print Report eese 10 Purge Blesa 23 24 Associated files to purge 23 File options KK KK KK KK KK 24 Purse files yaka Cae ete een PES 24 Selection one ei ee es 24 Show description 0 24 Sort options 0 000008 24 Query Now atours teere Pen cece eee eee 20 Recall UFO lt s salk K eee 9 Report Tab Export report aS ALL KK KK KK eee eee 14 Print plot with report 14 Report template oooo ooooo 13 Report Template 4 13 19 Creating or modifying 4 ROI Fill Mode KK KK RR RR RR KK 15 Sample Description ooo oooo oooo o o 19 Select Analysis Date range A LL A KK KK KK KK KK KK 18 Detector description 19 Query now u KK KK KK KK ees 20 Report template ooooooooo 19 Sample description 19 Show description oo oooo oooo o o 20 GammavVision Report Writer v3 1 A44 BW 774810K 0914 Sort by name SAS KK KK KK KK 20 Select Database ooooooooomo o
41. plates Your previous Report Writer database GvRptDB2 mdb and all its contents will be retained and updated to the Report Writer v3 10 database format In addition your pre vious archive database GvRptArchiveDB2 mdb and all its contents will be retained and updated to the v3 10 format Other database files created with previous Report Writer versions will be automatically updated the next time you connect to them with the Select Database command Section 2 3 NOTE Ifyou are upgrading from an older version of Report Writer we strongly recommend you make a backup copy of all existing database files before installing the new application 2 INSTALLATION AND STARTUP 2 1 Installation You must have Administrator access in Windows to install GammaVision Report Writer 1 2 wm 3 Insert the GammaVision Report Writer CD navigate to the CD drive then locate and open Setup exe One or more security dialogs will open If security dialogs are displayed choose the continue or install anyway option then the installation wizard will start Click Next and move through the wizard screens to completion The file locations are as follows In 64 bit Windows 7 the GammaVision Report Writer program files are installed in the Program Files x86 folder and the Crystal Reports program components are stored in the Program Files x86 Business Objects folder In 32 bit Windows 7 and in XP the Report Writer files ar
42. rd you want to select Release Ctrl 21 GammavVision Report Writer v3 1 A44 BW 774810K 0914 3 3 3 4 Archive Path All selected files and records will be moved to the archive database local or network listed in this field If the archive database already contains records the current records will be merged in the existing records will not be overwritten The default archive database is GvRptArchiveDB2 mdb As noted in the introduction for this command the Report Writer can only archive to a database file created with the Create Data base command for the GvRpt Archive Database data source Section 3 3 1 2 If you wish to create new archive databases you must create them before configuring the Archive Files command To select connect to a different archive database e Windows 7 in Run administrator mode Windows XP Click Browse then locate and select the desired archive database e Windows 7 Run as administrator disabled As detailed in Section 2 3 users of 64 bit Windows 7 must issue the C Windows SYSWOW64 Odbcad32 exe to access the correct ODBC utility and 32 bit Windows 7 users must make this connection via the Windows Control Panel ODBC utility For both versions of Windows 7 on the System DSN tab Fig 27 on page 38 be sure to highlight the GvRpt Archive Database entry not GvRpt Database before clicking the Configure button and selecting the desired archive database Otherwise you wi
43. s the report template setting on the Settings dialog Section 3 2 1 1 27 GammaVision Report Writer v3 1 A44 BW 774810K 0914 Intentionally blank 28 5 DATABASE TABLE DEFINITIONS This section contains the database table definitions for the GammaVision Report Writer This database does not replace the UFO file Its primary purpose is to provide a specifically chosen data set s to custom report generators such as Crystal Reports Data stored in the UFO file but not used in the reports is not stored in the database There are four tables in the database as shown in Table 1 Three tables contain analysis results and the fourth contains application specific data Table 1 Report Writer Database Table Contents Application GvRptApplication Version information Analysis GvRptAnalysis One record per analysis Unknown Peaks GvRptUnPeak Peak records only Identified Peaks GvRptPeak Peak and nuclide records The following sections describe these tables in more detail 5 1 Application Table GvRptApplication This table contains system wide information Field Name Data Type Description AppID AutoNumber Internal sequence number AppName TEXT 64 The name of the application GammaVision Report Writer that defined the database AppVers TEXT 64 The version of the application that defined the database Laboratory TEXT 80 The laboratory name that appears on the reports RptTemp
44. this nuclide IsoMDA FLOATING The isotope MDA for this nuclide PKFlag INTEGER Information about the library peak record PKPrevious INTEGER The number of the previous peak record This is used for formatting the report MPCVAL FLOATING MPC or DAC value for this isotope NuclideCode INTEGER Nuclide code flags PeakCode INTEGER Peak type code flags LibraryUsed INTEGER Which library was used 1 2 or 3 MDA2 FLOATING The second MDA based on this peak Pkunact FLOATING Counting uncertainty in Bq ErrorBq FLOATING Isotope counting error in Bq TotalErrorBq FLOATING Total error in Bq Flag4 Integer Fourth set of peak flags IsoMDA2 Double Second MDA value IsoNormMDA Double ISO NORM MDA for this isotope Brunct Double Branching ratio uncertainty Acl Double ISO NORM critical level Amda Double ISO NORM MDA Ahat Double ISO NORM Best estimated activity Alow Double ISO NORM Lower confidence interval Ahigh Double ISO NORM Upper confidence interval Uhat Double ISO NORM Uncertainty of Ahat ConvUnc Double ISO NORM Uncertainty of conversion factor BetaError Double ISO NORM Beta error Type II 35 GammaVision Report Writer v3 1 A44 BW 774810K 0914 5 4 Unknown Peaks Table GvRptUnP
45. u s About About GammaVision Report Writer command Fig 25 provides s s gt ES GammaYision Report Writer Version 3 10 version information that may be needed should you require Composes reports and optionally plots spectra based technical assistance upon the results of GammaVision spectral analyses Copyright Y 2013 Advanced Measurement Technology Inc Fig 25 The Help Menu 25 GammaVision Report Writer v3 1 A44 BW 774810K 0914 Intentionally blank 26 4 AUTOMATIC COMMAND LINE MODE This section describes the command line options for the GammaVision Report Writer It is run in this mode from GammaVision or any other program GVRPT32 EXE UFO File C P E T Template Name where UFO File C T Template Name The full path name of the UFO file There is no default Specifies Configure Mode where it displays only the property pages The default is normal mode Specifies Process and Exit mode This switch causes the Report Writer to store the results in the database and silently apply the settings defined on the Report page of the Properties dialog This includes the printing and exporting options as well as the report destination folder Once the options are complete the Report Writer exits The default is normal mode Sends any errors to the Error Log file The default is to not create the file Is the full path of the template to be used The default i
46. ver mdb Coan tene Repar compact GvRpt Archive Database Microsoft Access Driver mdb Advanced Microsoft Access Driver mdb System Database 9 None O Database System Database An ODBC System data source stores information about how to connect to Options the indicated data provider A System data source is visible to all users 3 on this machine including NT services ox _ sony Help la d Fig 27 System DSN Tab r Select Database posi priced GvRpt Project ABC mdb c user Cancel Atd Mdb e c GvGa32 Mdb GvRpt Project ABC m E Help GvRptArchiveDB2 MdE j GvRptDB2 Mdb C3 Gamma Vision V7 F Read Only Liz GV 701 files B LO mel E Exdusive List Files of Type Drives Access Databases m v Ezi c OS X Network Fig 29 Select the Target Database File 6 At this point return to the Report Writer window and begin generating reports 38 Fig 28 Click Select to Choose a Database File Administrator status in Windows 3 5 Analysis Table 0000000005 30 Application Table 00 00 29 Archive Ple 535z e Mer 20 path to archive database 22 A eee NI er 21 Show description ooo oooo oooo o o 21 Sort options l l 22 Associated Files to Archive 20 Associated Files to Purge 23 Aut
47. y a range of supporting files to an archive folder and database The database is stored by default The options include storing the UFO SPC ROI and RPT files in the same sub folder that holds the archive database The displayed description can be selected from either the sample or detector description When you click the Copy Files or Move Files button the selec ted database records and files are copied or moved to the archive database immediately Note that there is no undo for this operation You can create as many archive databases as you wish and can copy and or move records as desired to tailor these databases to your needs Before using Archive Files you must create the archive database s and folder s you wish to use with the Create Database command Sec tion 3 3 1 2 then connect to the archive database as described in Section 2 3 3 3 3 1 Associated Files to Archive These check boxes indicate whether or not the associated file s will be archived For example if GvDemo is selected from the list box and the SPC Files box is checked the GvDemo spc file 20 774810K 0914 3 MENU COMMANDS r Archive Files Associated Files to Archive Show Description Selection Copy Files IV Templates V SPC Files Sample Select All iv UFO Files M ei Ec __ Deselect All Move Files Archive Path Cancel C AUser GvAptArchiveDB2 mdb Sort Options Asending Asending by Spectrum Name Search for Spectrum Name C
Download Pdf Manuals
Related Search