Crystal 8.5 bug ? Problem with stored procedures

[foxid]

Hi guys, i got a problem with SQL 2005 and Crystal 8.5
I created an SP in SQL 2005 and display the results in Crystal. But some of the fields got wrong value.

Example the SP returns field A & B
field A should be 0 ( i try exec the sp) but instead Crystal fill field A's value with B.

The stored procedures is quite complex and i don't think i can post them all. Anyone ever bumped to this problem ?
I suspect it's a bug in Crystal...

thx...

 

[AndrewBaines]

Bit harsh blaming it on Crystal 8.5 released last century!
Download SQLCon32.exe (should still be on support site).
It lets you run the query in a command like interface to check if the problem's due to Crystal or the DB.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[Tatertot45]

Sounds like a straight-forward linking issue to me. I'm not much of SP guy, so i can't say for sure. CR used to do that to me when i had the wrong table joins.

 

[AndrewBaines]

This is an SP, so linking shouldn't be an issue - that will all be done in the SP with nothing to do with Crystal.

If it's a fault in the SP, then should be able to pick that up in SQL Analyzer.


Andrew Baines

http://www.pursuittechnology.co.uk