pass parameters to sub report which calls stored procedure 1

[mariam]

I have a VB program (v6) that calls a CR (v6) with 2 parameters. I want to pass these parameters to a subreport which calls a stored procedure with these 2 parameters. The only way I get the subreport to give the right info is by hardcoding the parameters in the "database/Stored Procedure Input Parameters" area. I need it to use the parms passed by VB. Thanks a lot for any help.

 

[KathrynC]

Can any of the parameters get to the database? In other words, if you called a report that wasn't a sub report and that report called a stored proc, would the parameter work? If not, there may be an issue on the database end. Some databases need to be tweaked in order to pass parameters from crystal to stored procs.

If the direct paramter pass works, that would point to a problem in the Crystal link, much tougher.

K

 

[mariam]

The stored procedure with passed parameters does work on its own and if I run the stored proc from Crystal with hard coded parameter values. I guess it's the tougher problem. Thanks