Term
Define the following:
Database |
|
Definition
| AN ORGANIZED COLLECTION OF DATA TREATED AS A UNIT |
|
|
Term
Define the following:
DBMS |
|
Definition
| SOFTWARE PROGRAM USED TO CREATE AND MAINTAIN THE STRUCTURE OF A DATABASE |
|
|
Term
Define the following:
Relational Database |
|
Definition
| A COLLECTION OF INTERRELATED TABLES |
|
|
Term
Define the following:
SQL |
|
Definition
| STRUCTURED QUERY LANGUAGE - A STANDARD COMPUTER LANGUAGE ALLOWING ACCESS TO THE DATABASE, DATA SELECTION, INSERTION OF NEW RECORDS, UPDATING AND DELETION OF RECORDS, ETC |
|
|
Term
Define the following:
Query |
|
Definition
| ASKING THE DATABASE A QUESTION USING A PREDEFINED FORMAT (SQL) AND RETRIEVING INFORMATION FROM THE DATABASE IN RESPONSE TO THE QUESTION |
|
|
Term
| What is Oracle, what components does it include, and how does it store data? |
|
Definition
1.ARELATIONAL DBMS
2.A SET OF PROCESSES RUNNING IN YOUR OPERATING SYSTEM
3.A RELATIONAL DATABASE STORING THE DATA IN THE FORM OF INTERRELATED TABLES AND COLUMNS
4. IT INCLUDES PROGRAMMING LANGUAGES, FACILITIES AND UTILITIES TO SUPPORT ENTERPRISE-LEVEL APPLICATIONS |
|
|
Term
What are the two types of Retail Pro predefined reports originally created in Crystal Reports?
What are the differences between the two and what are the advantages of each? |
|
Definition
“CANNED” REPORTS INSTALLED WITH RETAIL PRO 9
- CORE – REGISTERED IN REPORT VIEWER WHERE THEY CAN BE VIEWED/PRINTED
- GENERIC - INSTALLED IN THE BONUS DIRECTORY AND DESIGNED TO BE USED AS A BASE FOR CREATING CUSTOM REPORTS - AVAILABLE FIELDS LIST WAS EXPANDED TO INCLUDE EVERY POSSIBLE FIELD FOR THAT CATEGORY
|
|
|
Term
|
Definition
|
|
Term
| What is the purpose of establishing table relationships? |
|
Definition
| RELATIONSHIPS ARE CREATED BETWEEN TABLES IN ORDER TO RETRIEVE INFORMATION FROM RELATED RECORDS WITHIN THOSE TABLES |
|
|
Term
| Define “stored procedure” and list several points regarding the stored procedures that are referenced by the predefined reports. |
|
Definition
- STORED PROCEDURES ARE PROGRAMS THAT RUN INSIDE THE DATABASE
- RESPONSIBLE FOR RETRIEVING DATA FOR THE REPORT
- DEFINES ALL FIELDS AND PARAMETERS AVAILABLE TO THE REPORT
- DEFINES ALL TABLE RELATIONSHIPS
- MAY DEFINE SORT ORDERS, FIELD GROUPINGS, AND FILTER CRITERIA
- OPTIMIZED FOR PEAK PERFORMANCE
|
|
|
Term
| Why should you NEVER make changes directly to a core or generic predefined report? |
|
Definition
| APPLYING A RETAIL PRO MAINTENACE PACK OVERWRITES THE PREDEFINED REPORTS WITH THE CURRENT VERSION OF THE PREDEFINED REPORTS AS DEFINED BY RETAIL PRO. THUS ANY CUSTOM CHANGES YOU HAVE MADE DIRECTLY TO ANY OF THE PREDEFINED REPORTS ARE OVERWRITTEN BY THE MP. |
|
|
Term
| What happens to the stored procedure referenced by a predefined report when you make a copy of the report? How many reports can reference the same stored procedure? |
|
Definition
- NOTHING. THE COPIED REPORT WILL SIMPLY USE THE EXACT SAME STORED PROCEDURE AS THE REPORT IT WAS COPIED FROM, INHERITING ALL THE EFFICIENCY WITHOUT HAVE TO RE-INVENT THE WHEEL.
-
- MODIFICATIONS MADE TO A REPORT DOES NOT AFFECT OR CHANGE THE STORED PROCEDURE REFERENCED BY THE REPORT IN ANY WAY, SHAPE, OR FORM.
-
- ANY NUMBER OF REPORTS CAN REFERENCE THE SAME STORED PROCEDURE
|
|
|
Term
| Define the terms Filtering and Parameters. |
|
Definition
FILTERING – ALLOWS THE RETRIEVAL OF SPECIFIC INFORMATION FROM THE DATABASE BY RETURNING ONLY THOSE RECORDS THAT MEETS SPECIFIC SET CRITERIA OR CONDITIONS AS OPPOSED TO RETRIEVING ALL RECORDS WITHOUT A FILTER
- FOR PREDEFINED REPORTS, FILTERING OCCURS ON THE SUBSET OF DATA RETURNED BY THE STORED PROCEDURE
PARAMETER - A FIELD THAT PROMPTS FOR ENTRY OF A VALUE WHEN DATA IS BEING RETRIEVED FOR A REPORT
- THE VALUES ENTERED ESTABLISH THE FILTER CRITERIA
- DEFINED IN THE STORED PROCEDURE
- INCLUDED IN THE DEFINITION IS THE PARAMETER’S TYPE – DATE, LOOKUP, AND/OR, OR NUMERIC
|
|
|
Term
| What are the different types of parameter fields defined in the stored procedure and which one(s) must have information supplied during the report registration process? |
|
Definition
| DATE, LOOKUP, AND/OR, AND NUMERIC. LOOKUP TYPE PARAMETERS MUST BE ASSOCIATED TO A LOOKUP NAME WHEN REGISTERING A REPORT IN REPORT VIEWER. |
|
|
Term
| You have decided to customize a core predefined report but have found that a field that you wish to add is not available in that report. What should you do next? |
|
Definition
| FIRST CHECK ITS CORRESPONDING GENERIC REPORT FOR THE FIELD AND IF FOUND, USE A COPY OF IT TO CREATE THE REPORT. YOU CAN ALWAYS CHECK ANOTHER OF THE GENERIC REPORTS IF NOT FOUND. |
|
|
Term
| The recommended approach for creating a custom report includes what steps? |
|
Definition
- DETERMINE WHICH PREDEFINED REPORT TO USE AS THE BASE REPORT AND MAKE A COPY OF IT
- MAKE THE DESIRED MODIFICATIONS OF THE COPIED REPORT IN CRYSTAL REPORTS
- REGISTER THE NEW CUSTOM REPORT IN REPORT VIEWER
|
|
|
Term
| What can you accomplish and see in Crystal Reports that you cannot accomplish or see in Report Viewer? |
|
Definition
| YOU CAN USE CRYSTAL REPORTS TO NOT ONLY DETERMINE WHAT FIELDS ARE AVAILABLE TO A REPORT BUT ALSO TO MAKE ENHANCEMENTS TO REPORTS. REPORT VIEWER DOES NOT ALLOW ENHANCEMENTS AND ONLY HAS ACCESS TO THOSE FIELDS CURRENTLY INCLUDED IN THE REPORT LAYOUT BUT NOT TO THE OTHER FIELDS AVAILABLE TO THE REPORT AS DEFINED BY THE STORED PROCEDURE. |
|
|
Term
| What are the two purposes of the Preview Tab in Crystal Reports? Other than the look and feel, how does the Preview tab differ from the Design tab? |
|
Definition
- MAKE ENHANCEMENTS/CHANGES TO THE REPORT’S DESIGN DIRECTLY ON THE PREVIEW TAB USING THE SAME FORMATTING CAPABILITIES, MENUS, TOOLBARS AND SECTIONS AS THE DESIGN TAB
- UNLIKE THE DESIGN TAB IN CRYSTAL REPORTS, THE PREVIEW TAB DOES NOT DISPLAY UNLESS REQUESTED AND MUST HAVE A CONNECTION TO THE ORACLE RETAIL PRO DATABASE BEFORE THE REPORT WILL SUCCESSFULLY DISPLAY.
- IN THE PREVIEW YOU ARE WORKING WITH THE ACTUAL DATA WHEREAS IN THE DESIGN TAB YOU ARE WORKING WITH MORE OF A VIRTUAL REPORT USING REPRESENTATIONS OF THE DATA
|
|
|
Term
| How often is data retrieved for the preview tab? |
|
Definition
| ONCE CRYSTAL RETRIEVES THE DATA FOR THE REPORT TO DISPLAY IT WHEN INITIALLY REQUESTING THE PREVIEW, IT CONTINUES TO USE THAT SAME DATA FOR THE PRINT PREVIEW UNLESS THE REFRESH OPTION IS SELECTED, WHICH WILL RETRIEVE CURRENT DATA FROM THE DATABASE. |
|
|
Term
| What required parameter(s) must be entered in order to successfully retrieve data and display the report? |
|
Definition
| THE SUBSIDIARY NUMBER IS A REQUIRED PARAMETER FOR ALL REPORTS. THE EXTENDED COST IS ALSO A REQUIRED PARAMETER IF IT IS INCLUDED IN THE PARAMETER LIST. IT IS NOT INCLUDED IN ALL REPORTS |
|
|
Term
| For a predefined report, what is responsible for retrieving data from the Retail Pro database? |
|
Definition
|
|
Term
| What commands in Crystal Reports can be used to identify the stored procedure that is referenced by a particular report? |
|
Definition
- SHOW SQL QUERY
- SET DATABASE LOCATION
|
|
|
Term
| How would you go about making a change to a core or generic predefined report? |
|
Definition
| MAKE A COPY OF THE .RPT FILE WITH A NEW FILE NAME AND MAKE THE DESIRED ENHANCEMENTS TO THE COPY IN CRYSTAL REPORTS. AFTER ALL CHANGES ARE MADE, REGISTER THE REPORT IN REPORT VIEWER. |
|
|
Term
| What is the general purpose/importance of the various Report Sections? |
|
Definition
| EACH REPORT SECTION HAS ITS OWN PRINTING CHARACTERISTICS AFFECTING WHEN AND HOW OFTEN DATA AND OTHER DIFFERENT REPORT OBJECTS GET EVALUATED AND PRINTED SO WHERE YOU WANT YOUR OBJECTS TO PRINT ON THE REPORT WILL HELP YOU DECIDE IN WHAT REPORT SECTION TO PLACE YOUR OBJECTS |
|
|
Term
| List a couple of ways that you can use the Page Header section. |
|
Definition
- USE IT TO DISPLAY FIELD TITLES OR COLUMN HEADINGS ABOVE THE FIELDS ON A REPORT
- USE IT TO DISPLAY A REPORT TITLE THAT IS TO APPEAR ON EACH NEW PAGE AND NOT JUST AT THE BEGINNING OF THE REPORT
|
|
|
Term
| What report section usually contains the bulk of the report and is printed once for every single record in the report? |
|
Definition
|
|
Term
| In what report section would you normally place grand totals for the report? |
|
Definition
|
|
Term
| In what report section would you normally display summary values such as subtotals? |
|
Definition
|
|
Term
| Objects that display data in different ways, such as in charts, pictures, or simple text entry are classified as what type of objects? |
|
Definition
|
|
Term
| What are the different categories of field types listed in the Field Explorer? |
|
Definition
- DATABASE FIELDS
- FORMULA FIELDS
- PARAMETER FIELDS
- RUNNING TOTALS FIELDS
- GROUP NAME FIELDS
- SPECIAL FIELDS
|
|
|
Term
| What tool in Crystal Reports can be used to determine what fields are available in each predefined report and to create your own custom reports by adding additional fields to the report’s design? |
|
Definition
|
|
Term
| What field type displays general information, such as Page Numbers, Print Date, and Report Title? For the most part, this field type contains built in functions that return a single value when executed. |
|
Definition
|
|
Term
| What is the purpose of object frames representing report and field objects? |
|
Definition
- THEY INDICATE THE EXACT POSITION THAT REPORT AND FIELD OBJECTS WILL DISPLAY/PRINT ON THE REPORT AND THE MAXIMUM WIDTH OF THE OBJECT/VALUE ON THE REPORT
- THE OBJECT FRAME ALSO DISPAYS THE FIELD NAME OR THE DATA REPRESENTATION (NUMERIC, STRING, ETC)
|
|
|
Term
| What action is recommended in order to determine which core predefined reports best fit the business needs? |
|
Definition
| AN INITIAL WALKTHROUGH OF THE RETAIL PRO CORE PREDEFINED REPORTS THAT CONSISTS OF VIEWING THEM IN REPORT VIEWER |
|
|
Term
| What primary aspects of a core report do you have to look at to determine if the changes you desire are possible for that particular report? |
|
Definition
ARE ALL THE DESIRED FIELDS AVAILABLE TO THE REPORT
IS THE REQUIRED DATA AVAILABLE TO THE REPORT |
|
|
Term
| When you desire to add additional fields, groups, subtotals, or a calculation to a copy of a predefined report, what is the first thing that you should do to determine if you can use that particular report as the base for your custom report? |
|
Definition
| CHECK TO SEE WHETHER ALL THE REQUIRED FIELDS ARE AVAILABLE TO THE PREDEFINED REPORT |
|
|
Term
| What is the advantage of using a core report as the base for a custom report instead of a generic report? Of using a generic report over a core report? |
|
Definition
- DATA IN THE CORE REPORT HAS ALREADY BEEN FORMATTED, GROUPED, SORTED, ETC TO DISPLAY DATA IN A SPECIFIC MANNER, WHICH MEANS THAT YOU DO NOT HAVE TO DO IT
- THE ADVANTAGE OF USING A GENERIC REPORT AS THE BASE FOR A CUSTOM REPORT INSTEAD OF A CORE REPORT IS THAT A LARGER NUMBER OF FIELDS ARE AVAILABLE FOR YOUR USE IN A GENERIC REPORT
|
|
|
Term
| When analyzing a core predefined report, what might Summarized information displaying in the detail section indicate? |
|
Definition
| THE STORED PROCEDURE MAY BE GROUPING THE DATA, AND IF SO, YOU WOULD NOT HAVE ACCESS TO THE DETAILED DATA WITHIN THE GROUP(S) |
|
|
Term
| When analyzing a core predefined report, what does very detailed information displaying in the detail section indicate? |
|
Definition
| THE STORED PROCEDURE IS NOT DOING THE GROUPING FIRST AND SENDING SUMMARIZED DATA TO THE REPORT. THE MORE DETAILED THE INFORMATION, THE MORE CONTROL YOU WILL HAVE OVER CREATING YOUR OWN GROUPS AND SUMMARIES |
|
|
Term
| What is the difference between the Undo/Redo menu buttons in Crystal Reports and in other applications like Word and Excel? |
|
Definition
| NOTHING. THE UNDO/REDO MENU BUTTONS IN CRYSTAL REPORTS WORK THE SAME WAY AS IN OTHER APPLICATION LIKE WORD AND EXCEL. YOU CAN UNDO/REDO ANY NUMBER OF CHANGES TO AN OBJECT, IN REVERSE ORDER, UNTIL YOUR REPORT IS IN THE DESIRED CONDITION. |
|
|
Term
| How do you select/deselect the different types of objects (formula field, chart, text, etc) in Crystal Reports so that you can format or change the font of the selected object? |
|
Definition
- REGARDLESS OF AN OBJECT TYPE, YOU SELECT AN OBJECT BY POSITIONING THE CURSOR INSIDE THE OBJECT FRAME AND CLICKING ONCE
- MOVING THE CURSOR AWAY FROM A SELECTED OBJECT FRAME AND CLICKING IN AN EMPTY PART OF THE WINDOW, DESELECTS THE OBJECT REGARDLESS OF ITS TYPE AND THE SIZING HANDLES DISAPPEAR.
|
|
|
Term
| Which object is the “main” or “control” object when aligning and resizing multiple selected objects? |
|
Definition
| THE OBJECT WITH THE SIZING HANDLES |
|
|
Term
| Are Report objects still available to the report after they are deleted from the report’s design or preview tabs? Are field objects still available after deleting them? |
|
Definition
- WHEN DELETING A REPORT OBJECT, SUCH AS TEXT, PICTURE, OR GRAPH, IT IS NO LONGER AVAILABLE TO THE REPORT. YOU WOULD HAVE TO RE-CREATE THE OBJECT AND SPECIFY ALL ITS ATTRIBUTES
- UNLIKE REPORT OBJECTS, FIELD OBJECTS DELETED FROM THE REPORT’S DESIGN OR PREVIEW TABS ARE STILL AVAILABLE TO THE REPORT AS THEY ARE NOT DELETED FROM THE REPOSITORY ACCESSIBLE FROM THE FIELD EXPLORER
|
|
|
Term
| By default how is a field heading added to the report’s design? Deleted from the design? |
|
Definition
- UNLESS CRYSTAL REPORTS IS CONFIGURED OTHERWISE, A FIELD HEADING IS AUTOMATICALLY ADDED TO THE REPORT’S DESIGN WHEN ITS CORRESPONDING FIELD IS ADDED
- BY DEFAULT, DELETING A FIELD OBJECT WILL ALSO DELETE ITS CORRESPONDING FIELD HEADING BUT SELECTING A FIELD HEADING AND PRESSING DELETE, DOES NOT DELETES ITS CORRESPONDING FIELD OBJECT
|
|
|
Term
| What will the SUPPRESS IF DUPLICATED option found on the Common tab of the Format Editor do, if checked? |
|
Definition
| THIS OPTION WILL CAUSE CRYSTAL REPORTS TO NOT DISPLAY/PRINT THE VALUE OF A FIELD FOR THE NEXT RECORD IF THE VALUE FOR THE NEXT RECORD IS THE SAME AS THE PREVIOUS RECORD |
|
|
Term
| What will the CAN GROW option found on the Common tab of the Format Editor do, if checked? |
|
Definition
| IT WILL CAUSE CRYSTAL REPORTS TO EXPAND THE OBJECT’S FRAME VERTICALLY WHEN THE DATA VALUE WITHIN THE OBJECT IS LARGER THAN THE FRAME |
|
|
Term
| What will the ALLOW FIELD CLIPPING option found in the Format Editor do, if unchecked? |
|
Definition
| IT WILL FILL NUMERIC/CURRENCY FIELD VALUES THAT EXCEED THE FIELD SIZE WITH NUMBER SIGNS (######) IN THE PREVIEW TAB, LETTING YOU KNOW IMMEDIATELY WHEN THE FIELD IS TOO SMALL |
|
|
Term
| What is the purpose of the Section Expert? What sections are listed in the Section Expert? What sections can be deleted using the Section Expert? |
|
Definition
- THE SECTION EXPERT ALLOWS YOU TO MAKE FORMATTING CHANGES THAT AFFECT AN ENTIRE SECTION OF YOUR REPORT
- IT LISTS ALL OF THE SECTIONS IN THE ACTIVE REPORT REGARDLESS OF WHETHER OR NOT THEY ACTUALLY DISPLAY/PRINT ON THE REPORT. THE OPTIONS AVAILABLE IN THE SECTION EXPERT MAY ACT A LITTLE DIFFERENTLY DEPENDING ON THE SECTION FOR WHICH THEY ARE BEING SET
- YOU CAN ONLY DELETE SECTIONS THAT HAVE BEEN ADDED TO THE 5 ORIGINATING SECTIONS. YOU CANNOT DELETE THE FIVE ORIGINAL SECTIONS, BUT YOU CAN HIDE THEM SO THEY DO NOT DISPLAY/PRINT
|
|
|
Term
| How would you hide an entire section so that it would not print/display and would also not allow you to reveal the section contents on the Preview tab? |
|
Definition
| SELECT “SUPPRESS (NO DRILL-DOWN)” FROM THE SECTION EXPERT |
|
|
Term
| How do you insert the different types of field objects into the report’s layout? |
|
Definition
| ALL FIELD OBJECTS ARE INSERTED INTO THE REPORT’S LAYOUT FROM THE FIELD EXPLORER IN THE SAME WAY, REGARDLESS OF THEIR TYPE |
|
|
Term
| What are the two criteria you must specify when setting up a condition for a chart in the Chart Expert? |
|
Definition
| WHEN THE CHART IS TO PLOT THE POINTS, WHICH ON A STANDARD VERTICAL CHART IS THE X-AXIS; AND 2. THE VALUE THE CHART IS TO PLOT, WHICH ON A STANDARD VERTICAL CHART IS THE Y-AXIS |
|
|
Term
| What commands/options will allow you to set filter criteria in Crystal Reports that will automatically filter the report every time the report is run? |
|
Definition
- SELECT EXPERT
- SELECTION FORMULAS
|
|
|
Term
| What are the benefit(s) of setting filter criteria in Crystal Reports? |
|
Definition
- THE REPORT WILL RUN WITH THE ESTABLISHED FILTER CRITERIA WITHOUT HAVING TO ENTER PARAMETER VALUES
- GIVES YOU THE ABILITY TO SCHEDULE A REPORT SO THAT IT RUNS AUTOMATICALLY WITH THE DESIRED FILTERS ALREADY SET
|
|
|
Term
|
Definition
| PLACING DATA IN SOME KIND OF ORDER TO HELP IN FINDING AND EVALUATING DATA |
|
|
Term
| What is one of the primary purposes for breaking data into groups in Crystal Reports? |
|
Definition
| TO BE ABLE TO RUN CALCULATIONS SUCH AS SUBTOTALS ON EACH GROUP |
|
|
Term
| What tool will help to determine where the data in a report is initially being sorted and can be used to actually change the current sort order? |
|
Definition
|
|
Term
| List the various sources that could be responsible for the order that records display on a report |
|
Definition
- THE ORDER THE RECORDS WERE INSERTED IN THE RETAIL PRO DATABASE
- THE SORT ORDER AS DEFINED BYCRYSTALREPORTS
- THE ORDER THE DATA WAS RECEIVED FROM THE STORED PROCEDURE REFERENCED BY THE REPORT
|
|
|
Term
| What feature is used to discover how existing groups are created, to change options for existing groups or to create new groups? |
|
Definition
|
|
Term
| Why does a field you are creating a group on control the printing of certain information on the report? |
|
Definition
| BECAUSE WHEN THE VALUE OF A GROUPED FIELD CHANGES, ANY SUMMARIZED DATA WITHIN THE GROUP FOOTER FOR THAT GROUP WILL PRINT |
|
|
Term
| What tool/feature can be used to identify the top or bottom groups or percentages in a report and/or to create your own top/bottom groups? |
|
Definition
|
|
Term
| What are the two things you must include in a report before you can use the Group Sort Expert for a particular field? |
|
Definition
- THE DATA MUST FIRST BE GROUPED ON THE FIELD THAT YOU ARE EVALUATING AS THE TOP OR BOTTOM GROUP
- THE GROUP MUST BE SUBTOTALED OR SUMMARIZED ON THE FIELD USED TO DETERMINE THE GREATEST OR LEAST VALUE
|
|
|
Term
| Certain core Retail Pro predefined reports display only records that fall within defined top/bottom limits. What range of records do these reports actually have access to for customization purposes? |
|
Definition
| ALL CORE PREDEFINED REPORTS INCLUDING TOP/BOTTOM REPORTS ONLY HAVE ACCESS TO THE SET NUMBER OF RECORDS RETRIEVED BY THE STORED PROCEDURE. SO FOR MOST IF NOT ALL TOP/BOTTOM CORE REPORTS, YOU WILL ONLY HAVE ACCESS TO RECORDS THAT FALL WITHIN THE DEFINED TOP OR BOTTOM LIMITS |
|
|
Term
| What is the difference between Running Total fields and Summary Fields? |
|
Definition
| RUNNING TOTAL FIELDS ALLOW MORE CONTROL OVER HOW THE TOTAL IS CALCULATED (BY RECORD, BY FIELD, BY GROUP, CONDITIONALLY) WHEN IT IS RESET, AND WHERE YOU CAN INSERT IT |
|
|
Term
| When is a Running Total field calculated and what impact/significance does that have on the report? |
|
Definition
| A RUNNING TOTAL FIELD IS CALCULATED WHILE PRINTING RECORDS SO WHERE YOU PLACE THE RUNNING TOTAL ON THE REPORT’S DESIGN WILL AFFECT THE VALUE THAT DISPLAYS |
|
|
Term
| What are the three pieces of information that you must supply when creating/inserting a summary field? |
|
Definition
- THE FIELD TO SUMMARIZE
- THE SUMMARY OPERATION
- THE SUMMARY LOCATON
|
|
|
Term
| What are the three different sections that must have information provided when creating a Running Total? |
|
Definition
- SUMMARY SECTION
- EVALUATE SECTION
- RESET SECTION
|
|
|
Term
| What are the two critical parts that all Crystal Reports formulas contain? |
|
Definition
- THE COMPONENTS
- THE SYNTAX
|
|
|
Term
| When creating formulas in Crystal Reports, you can use one of two different syntax options. What are these two options? |
|
Definition
|
|
Term
| What are the steps involved in registering a report in Report Viewer? |
|
Definition
- SUPPLY THE REPORT REGISTRATION INFORMATION
- MAP ALL LOOKUP PARAMETERS TO THE APPROPRIATE LOOKUP NAME
|
|
|
Term
| At what sites/locations must a report be individually registered? |
|
Definition
| A REPORT HAS TO BE REGISTERED INDIVIDUALLY IN EACH INSTALLATION OF REPORT VIEWER THAT WILL BE ACCESSING THE REPORT |
|
|
Term
| When registering a report in Report viewer, where is the report information recorded? |
|
Definition
- REPORT VIEWER
- RETAIL PRO DATABASE
|
|
|
Term
| When running a report in Report Viewer, where does Report Viewer get the instructions for what fields to display and how to display them? |
|
Definition
| REPORT VIEWER runs the .rpt file and formats the report as instructed in that file |
|
|
Term
| When is the .rpt file on the local computer compared to the version in the database? |
|
Definition
WHEN REGISTERING THE REPORT IN REPORT VIEWER
EVERY TIME A REPORT IS RUN IN REPORT VIEWER |
|
|
Term
| What is the only “rule” when mapping lookup parameters that if not followed will generate an error message when you try to complete the registration? |
|
Definition
| EACH LOOKUP PARAMETER MUST HAVE AN ASSIGNED LOOKUP NAME AND CANNOT BE LEFT AT "NONE" |
|
|
Term
| What are the two tools/executables that have been developed to assist in registering and distributing reports? Where must they reside? |
|
Definition
- RUNREPORTSCRIPT.EXE
- REPORTREGESTRACTOR.EXE
- THEY CAN RESIDE IN ANY DIRECTORY; HOWEVER, THE RECOMMENDED DIRECTORY IS THE RETAIL PRO 9/REPORTS DIRECTORY.
|
|
|
Term
| What executable will create a registration script containing instructions for registering a report in Report Viewer? What naming convention is used for the generated script file and where will it reside? |
|
Definition
- REPORTREGESTRACTOR.EXE
- THE GENERATED REGISTRATION SCRIPT WILL HAVE THE ORIGINAL REPORT’S NAME FOLLOWED BY A .ENCRYPT EXTENSION (I.E. NAME.RPT.ENCRYPT) AND WILL RESIDE IN THE SCRIPTS\”REPORT GROUP” DIRECTORY, WHERE THE VALUE OF "REPORT GROUP" IS SELECTED FROM A DROP-DOWN LIST DURING RUN-TIME
|
|
|
Term
| When the tool that will create a report registration script is run, what report will be used to create the registration script? |
|
Definition
| THE LAST REPORT THAT WAS MANUALLY REGISTERED IN REPORT VIEWER |
|
|
Term
| Assuming that a remote location has none of the necessary files for automatically registering a report in Report Viewer, what files must be moved to this remote location to accomplish this? Can you use ECM’s Movelist to move these files? |
|
Definition
- THE GENERATED REGISTRATION SCRIPT (.ENCRYPT)
- ORIGINAL REPORT FILE (.RPT)
- RUNREPORTSCRIPT.EXE
- YOU CAN USE ECM’S MOVELIST TO MOVE THE NECESSARY FILES OR OTHER METHODS, SUCH AS EMAILING ATTACHMENTS
|
|
|
Term
| What methods can you use to execute the tool that will run the registration script and automatically register the specified report in Report Viewer? |
|
Definition
- MANUALLY BY CLICKING ON THE EXECUTABLES
- FROM A COMMAND LINE PROMPT WITH THE APPROPRIATE PARAMETERS
- FROM WITHIN A BATCH FILE
- AS A SCHEDULED TASK IN A SCHEDULER PROGRAM
|
|
|
