Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | vivianandStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2004-06-22 : 11:01:49 
 |  
                                            | I am trying to used a stored proc that has an input parameter for a Crystal Reports sub-report.  I am having difficulty figuring out how to pass the input parameterThanks |  |  
                                    | nrSQLTeam MVY
 
 
                                    12543 Posts | 
                                        
                                          |  Posted - 2004-06-22 : 12:26:57 
 |  
                                          | When you add the sp to the report it will ask for sample parameters to get the data.How you assign them at run time depends on how you rn the report.When you do a refresh it wil prompt or if you run it from VB you can use the object model to set the params.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |  
                                          |  |  |  
                                |  |  |  |