Solved

Report Refresh Error

Posted on 2015-01-06
9
310 Views
Last Modified: 2015-02-12
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
0
Comment
Question by:reachsoma
  • 3
  • 3
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40533702
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
 

Author Comment

by:reachsoma
ID: 40534935
Hi,
I have used the same data base.
I already did verify database, but giving same error.

Thanks
Sam
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40534968
Have you tried editing the command?

Have you tried setting the datasource location?

mlmcc
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

Author Comment

by:reachsoma
ID: 40535060
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
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 40536326
If you eliminate the CreatedBy.Name field, does it work?

mlmcc
0
 

Author Comment

by:reachsoma
ID: 40537461
We have not used this CreatedBy.Name field in the report.

Regards
Sam
0
 
LVL 13

Accepted Solution

by:
PCIIain earned 250 total points
ID: 40538009
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

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question