In Report Studio, an author merges Query1 and Query2 into one result set (Query3) using a Union set operator. Query1 contains two data items: Order method and Revenue. Query2 also contains two data items: Product line and Quantity sold. The author wants to display the data from Query3 in a list report. How can the author ensure that all the order method results appear together and all product line results appear together in the list report?
A. The author must add a sort key data item directly to Query3.
B. The author must sort the Order method data item in Query1 and the Product line data item in Query2.
C. The author must sort the data item in the Query3 that retrieves both Order method and Product line data.
D. The author must add a sort key data item to Query1 and to Query2, and then add this sort key data item to Query3.
|
Download Printable PDF. VALID exam to help you PASS. |
 |