MB3-210 - Microsoft Business Solutions - Great Plains 8.0 Report Writer
Go back to Microsoft
Which of the following types of relationships can be deleted using the Table Relationships window?
Any user defined table relationship
What is the size limit on a picture file you want to place on a report in Report Writer?
Which is a unique benefit to using Report Writer to create a report rather than another product, such as Crystal Reports?
An original report can be modified to get the required result.
Which button on the Report window creates a primary copy of a report?
When should the Variable Characters per Inch option be checked on the Report Definition window?
A text report needs to be printed using multiple fonts.
Which of the following will allow you to select multiple fields on a report layout window at the same time?
Holding down the Shift key and selecting additional fields
When creating a user-defined sort, what must you do to sort a field in descending order (45, 44, 43)?
Mark the Descending checkbox in the Sorting Definition window.
When inserting multiple sorts, what can be done to insert the sorts in the correct order?
Insert the sorts in reverse order
After inserting the first sort, highlight it and then insert the next sort
What function and operator are used to remove extra spacing between fields and then join the fields together on a report? (i.e. city, state, zip)
Calculated fields placed in the footer section are automatically assigned what field type?
What is the main function of additional headers and footers?
To group related records together on a report.
How many primary copies of an original report can be made in Report Writer?
What is the function of the A icon on the toolbox?
It allows you to place a text field on the report.
Which of the following statements is true about expressions for calculated fields in Report Writer?
Values must be placed in both the True and False case fields of a conditional expression.
What table stores original reports?
What options do you have for each field when creating a user-defined sort?
The sort can ignore case (A is same as a).
The sort can be set to sort in ascending or descending order.
The sort can incorporate any field from the tables linked to the report.
What must be true in order to create a table relationship?
The tables must have a "common field".
When testing a new report, which of the following processes can help speed up the printing time?
Use a "key" sort rather than a user defined sort when testing the report
Don add a picture/graphic until you have fully tested the report Don? add a picture/graphic until you have fully tested the report
Set Max Records to 50 to limit the amount of data printed while testing
What type of file does the customization process create when you export a report?
Which of the following buttons will create a secondary copy of a report?
How can you make sure that you are modifying the correct report in Report Writer?
Use the title on the output bar for the report.
Use the Ctrl + F9 keys to "transfer" to Report Writer and open the report layout automatically.
The layout window in Report Writer is divided into very small graphic units called?
What is the maximum number of tables that can be linked for a report?
What is required if you want to change the color and fonts of fields on a report?
The report needs to be a graphical report.
Which report section will only appear at the bottom of the last page of a report?
Which of the following is an advantage of creating a "1 to 1" relationship rather than a "1 to Many" relationship?
Most linking restrictions only apply to 1 to Many relationships
Which of the following report types will allow you to change the Using Key field on the Report Definition window?
If you want to save a report to a file, which of the following file formats are available?
Which of the following expression types are supported for creating user defined fields with Report Writer?
When creating a restriction for a report, which of the following can be included in the expression?
Which of the following reason explains why a report cannot be printed from Report Writer?
The report is pulling data from a temporary table.
What Report Writer function is associated with the Using Key field?
Which report type allow you to change the main table on the report?
Which text report options should be checked on the Report Definition window if you want to use more than one font on a report?
Which of the following can be done in Report Writer?
Report settings such as calculated fields, can be printed to paper for review.
Page Orientation settings can be saved when the report layout is saved.
Restrictions can be defined to limit what data will print on a report.
What is the easiest way to place your company name field on a report so that it automatically defaults to the company you are logged into?
Use the Global field, Company Name
When linking tables for a report in the related tables window, what does an asterisk next to a table denote?
The table has a "one to many" relationship with the selected table.
Which of the following sections will appear as defaults on a new report?
When the divider tool is placed in the body on a report layout, what restriction is made on the placement of new report fields?
Fields cannot be added to the right of the divider tool.
Which report type will not require you to define a report name?
If you use the arrange tools and don like the results, what needs to be done to return the fields to their prior positions?
Close the layout window and don save the changes
The Table Descriptions window contains which of the following table names?
Which of the following is a unique benefit of using a text report?
The report prints faster.
Which resource description window will allow you to see what fields make up a "key"?
Which table stores the locations of the dictionary files, including the dictionaries used by Report Writer?
How many secondary copies of an original report can be created in Report Writer?
When is the Reports.dic file created?
After Report Writer is accessed for the first time
When planning a report, if a similar report does not exist, what type of report should be created in Report Writer?
How many consecutive "1 to Many" links can be made when creating a report?
What must you do if you want a user to have access to a secondary copy of a report you have just created?
Nothing, access is automatically granted