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!