Skip to Content
0
Former Member
Jan 05, 2012 at 04:15 PM

Missing parameter in stored procedure

297 Views

Hi all,

I am new to Crystal Report, and I am facing this situation:

a file .rpt reporting results of a sql server stored procedure, which takes one parameter in input.

This .rpt is invoked by an .net web service, via libraries, passing the parameter.

Now I evolved this stored procedure by adding a new parameter. Each of the two parameter is optional; the stored

procedure returns correctly formatted data with one parameter, the other one, both or none.

Then I adapted the .rpt file so that it can manage the updated stored procedure, via "Verify Database" istruction.

Also the .rpt has obviously two input parameters now, with a default value.

The problem is, the web service acting as handler gives the error "Missing parameter values", because actually it is passing still

one parameter.

If I update the web service code by passing both parameters, even with null value, it works, but for internal reasons I can't deploy

this updated code now 😔

So, there is a way by modifying the .rpt using a stored procedure with two parameters, to make the invocation successfully even with one input parameter ?

The missing parameter would have, in the execution logic now, value null or default; it could fit for me.

Thanks in advance to everyone who will give advice!