找考题网-背景图
单项选择题

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

热门试题

单项选择题YouarecreatingtheDEPT_SALdatablockfromthePAYHISTform.UsersshouldbeabletoenteravaliddepartmentIDnumber,whichwillthendisplaytheemployeesalaryinformationforthatdepartment.Thisdatablockcouldpotentiallyretrievealargenumberofrecords.Sinceuserswillprobablyonlyviewasmallnumberoftheserecords,only10recordsshouldbefetchedatonetime.Howwouldyoucreatethedatablock?()

A.Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
B.Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
C.Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
D.Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
E.Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.