Solved

Parameter Values from Stored Procedure

Posted on 1998-07-24
2
168 Views
Last Modified: 2010-05-03

hi there, i am using crystal report 5.0, and i have a stored procedure from informix,
that asks for two parameters, when i run my report can i get the value of the paramaters
that i asked from the stored procedure? how can i do this?  

0
Comment
Question by:mallow
2 Comments
 
LVL 2

Expert Comment

by:percosolator
ID: 1466590
Yes, you can pass parameters to a SP.


0
 
LVL 1

Accepted Solution

by:
BlackAndWhite earned 50 total points
ID: 1466591
No you cannot access the stored procedure parameters directly.  You have to include the stored procedure parameters in the select statement.

Say your select statement in stored procedure is
"Select * from tblProducts" then

change it to
"Select *, @ProductCode, @ProductId from tblProducts"

where @ProductCode, @ProductId are the parameters.

I am definite that you cannot access stored procedure parameters directly.  I even talked to the Crystal tech support on this.

Note: To set the values of stored procedure parameters from vb, using crystal activex, use .StoredProcParam property.


0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question