Solved

Report Refresh Error

Posted on 2015-01-06
9
305 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
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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 …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now