Skip to Content

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

Jul 26, 2017 at 12:52 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ian Waterman Jul 26, 2017 at 02:20 PM

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.


10 |10000 characters needed characters left characters exceeded