Stored Proc and Crystal

Question

Stored Proc and Crystal

myschif

Say Hey Kid

Points: 695
More actions
January 18, 2006 at 10:49 am

#113159

Hello,
I have created a stored proc and created a crystal report based on the proc. Everything worked well until I needed to add another parameter to the proc. I am now unable to get crystal to acknowledge the change. I have tried the "Verify db" option but the proc expects the additional parameter.
How do I get the two to work together w/o recreating the report? :
Thanks in advance.

"Some like to understand what they believe in. Others like to believe in what they understand."
--Stanislaus J. Lec

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

AlwaysLearning SSChasing Mays Points: 627 More actions · Answer 1

My guess is that the XSD (dataset file) is out of sync with the new proc. You should be able to access the XSD file and add the new parameter to the dataset. Then refresh database in the crystal report and it will see it.

HTH

Mark

myschif Say Hey Kid Points: 695 More actions · Answer 2

Hi Mark,

I am unsure where the XSD file exists at. Is it like a text file?

"Some like to understand what they believe in. Others like to believe in what they understand."
--Stanislaus J. Lec

AlwaysLearning SSChasing Mays Points: 627 More actions · Answer 3

If you have one you should see it in the same project as the Crystal report.

When you created the Crystal Report, how did you establish the link to the stored procedure?

Mark

myschif Say Hey Kid Points: 695 More actions · Answer 4

Mark,

Here is how I solved it:

1. Database Menu

2. Set Datasource location option

3. set the datasource to the same stored proc

4. Crystal Prompts for the new parameter's value.

Thanks for your time.

"Some like to understand what they believe in. Others like to believe in what they understand."
--Stanislaus J. Lec