Report won't run, Looks to be calling a Stored Procedure

[demosoc]

Good Afternoon,

I'm looking at a "broken" report that only sometimes runs, and when it does it returns blank. Otherwise I get a row error.
The report appears to be calling a stored procedure, but we're not quite sure. When looking in the Database Expert, the stored procedure appears as a regular table being called from the Database, but there is no such table nor is there a stored procedure in the database that matches. When exiting the Database Expert I get this warning, "More than one datasource or a stored procedure has been used in this report. Please make sure that no SQL Expression is added and no server-side group-by is performed."

I've tried looking under "Show SQL query" but all it does is call the parameters for the alleged stored procedure, and when I fill the parameters in, the report runs and returns blank. I'm unable to see what's going on.

I'm on Crystal 9.2.
Any ideas?

 

[dgillz]

Under file, options, is your version of crystal set to look at SPs?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Madawc]

From what you say about "Show SQL query", I think you do have one. Have you tried looking AFTER the report runs and returns blank?

Another option is File > Export > Report Definition. This will show what you've got.

It is possible that your machine cannot access the file the SQL is reading. Where I work, some data is extra confidential and special permissions are needed to look at it on a particular machine. Such a report would fail on another machine.

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

 

[Madawc]

PS. In Crystal 10, at least, you can click on the 'Command' and choose Edit, which gives you a look at it. Also the file can be given a different name, and name the developer chooses.

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

 

[demosoc]

Thank you for all the feed back- here's the skinny:

1. Under file, options, is your version of crystal set to look at SPs?
YES

2.From what you say about "Show SQL query", I think you do have one. Have you tried looking AFTER the report runs and returns blank?
YES, just get the parameter input data

3. It is possible that your machine cannot access the file the SQL is reading. Where I work, some data is extra confidential and special permissions are needed to look at it on a particular machine. Such a report would fail on another machine.

Aha! That was the problem. And not just the machine; it turned out to be the DB login within Crystal! So both the machine and the DB permissions were required.

Thanks so much for all the help!