Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Ian

    Add comment
    10|10000 characters needed characters exceeded