单选题The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）A Report wizard. B Layout model. C Data model. D Life previewer.

题目
单选题
The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）
A

Report wizard. 

B

Layout model. 

C

Data model. 

D

Life previewer.

相似考题

1.The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）A、Report wizard. B、Layout model. C、Data model. D、Life previewer.

2. Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）A、 use the @function @decimal in the column formula in the view B、 select decimal on the numbers tab in the view properties box C、 select decimal on the numbers tab in the column properties boxD、 use the @function @decimal to format the value in the field on the form that will display in the view 

3.The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）A、Programme units. B、PL/SQL libraries. C、Database object. D、Built in packages.

4. You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）A、Double click the dept column in the group to alter the property palette and change the break out order value. B、Double click the dept column in the group to open the property palette and change the set break order value. C、Double click the g_dept group object to change the break order. D、Click the dept column in the group to change the break order.

更多“单选题The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）A Report wizard. B Layout model. C Data model. D Life previewer.”相关问题

  • 第1题：

    36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）

    • A、Rows 
    • B、Totals 
    • C、Columns 
    • D、Cells 
    • E、Data

    正确答案:B

  • 第2题：

    The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）

    • A、In the template used. 
    • B、In the data model. 
    • C、In the life previewer. 
    • D、In the field property palette.

    正确答案:C

  • 第3题：

    You need to provide ad hoc reporting capabilities to fulfill business requirements. What should you do?（）

    • A、Create a SQL Server Reporting Services （SSRS） report. Enable customers to modify the report by using Report Builder.
    • B、Create an ASP.NET application that will enable customers to view and modify reports by calling the SQL Server Reporting Services （SSRS） API.
    • C、Create an ASP.NET application that will enable customers to view and modify reports by using a SQL Server Reporting Services （SSRS） ActiveX control.
    • D、Create a SQL Server Reporting Services （SSRS） Report Model. Enable customers to modify reports based on the model by using Report Builder.

    正确答案:D

  • 第4题：

    You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory， but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources.  What should you do？（）

    • A、Design a report for Susan that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then， design a report for Joe that displays the detailed sales data.
    • B、Design two reports for Susan. One report includes the territory information， and one report includes the detailed sales data. Then， design a report for Joe that displays the detailed sales data for his territories.
    • C、Design a report for Susan that includes the territory information. Then， design a report for Joe that includes detailed sales data for his territories. Finally， configure Susans report so that it includes the data in Joes report.
    • D、Design a parameterized report for Susan that includes all territory information. Then， design a linked report for Joe that links to Susans report.

    正确答案:D

  • 第5题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

    • A、 Use a subreport.
    • B、 Use a bookmark link.
    • C、 Use the drilldown functionality.
    • D、 Use a drillthrough report link.

    正确答案:D

  • 第6题：

    单选题
    You created a tabular report for the sales department to display each customer and the sales person assign to the customer. The data is sorted by customer using the order by clause in this query. This is department manager asks you to alter the report so that data is sorted by sales person rather than by customer. What is the best way to make the needed change?（）
    A

    Recreate the query and default the layout. 

    B

    Alter the query, default the layout and redo the boiler plates. 

    C

    Query and manually change the layout to save the boiler plate. 

    D

    Alter the query and make no further change.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）
    A

    Removing column from the available list in the report wizard. 

    B

    Removing the column from the displayed list in the report wizard. 

    C

    Changing the display width of a column in the report wizard. 

    D

    Adding a column to both the available list and displayed list in the report wizard. 

    E

    Removing a column in the live previewer. 


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）
    A

    Report wizard. 

    B

    Layout model. 

    C

    Data model. 

    D

    Life previewer.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）
    A

    Specify the break order on the gemp group Property palette. 

    B

    Specify a break order on the dept_name and job columns property palettes. 

    C

    Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 

    D

    Change the position of the dept_name and the job columns within the gemp group.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）
    A

    Double click the dept column in the group to alter the property palette and change the break out order value. 

    B

    Double click the dept column in the group to open the property palette and change the set break order value. 

    C

    Double click the g_dept group object to change the break order. 

    D

    Click the dept column in the group to change the break order.


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    36 You are creating a report wizard to create a matrix report. The query build, you select the patient_name column from the patient table; the doctor_name from the doctors table; and the doctor_ID, patient_ID and ID columns from the procedure table. In the report wizard you select patient_name as the row value, doctor_ID as the column values and the count as the cell values. You need to add a total for each doctors column. In the wizard report which tab will allow you to create the summary column?（）
    A

    Rows 

    B

    Totals 

    C

    Columns 

    D

    Cells 

    E

    Data


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）
    A

     Use a subreport.

    B

     Use a bookmark link.

    C

     Use the drilldown functionality.

    D

     Use a drillthrough report link.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）

    • A、Specify the break order on the gemp group Property palette. 
    • B、Specify a break order on the dept_name and job columns property palettes. 
    • C、Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
    • D、Change the position of the dept_name and the job columns within the gemp group.

    正确答案:C

  • 第14题：

    You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）

    • A、Removing column from the available list in the report wizard. 
    • B、Removing the column from the displayed list in the report wizard. 
    • C、Changing the display width of a column in the report wizard. 
    • D、Adding a column to both the available list and displayed list in the report wizard. 
    • E、Removing a column in the live previewer. 

    正确答案:D

  • 第15题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a user in the Windows SalesManagers group， and he is called Simon. A Reporting Services report is required by Simon to have annual sales information displayed by territory. There is another user in the Windows Sales group， and he is called Jack. He is responsible to report to Simon. A report is required by Jack， and the report is limited to his sales territory， but the same detailed sales data is still displayed， and the detailed sales data is on Simon’s report. A secure solution should be designed to meet the requirements of the users listed above， and the least amount of server resources should be utilized.  Which action should be performed？（）

    • A、First， all territory information should be contained by a parameterized report which is designed for Simon. Second， a linked report that links to Simons report should be designed for Jack.
    • B、First， two data regions should be contained by a report which is designed for Simon. Second， one data region should be utilized for summary sales data. Third， the other data region should be utilized for the detailed sales data for each sales representative. Four， a report that displays the detailed sales data should be designed for Jack.
    • C、First， two reports should be designed for Simon. Second， the territory information should be contained by one， and the detailed sales data should be contained by another. At last， a report that displays the detailed sales data for Jack’s territories should be designed for Jack.
    • D、First， the territory information should be contained by a report which is designed for Simon. Second， a report which detailed sales data for Jack’s territories is contained should be designed for Jack. Third， Simon’s report should be set to have the data in Jacks report contained.

    正确答案:A

  • 第16题：

    You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）

    • A、 List
    • B、 Table
    • C、 Matrix
    • D、 Subreport

    正确答案:D

  • 第17题：

    单选题
    Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）
    A

     use the @function @decimal in the column formula in the view 

    B

     select decimal on the numbers tab in the view properties box 

    C

     select decimal on the numbers tab in the column properties box

    D

     use the @function @decimal to format the value in the field on the form that will display in the view 


    正确答案： C
    解析： 暂无解析

  • 第18题：

    多选题
    You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?（）
    A

    RUN_PRODUCT

    B

    SET_REPORT_OBJECT_PROPERTY

    C

    RUN_REPORT_OBJECT

    D

    FIND_REPORT_OBJECT

    E

    REPORT_OBJECT_STATUS

    F

    COPY_REPORT_OBJECT_OUTPUT


    正确答案： B,F
    解析： 暂无解析

  • 第19题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a user in the Windows SalesManagers group， and he is called Simon. A Reporting Services report is required by Simon to have annual sales information displayed by territory. There is another user in the Windows Sales group， and he is called Jack. He is responsible to report to Simon. A report is required by Jack， and the report is limited to his sales territory， but the same detailed sales data is still displayed， and the detailed sales data is on Simon’s report. A secure solution should be designed to meet the requirements of the users listed above， and the least amount of server resources should be utilized.  Which action should be performed？（）
    A

    First， all territory information should be contained by a parameterized report which is designed for Simon. Second， a linked report that links to Simons report should be designed for Jack.

    B

    First， two data regions should be contained by a report which is designed for Simon. Second， one data region should be utilized for summary sales data. Third， the other data region should be utilized for the detailed sales data for each sales representative. Four， a report that displays the detailed sales data should be designed for Jack.

    C

    First， two reports should be designed for Simon. Second， the territory information should be contained by one， and the detailed sales data should be contained by another. At last， a report that displays the detailed sales data for Jack’s territories should be designed for Jack.

    D

    First， the territory information should be contained by a report which is designed for Simon. Second， a report which detailed sales data for Jack’s territories is contained should be designed for Jack. Third， Simon’s report should be set to have the data in Jacks report contained.


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    You are a database administrator for your company. A user named Susan belongs to the Windows SalesManagers group. Susan needs a Reporting Services report to display annual sales information by territory. A user named Joe reports to Susan and belongs to the Windows Sales group. He needs a report that is limited to his sales territory， but still displays the same detailed sales data that is on Susan’s report. You need to design a secure solution that meets the reporting needs of the users and that consumes the minimal amount of server resources.  What should you do？（）
    A

    Design a report for Susan that includes two data regions. One data region is used for summary sales data. The other data region is used for the detailed sales data for each sales representative. Then， design a report for Joe that displays the detailed sales data.

    B

    Design two reports for Susan. One report includes the territory information， and one report includes the detailed sales data. Then， design a report for Joe that displays the detailed sales data for his territories.

    C

    Design a report for Susan that includes the territory information. Then， design a report for Joe that includes detailed sales data for his territories. Finally， configure Susans report so that it includes the data in Joes report.

    D

    Design a parameterized report for Susan that includes all territory information. Then， design a linked report for Joe that links to Susans report.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    You created a report from the human resources department based on all the columns in the EMP table. After viewing the report users requested that the cmp_ID columns peers first in the output. How would you change the position of the column?（）
    A

    After the query. 

    B

    Enter the report and change the column's position in the field tab. 

    C

    Alter the column's position in the object navigator. 

    D

    Enter the report wizard and change the column's position in the data tab. 

    E

    Alter the column's position within its group and change the layout. 


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）
    A

    Programme units. 

    B

    PL/SQL libraries. 

    C

    Database object. 

    D

    Built in packages.


    正确答案： C
    解析： 暂无解析

  • 第23题：

    单选题
    You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）
    A

     List

    B

     Table

    C

     Matrix

    D

     Subreport


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    The order entry department requested a report to display the average time to enter an order from each order entry clerk sorted by supervisor with a group average after viewing the report users requested to bold the value for each supervisors group average. Where would you make this change?（）
    A

    In the template used. 

    B

    In the data model. 

    C

    In the life previewer. 

    D

    In the field property palette.


    正确答案： D
    解析： 暂无解析

相关内容