Page Comparison

A HOLD file is valuable when you want to do the following:

...

1. Navigate to your saved report and right-click.  

2. From the right-click menu, select Edit With.., and then click InfoAssist.
   
   
   
3. Click File from the Format group of the Home tab on the ribbon.
     
   
   
4. From the Temporary hold dialog box, confirm Temporary is selected above the left navigation pane. 
   
   
   
5. Enter text into the Title field.
   
   
   
6. Confirm Binary (*.ftm) is the selected file format. 
   
   
   
7. Once a file name and file format is identified, click Save.  The Temporary File dialog box will close.

8. Notice the layout of the work area changes. You should now see a Query pane (top center) as well the Create Report function (bottom right). 
   

9. Note the hold file has been created - see the name in the Query pane. 
   
   
   

10. Click Create Report (bottom right), to use the Hold file to create a report to join the hold file to another UC_SADM data table. 
     
11. Notice the workspace changes again. The system assumes you want to create a report using data from that Hold File. 
12. To join the Hold file to another table, click the Data tab and then click Join. 
    
13. Notice the hold file displays in the join dialog box. 
    
14. Click the Add New dropdown and then click Existing.
    
15. For our scenario, navigate to rec_student_groups_dim from the dialog box that displays. 
    
16. Click Open.  
17. Notice a second table displays in the Join dialog box.  
18. Join the the tables together.  Refer to the Basic Table Joins article for more instruction, as desired. 
    Image RemovedImage Added
19. Click OK.  

20. Now create the report, pulling in fields from the HOLD file, as well as from the additional table that we just added. 

21. In this example, the fields are added under the By header, within the Query pane.
    

22. As desired, add filters to mirror the filters from the hold file to maintain the same subset of data that exists in the hold file. 

23. Right-click on a variable under the By heading within the Query pane, select Filter Value...
24. Double-click Value, from the WHERE statement, and click the Value dropdown
25. Identify a Type - Field. 
    Image Removed
    
26. Click to expand the Hold File Name - Student Prog Plan.
    Image Removed 
27. Once expanded, select the field name from the hold file. 
    Image Removed
28. Click OK.
29. Repeat these steps to add additional filters for the remaining filters that existed in the hold file.  

30. Add new filters, specific to the new table that was just joined, as appropriate.  Refer to the Filtering a Report documentation for additional instruction.  
    

31. Click OK to confirm.  
32. Click Run to view the output of the report.  
33. Complete the info within the Parameters dialog box.  
34. Check Run in a new window, as desired. 
35. Click Run. 
36. Review the output. 
    
    
    

Related Articles

...