Solved

Report Refresh Error

Posted on 2015-01-06
9
311 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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

839 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