How do i Change the library(Schema) name in SQL command in crystal report?

[former_member664261]

I am using crystal report XI.I am not able to change the library name in SQL command.

Previously :

It was - Select * from ipslibpy.product (Schema.table);

I need to change like - Select * from ipslib.product(New Schema.table).

When i edit and save it ,It is showing the pop up like failed to retrieve the data.I think it is trying to connect the previoos schema.

[Former Member]

Check that the database user has access to the new schema. Or report may be connected directly to old schema and you can not query from one to another. Check your data source.

Why have you written the command as schema specific?

If you use

Select * from product

And then connect report directly to specific schema you would not have to change SQL.

Ian