Parameter Values from Stored Procedure

Posted on 1998-07-24
Medium Priority
Last Modified: 2010-03-19
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?  

Question by:mallow
1 Comment

Accepted Solution

mayhew earned 100 total points
ID: 1089193
To my knowledge, Crystal does not allow access to stored proc parameters at run time.  The only way I have found to do this is to include your parameters in your return set.

I'm not sure about informix, but in MS-SQL if you're going to return data, the last line of your stored proc is usually a select like:

In this example, #TABLENAME is a temp table that holds the dataset you want to return.

If your input parameter is named @inparam, your select would become:
SELECT *, @inparam AS "paramname" FROM #TABLENAME

This is not totoally efficient as it returns your parameter(s) in every row of your result set.  But you can exlude that field from the detail section of your report and just include it wherever you want.

Hope this is helpful!   :)


Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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.

Join & Write a Comment

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

619 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