Crystal 2008 issue with Stored Proc.

[fmrock]

Hello Everyone,

I have a report that pulls data from a Stored Procedure in SQL 2005 Server. We have updated the logic in this procedure, but the report does not see this change.

I can create a new report that pulls this stored procedure and it pulls the data just fine.

I would be tough to recreate this report has it has 15-20 sub reports it runs.

The one thing that is weird about this report is that it was originally created to pull from a table called "ChartServices" and then updated by setting data source location to point to this stored procedure. However, it when you update a table to point at a stored proc, it always seems to keep the table name around.

Any ideas or suggestions to try?

 

[IanWaterman]

When you move a report from looking at a table to another table or Stored Proc, Crystal retains alias of original table.

Assuming you are using Cr9 or later, go to database -> database expert right click table and rename as required.

Have you verified report so that it picks up any changes to SP
Database -> Verify database

Ian

 

[fmrock]

We are using CR 2008. We even tried it in CR9, with the same results.

I have also changed the Alias and did the Verify database.

 

[IanWaterman]

Is the stored Proc on a different database/schema.

Could be that old report is still looking at/connected to previous schema?

Try this

Database->Set datasource location

Click plus sign next to SP and drill down to details
Right click overridden qualified table name and enter name of SP.

Ian