Report Refresh Error

Hi All,

We are trying to migrate Crystal reports version 2008 to CR 2013 which are developed using sales force.com connection as data source. These reports are build based on the “command” object connection and it is throwing error while try to refresh in the 2013.
Below is the error we are getting:
Failed to retrieve data from the database.
Details: 42S22:[Simba][SQLEngine] (31400) Qualified column could not be bound: k.CreatedBy.Name. [Database Vendor Code: 31400 ]

Can you please let me know how to get resolve this issue?

Thanks
Sam
reachsomaAsked:
Who is Participating?
 
PCIIainConnect With a Mentor Commented:
It doesn't have to be used in the report, only defined in the sql script/command. Copy the command to an editor and search for this field name, if it shows up then Crystal will try and get it from the database.

Where a command is used rather than connecting tables together in the database expert , then the first thing crystal does is run the script as entered against the database. It then does all it's sorting/filtering/grouping stuff against the result set.

When you connect tables together in the database expert, crystal then decides which fields to request from the database based on the fields used in the report, but a command bypasses this and just basically runs the command sql script directly in the database without (many) modifications.
0
 
mlmccCommented:
Try doing a VERIFY DATABASE.

Does the SQL run in the database?
Are you using the same data source and just Crystal has changed?

mlmcc
0
 
reachsomaAuthor Commented:
Hi,
I have used the same data base.
I already did verify database, but giving same error.

Thanks
Sam
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
mlmccCommented:
Have you tried editing the command?

Have you tried setting the datasource location?

mlmcc
0
 
reachsomaAuthor Commented:
Yes. I have edited the command, but when we say ok, it is giving error.
I have tried set data source location as well.

Thanks
Sam
0
 
mlmccConnect With a Mentor Commented:
If you eliminate the CreatedBy.Name field, does it work?

mlmcc
0
 
reachsomaAuthor Commented:
We have not used this CreatedBy.Name field in the report.

Regards
Sam
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.