최신SAP Certified Application Associate - Crystal Reports 2008 - C_BOCR_08무료샘플문제
문제1
Which procedure should you use to determine whether Crystal Reports is the source of incorrect report results?
Which procedure should you use to determine whether Crystal Reports is the source of incorrect report results?
정답: D
문제2
Which three statements describe characteristics of a subreport? (Choose three.)
Which three statements describe characteristics of a subreport? (Choose three.)
정답: B,C,D
문제3
You use the following conditional formatting formula to display a background color of yellow when the condition is met: IF {Table.Field Name} > 5000 THEN Yellow You want the background color to be white when the condition is not met. Which two lines can you add to the conditional formatting formula to achieve the requirement? (Choose two.)
You use the following conditional formatting formula to display a background color of yellow when the condition is met: IF {Table.Field Name} > 5000 THEN Yellow You want the background color to be white when the condition is not met. Which two lines can you add to the conditional formatting formula to achieve the requirement? (Choose two.)
정답: A,C
문제4
Which two evaluation time functions can you use in a formula which contains a manual running total? (Choose two.)
Which two evaluation time functions can you use in a formula which contains a manual running total? (Choose two.)
정답: A,D
문제5
Which formula returns the sum of Last Year's Sales by Country?
Which formula returns the sum of Last Year's Sales by Country?
정답: D
문제6
What is the default file version when you save a report to crystalreports.com?
What is the default file version when you save a report to crystalreports.com?
정답: B
설명: (KoreaDumps 회원만 볼 수 있음)
문제7
Where is the transform information stored?
Where is the transform information stored?
정답: C
문제8
Which special field can you use to display the total number of pages in a report on the first page of the report?
Which special field can you use to display the total number of pages in a report on the first page of the report?
정답: B
문제9
You create the following custom function to convert Celsius to Fahrenheit or vice versa depending on an argument passed to the function: Function(): Global StringVar CurrentTempType; Global NumberVar DegreeAmount; If CurrentTempType = "F" then ((DegreeAmount - 32) * 0.55) else if CurrentTempType = "C" then ((Degreeamount * 1.8) + 32); EndIf: Which change must you make to the code to successfully save the function?
You create the following custom function to convert Celsius to Fahrenheit or vice versa depending on an argument passed to the function: Function(): Global StringVar CurrentTempType; Global NumberVar DegreeAmount; If CurrentTempType = "F" then ((DegreeAmount - 32) * 0.55) else if CurrentTempType = "C" then ((Degreeamount * 1.8) + 32); EndIf: Which change must you make to the code to successfully save the function?
정답: C
문제10
Which two methods can you use to add tables to an existing report? (Choose two.)
Which two methods can you use to add tables to an existing report? (Choose two.)
정답: A,C
문제11
What are three uses of a linked subreport? (Choose three.)
What are three uses of a linked subreport? (Choose three.)
정답: B,C,D
문제12
You want to calculate summaries on a different dataset than the main report. The summaries must be calculated before the main report data is returned. These summaries must display once in the main report. Which task should you perform to create the report?
You want to calculate summaries on a different dataset than the main report. The summaries must be calculated before the main report data is returned. These summaries must display once in the main report. Which task should you perform to create the report?
정답: B
문제13
You insert a subreport into a sales report and link it at the country group level. Which two items are created when a subreport is linked to a main report? (Choose two.)
You insert a subreport into a sales report and link it at the country group level. Which two items are created when a subreport is linked to a main report? (Choose two.)
정답: C,D
문제14
You create the following formula in a new Crystal report to return random records based on the user's parameter input: WhilePrintingRecords; NumberVar array Rnd_Array; Redim Rnd_Array[{?Records Returned}]; NumberVar Seed; numbervar arryindex1; Numbervar arryindex2; While arryindex1 := 1 To {?Records Returned} Do( Seed := Int (Count ({Orders.Order ID})*RND()); if not(Seed in Rnd_Array) and arryindex2 < {?Records Returned} then ( arryindex2 := arryindex2 + 1; Rnd_Array[arryindex2] := Seed ) );
Rnd_Array[1]; You receive an error when saving the formula. Which loop type should you replace the existing loop with to resolve the error?
You create the following formula in a new Crystal report to return random records based on the user's parameter input: WhilePrintingRecords; NumberVar array Rnd_Array; Redim Rnd_Array[{?Records Returned}]; NumberVar Seed; numbervar arryindex1; Numbervar arryindex2; While arryindex1 := 1 To {?Records Returned} Do( Seed := Int (Count ({Orders.Order ID})*RND()); if not(Seed in Rnd_Array) and arryindex2 < {?Records Returned} then ( arryindex2 := arryindex2 + 1; Rnd_Array[arryindex2] := Seed ) );
Rnd_Array[1]; You receive an error when saving the formula. Which loop type should you replace the existing loop with to resolve the error?
정답: D
문제15
Which two pieces of information must you provide when you create a new connection to a Microsoft SQL Server database using an OLE DB connection in the Database Expert? (Choose two.)
Which two pieces of information must you provide when you create a new connection to a Microsoft SQL Server database using an OLE DB connection in the Database Expert? (Choose two.)
정답: A,C