Using the report wizard you create a tabular report to displ

题目
单选题
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
解析: 暂无解析
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Using the reports server how would you force the orders report in the orders entry application to run every six hours?()

  • A、Schedule the report's execution in the queue manager. 
  • B、Schedule the reports execution using the R30RQM command line with scheduled parameter. 
  • C、Create a trigger in the application to execute the report every six hours. 
  • D、You cannot schedule a reports execution.

正确答案:A

第2题:

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

第3题:

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

第4题:

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

第5题:

You have a server that runs Windows Server 2003 Service Pack 2 (SP2). A server application creates report files. The application saves the report files in a folder named Report. A service account is listed as the owner of all report files. You need to assign ownership of the report files to a user in a department named Audit. You must achieve this goal by using the minimum amount of administrative effort. What should you do? ()

  • A、Rewrite the application.
  • B、Create a scheduled task to run Attrib.exe.
  • C、Create a scheduled task to run Icacls.exe.
  • D、Use the Advanced Security settings to change the owner of each file.

正确答案:C

第6题:

You create a tabular employee report and are concerned about readability because the employee records are very close together. What is the best way to increase the amount of white space between the records?()

  • A、In the layout model increase the size of the employee record fields. 
  • B、In the report wizard increase the display width values of the employee record fields. 
  • C、In the property palette increase the size of the repeating frame surrounding the employee records. 
  • D、In the life previewer, high light a field, click on the parent frame icon and make the frame bigger verticall.

正确答案:D

第7题:

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do?()

  • A、 Create an SSRS report and include the required page header in the report. Use the report as a template for all the reports.
  • B、 Create an SSRS report and include the required page header in the report. Create a subreport that refers to the report. Include the subreport to all the reports.
  • C、 Create a SSRS report and include the required page header in the report. Copy the report definition to an XML file.Add the XML file as a data source for all the reports.
  • D、 Create a SSRS report and include the required page header in the report. Create a class library that includes the report.Add the class library as an assembly reference for all the reports.

正确答案:A

第8题:

You are creating a Windows Forms application by using the .Net Framework 3.5.You create an instance of a Backgroundworker component named backgroundWorker1 to process operations that take a long time.You discover that when the application attempts to report the progress,you receive a System.InvalidOperationException exception when executing  the backgroundWorker1.ReportProgress method.You need to configure the BackgroundWorker component appropriately to prevent the application from generating exceptions.What should yo do?()

  • A、Set the Result property of the DoWorkEventArgs instance to True before you attempt to report the progress.
  • B、Set the CancellationPending property of backgroundWorker1 to True before you attempt to report the background process
  • C、Set the WorkerReportsProgress property of backgroundWorker1 to True before you attempt to report the background process.
  • D、Report the progress of the background process in the backgroundWorker1_ProgressChanged event.

正确答案:C

第9题:

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

第10题:

You need to provide analyst reporting capabilities that fulfill the business requirements. What should you do?()

  • A、Add a Report Viewer control to APP3.
  • B、Add an Internet Explorer ActiveX control to APP3. Set the controls URL to the A Datum Corporation Report Manager.
  • C、Create a hyperlink in APP3 that references the Report Manager.
  • D、Create a proxy class to the Report Server Web service.

正确答案:A

更多相关问题