ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 


 

Company >> Jaguar >> Jaguar Questions
 
 Jaguar technical test questions  Jaguar Technical Test Questions (1)
 
Back to Questions Page
Question   HOW TO MAKE A MATRIX REPORT MANUALLY WITH SINGLE GROUPT QUERY OR MULTIPLE GROUP QUERY ? Rank Answer Posted By  
 Interview Question Submitted By :: Syed_khurram
I also faced this Question!!   © ALL Interview .com
Answer
Step 1: Create a group with query in Data Model, remember 
this query should have atleast three columns for Row, 
Column and Cell value. and Four if you want to create Group 
Matrix Report.

Step 2: Drag Column you want to act as Group Header from 
Group, then drag Row Value and then Column Value.

Step 3: In Data Model window you will find icon for Cross 
Product in tool box. click on that, then Drag the Mouse 
pointer keeping the left click pressed over the group of 
Row and Column values selected by you in step 2.

Step 4: In Layout Model window, Create Repeating frame then 
create one more repeating frame over the previous one but 
at this time please change the property of repeating frame 
as PRINT DIRECTION : ACROSS. Then select both the frames at 
once and then go to Menu Insert>>Layout Matrix, by doing 
this you merge two frames, now in the intersection area of 
this two frames create one more repeating frame.

Step 5: In the merged frame the one which is Print 
Direction down will display the rows, one with print 
direction across will display the columns and intersection 
will display the cell values. Accordingly assign the source 
for all three repeating frames and create fields in those 
frames and give the desire sources.

Step 6: Run the report
 
0 Neelkanth Jadhav
 
 
 
Back to Questions Page
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com