index > Crystal Reports for Visual Studio > Using Stored Procedure's input parameters to create formulas

Using Stored Procedure's input parameters to create formulas

Hi everyone!
I created a CR2008 rpt using VS2008. This report will export data from a stored procedure. I created a header that shows the filters that the user chose. Those filters are the stored procedure's input parameters. Those parameters can be null. So I created a formula to format those values.

Formula @User.

IF ISNULL({?@I_USER}) THEN
    "<All>"
ELSE
    {?@I_USER}

So {?@I_USER} is a stored procedure's parameter. When I preview the report using Crystal Main Report Preview Tool, it works fine. But when I run the application (VB.NET), occurs the following error: "field is not known".

Any ideas?

Xisvaldo Thursday, October 08, 2009 12:38 PM

I solve the problem passing parameters in VB code.

reportObject.SetParameterValue(PARAMETER, VALUE)

The current problem is: I have some datetime's fields that can receive NULL values (optional). How can I convert?

Marked As Answer byHarry ZhuMSFT, ModeratorMonday, October 12, 2009 4:09 AM

Xisvaldo Friday, October 09, 2009 1:21 PM

Marked As Answer byHarry ZhuMSFT, ModeratorMonday, October 12, 2009 4:09 AM

Xisvaldo Friday, October 09, 2009 1:21 PM

You can use google to search for other answers

Custom Search

More Threads

• Crystal reports create rpt dinamically

• how sum values on crystal report?

• Crystal Reports

• Suppress Details sections

• sub reports that are inside of sub reports do not appear.

• change field at runtime

• CR 9 Deployment issue on web server

• Appdomain created an new thread use

• CR 2005 messes up 9.2 Developer install?

• Display multiple order in single row