I cannot change the store procedure name, it is allowing to put just the same name. any Idea?

[vmjrojas]

I want to change the Overriden Table Name but it is not allowing me to do that, it is removing the name after writing it, it can just use the same name as it has in the Table Name field

[DonWilliams]

You may not see the tables from that tree, when Using a Stored Procedure CR uses the LAST SELECT statement in the SP, typically it's a SELECT * FROM Tables_above, tables will be listed under the INFORMATION_SCHEMA

So if you connect your report to a Stored Procedure all you are going to see are the Table/Fields as defined in the SP.

If you want to connect to one of your Tables in the database along with your SP then insert a Subreport and connect to your DB tables.

CR is a relational Database Reporting Tool meaning the tables MUST be linked, otherwise you get the data from the first field, or wherever the pointer is on the server, and it retreives one row of data.

The other possible issue is your DB, typically Oracle, has a lot of info and CR is limited as to how much it can display.

Right Click on your Connection and select Options:

You can uncheck various views to reduce the amount of info queried in the Data Explorer area and/or use LIKE options to add more filtering

[DonWilliams]

You can't edit the SP name there.

Click on Database, Database Expert, you should see the connection on the right, right click on the SP name and see if you can change it there.

If not then change the name of the SP server side.

[vmjrojas]

I can't see the tables