Skip to Content
avatar image
Former Member

Issues in running crystal reports 2013 with SOQL as a datasource

Hi Experts,

    

We have some crystal reports created in CR 2008 with command as a data source and all the commands are written in SOQL pulling data from SFDC, now when I open and run those reports in crystal report designer 2013 it is giving below errors:

--------------

Failed to retrieve data from the database.
Details: 42S22:[Simba][SQLEngine] (31400) Qualified column could not be bound: c.Investor__r.Relationship_Formula__c. [Database Vendor Code: 31400 ]

------------

Failed to retrieve data from the database.

Details: 42S22:[Simba][SQLEngine] (31400) Qualified column could not be bound: k.Account_Relationship__r.PE_Priority__c. [Database Vendor Code: 31400 ]

------------

We are running crystal reports in both the version with system admin user who has access to all the objects in SFDC. It works well for CR 2008 but not for CR 2013, means relationship is not an issue.

We have done some analysis and found that if the field in query contains two periods (.) it is not recognising that field, if we remove that field from query, CR 2013 takes that as a valid statement.

Any help or suggestions on this issue would be a great help.

Regards,

Apoorv

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 29, 2014 at 01:13 PM

    Hi,

    You can first open and update the connection in cr 2013 designer..

    Database -> set datasource location -> update the connection here . You can find the error easily.

    The report works in cr 2008 but not in cr 2013 i am wondering this could be the problem..No Please provide you are getting the error details.


    Thanks,

    DJ

    Add comment
    10|10000 characters needed characters exceeded