Reports tool work directly from the GRIN-Global table and fields, the data must be doesn’t dragged from the GG dataview into a spreadsheet from which the Crystal Reports report is designed. For example, the Order Packing dataview was created and then the Order Packing by Accession report was designed using the fields displayed by the dataview. The main steps are: Open the Curator Tool; bring up sample data in the dataview on which the report is to be based Select all data by double clicking upper left corner CTRL drag data from CT dataview to an Excel spreadsheet (use CTRL to get schema field names instead of friendly names) In the spreadsheet, delete sheet2 and sheet3 Save spreadsheet as type Excel 97-2003 Workbook (*.xls) Open Crystal Reports Select Report Wizard Click Create New Connection Click Access/Excel (DAO) Choose Database Type: Excel 8.0 For Database Name: use ... to browse to saved xls file Finish Proceed with creating the report by selecting fields from sheet1 and designing the report (the Crystal Reports details of report design are omitted here) Save the report file and place in the Curator Tool Reports directory Location of the Crystal Report (.rpt) Files The .rpt files must be stored in a specific folder in order for the CT to use them. Typically the Curator Tool user will have these files loaded in this folder: Operating System Folder Containing the ReportsMapping.txt File Windows 7.1; 8; 8.1 C:\Program Files (x86)\GRIN-Global\GRIN-Global Curator Tool\Reports Public Website Reports The Public Website has a menu option for Reports. Reports can be added as they are developed to meet an needs. organization’s
Reports tool doesn’t work directly from the GRIN-Global table and fields, the data must be dragged from the GG dataview into a spreadsheet from which the Crystal Reports report is designed. For example, the Order Packing dataview was created and then the Order Packing by Accession report was designed using the fields displayed by the dataview. The main steps are: Open the Curator Tool; bring up sample data in the dataview on which the report is to be based Select all data by double clicking upper left corner CTRL drag data from CT dataview to an Excel spreadsheet (use CTRL to get schema field names instead of friendly names) In the spreadsheet, delete sheet2 and sheet3 Save spreadsheet as type Excel 97-2003 Workbook (*.xls) Open Crystal Reports Select Report Wizard Click Create New Connection Click Access/Excel (DAO) Choose Database Type: Excel 8.0 For Database Name: use ... to browse to saved xls file Finish Proceed with creating the report by selecting fields from sheet1 and designing the report (the Crystal Reports details of report design are omitted here) Save the report file and place in the Curator Tool Reports directory Location of the Crystal Report (.rpt) Files The .rpt files must be stored in a specific folder in order for the CT to use them. Typically the Curator Tool user will have these files loaded in this folder: Operating System Folder Containing the ReportsMapping.txt File Windows 7.1; 8; 8.1 C:\Program Files (x86)\GRIN-Global\GRIN-Global Curator Tool\Reports Public Website Reports The Public Website has a menu option for Reports. Reports can be added as they are developed to meet an organization’s needs.
gg_admin_guide.docx