problem in a Report with a SP as DataSource

[camaleonCHILE]

I wanna make a report in Crystal Reports 4.6 using a store procedure from SQL SERVER 2000 as datasource. This SP was made with dinamic code, and has 4 paremeters. At the end of the SP, I wrote "EXECUTE(string)", executing the code.
In the Query Analizer(SQL S 2000) I don't have any problems, but when I want to link the report to the Store Procedure (In Crystal), I get an error of permissions ( select denied) in one of the tables I use.

Thanks in advance

Regards

 

[Madawc]

I used to use Stored Procedures in Crystal 8.5, and it rejected some things that were OK in Query. Try it without the 'Execute', since Crystal probably does that itself.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10