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.