Parameter help / ReCrystallize

[delsolsf]

Hi there,

I have an odd problem. Using CRXI against MSSQL2000 with a stored procedure. The stored procedure uses 3 parameters.

I've added a selection formula with a parameter. In Crystal, it returns the results correctly, however, when I recrystallize it, when exporting to PDF, it gives me the following error: (FYI, I've talked to ReCrystallize and they said they haven't seen this problem before and its most likely a formula problem.)

Crystal Reports ActiveX Designer error '80047401'

A number is required here.

/reports/grantcentral/test1-dynamic.asp, line 129

Line 129 of the asp code is this:
Session("oRpt").Export False

If I export to the Crystal Viewer, it gives me no error, but yields no results.

Here is the parameter selection formula: (?outcome type is a string)
if {?Outcome Type} = 'All' then
true
else if {?Outcome Type} = '1' then
{mf_spOutcomesRollup;1.IsInitiativeOutcome} = 1
else if {?Outcome Type} = '200001010' then
{mf_spOutcomesRollup;1.DateGroupSort} = '200001010'

Any help and/or suggestions would be much appreciated.

 

[MisterMo]

Hi, could you give an overview of the Stored Procedure

are the 3 parameter mandatory?

if yes how are values given to them?

I have noticed that when using ASP with Crystal, CR tend to pass null values to SP's Parameters and even if I defaulted the value on the SP they are converted to NULL


-Mo

 

[delsolsf]

Here's the sql:

{CALL "Gifts"."dbo"."mf_spOutcomesRollup";1(417, 'Strat1_Caption', 'Spatial1_Caption')}

I find it interesting that when I add the record selection formulas and then check the SQL (Database/Show SQL Query), it never shows the record selection information, only the call to the stored procedure above.

Again, if I recrystallize the report without the record selection criteria, it works fine. The report prompts me for the values to enter. I haven't experienced your null value problem you described.

 

[lbass]

If your parameter selection formula were in CR, it wouldn't work because there are three different datatypes as results of the formula: a boolean, a number, and a string.

-LB