Crystal Report Error

[tfurman]

This is the situation (CR 6). When the reports that we have were first compiled we were using a different server. Now we have moved all the views and stored procedures to a new server. We want to modify the repors using the new fields that are in the stored procedure. This is where a problem occurs when I try to verify the database I get an error "Can't open the file: the are not fields in that stored procedure." Can anyone help me with this?

 

[kenhamady]

You may need to set the location of the SP before you can verify it. Try 'Database - Set Location'. Once the location is set it will notice any changes in the file automatically. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[tfurman]

I have done that I still get the error

 

[kenhamady]

Can you create a new report against the SP? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[tfurman]

No, I can't

 

[kenhamady]

That is a completely different problem.
Do you get the same error when you try to create a new report off of the SP?

Do you have any permissions or Access issues with getting to this SP?

Can you view the SP from another tool like MS Access? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[FowlerConsulting]

Make sure that you have "View Stored procedures" turned on in your ODBC config, as well as in CR under Options...

Steven Fowler
info@fowlerconsulting.com

http://www.fowlerconsulting.com

 

[tfurman]

when I try to connect through msquery I am able to see only the tables but not the stored procedures.

 

[kenhamady]

Sounds like you might have a permissions problem. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal