Seal Report Forum
	 » 
	Report Edition
	 » 
	Reports
	 » 
	How do I use input values in SQL Models
	 
	
        
            
            
    | 
	Rank: Advanced Member
 Groups: Registered
Joined: 5/18/2018(UTC)
 Posts: 40
 
 Thanks: 2 times
 | 
            
		      
                Is there a way to use variables set in the Input Values under General in SQL Models?  
 For instance, if I have input values set up in the collection as "year" and "month", should a SQL Model with
 
 Select {CommonValue_year} as year, {CommonValue_month} as month
 
 return a one record result with the entered values?  If not, what are those called?  Or do I need a script in the pre-load script to set the common values to the input values?
 
 Thanks.
 | 
    | 
             | 
            
         | 
    |  | 
        
        
        
            
        
            
            
    | 
	Rank: Administration
 Groups: Administrators
 Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 timesWas thanked: 206 time(s) in 199 post(s)
 
 | 
            
		      
                Yes it works (for Common Values not Input Values)  In attachment is a sample to display the Common Value prompted to the user.   select common value.srex (5kb) downloaded 6 time(s). Edited by user Friday, December 17, 2021 1:39:29 PM(UTC)
 | Reason: Not specified | 
    | 
             | 
            
         | 
    |  | 
        
        
        
    
        
            
            
    | 
	Rank: Advanced Member
 Groups: Registered
Joined: 5/18/2018(UTC)
 Posts: 40
 
 Thanks: 2 times
 | 
            
		      
                Where do you declare the common values?  
 When I go into my report sources 'common restrictions and values', there's no add or remove buttons.
 | 
    | 
             | 
            
         | 
    |  | 
        
        
        
            
        
            
            
    | 
	Rank: Administration
 Groups: Administrators
 Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 timesWas thanked: 206 time(s) in 199 post(s)
 
 |  | 
    | 
             | 
            
         | 
    |  | 
        
        
        
    
                           
	Seal Report Forum
	 » 
	Report Edition
	 » 
	Reports
	 » 
	How do I use input values in SQL Models
	 
	
    
        Forum Jump
         
	
    
    You cannot post new topics in this forum.
	
	You cannot reply to topics in this forum.
	
	You cannot delete your posts in this forum.
	
	You cannot edit your posts in this forum.
	
	You cannot create polls in this forum.
	
	You cannot vote in polls in this forum.