Crystal Report 9 - Change the Stored procedure

[RSX02]

Hi
I know crystal report 8.5 and less but now I have to work with 9. I'm trying to update the stored procedure. (I have to choose another stored procedure as I add fields in it)

As in Crystal 8.5 we would do
Database - Set Location and then choose the new SP.
How can I do this with Crystal 9?
Thanks in advance

 

[synapsevampire]

Here's the whitepaper:

http://support.businessobjects.com/library/kbase/articles/c2012382.asp

-k

 

[RSX02]

Ok
That's what I did
Now I'm doiing a Verify Database and it tell me:
The database table "Rpt_OrderVerificationSp;1" cannot be found. Proceed to remove this table from the report?

If I say Yes it take off all the field that I have in my report.

What should I do?

 

[synapsevampire]

So you can point at it during the steps in the wehitepaper, yet the verify database says that it doesn't exist?

That doesn't make sense, perhaps there's some sort of problem within the SP?

I suppose it might be a connectivity issue as well as a few other things.

Here's a whitepaper on using the Add Command object which is a new way of setting data sources:

http://support.businessobjects.com/library/kbase/articles/c2013031.asp

-k

 

[RSX02]

If I'm trying to do a new report with this stored procedure..when I'm trying to add the stored procedure to the report it gives me this error:
Query Engine Error: '42000:[Microsoft][ODBC SQL Server Driver}{SQL Server]Invalid length parameter passed to the substring function.'
Any idea????
Thanks in advance

 

[pandpp]

You have an issue with the Stored Proc.

I take it you are passing parameters to the SP from CR. On one of these Params, you are doung a substr. Sounds like you might have passed a NULL value through to that param, hence, you can't substr a NULL.

There are any number of possibilities. Post some code so we can see.

Peter.