Stored procedures orientation

I need some orientation on the use of stored procedures on SQL Server 6.5 and Crystal Report on VB 6.0. I have created some stored proc with parameters. When designing a report in Crystal, he ask me to enter a value for the parameters, all is fine. When I want to show the report, how can I change the value of the parameter? Where I must do this, in VB or Crystal?
pjroyAsked:
Who is Participating?
 
cognitionConnect With a Mentor Commented:
If you are running the report from within VHB using a crystalk control then you can use the following syntax :

CrystalReport1.StoredProcParam(0)=”06/14/1989”
CrystalReport1.StoredProcParam(1)=10

If you just run the report from crystal then the user will be prompted for the parameters.

0
 
pjroyAuthor Commented:
Great, finally it is real simple, but you save me a lot of research.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.