TOPIC: The table ......could not be found

The table ......could not be found 30 Jul 2009 05:20 #493

  • zzhou
  • zzhou's Avatar
Hi, I have a report (CR 8.5) using a stored procedure to retrieve data from SQL 2000 database.It works fine with Logicity Desktop (version 1.6). But when I add it to a RRD file and execute in Solution Builder, the system will give me error "The table 'myStoredProcedure;1' could not be found....". I have tried few other reports using SPs and got the same error. The system always tell me it couldn't find TABLE instead of Stored Procedure. If I change the report to read data from table directly, it works fine in Solution Builder. I can email, save and print the report.

Has anyone got this issue before?

Youe help is much appreciated.
The administrator has disabled public write access.